Excel import truncation: field value exceeded maximum length

Excel cell contains text data that exceeds the target ServiceNow field's maximum character limit defined in the dictionary entry. (high likelihood)

The target field is a string field with a small max_length value that doesn't accommodate the imported data size. (high likelihood)

Excel cells contain hidden characters, line breaks, or formatting that increases the actual character count beyond visible text length. (medium likelihood)

Import mapping is incorrectly configured to map large text fields to shorter target fields like short_description instead of description. (medium likelihood)

Excel file contains merged cells or complex formatting that expands the data size during import processing. (low likelihood)

Step 1: Navigate to System Definition > Tables and locate the target table to identify which fields have length restrictions that might be causing the truncation.

Step 2: Check the Import Set table at System Import Sets > Import Sets to review the raw imported data and identify which rows contain the oversized values.

Step 3: Go to System Import Sets > Data Sources and open your import configuration to review the field mapping between source Excel columns and target table fields.

Step 4: Navigate to System Definition > Dictionary and search for the problematic target field to check its max_length property and determine if it can be increased.

Step 5: If the field length can be increased, modify the max_length value in the dictionary entry to accommodate your data requirements, keeping in mind database performance implications.

Step 6: Alternatively, modify your Excel file to trim the problematic cell values to fit within the existing field length constraints before re-importing.

Step 7: Consider remapping the import to use a larger text field in the target table if one exists, such as mapping to 'description' instead of 'short_description'.

Step 8: Re-run the import after making your chosen correction and verify the data loaded correctly without truncation in the target table records.