Easy import template validation

  • Release version: Zurich
  • Updated July 31, 2025
  • 1 minute to read

    • Each import template must pass two sets of validation.

    Table 1. Template validation
    Type of validation Stored in Results of failing validation
    Client-side validation Import template

    The template highlights the invalid cell.

    Import template client validation
    Server-side validation Instance

    The import pauses and displays an error message.

    Import template server validation

    Template data validation

    Some cells in the template contain calculations or validation rules. These rules are intended to help you enter data that is appropriate for the field (column).

    If you want to paste data from another spreadsheet, use the Paste Special command to paste only values or match the existing formatting.

    Figure 1. Easy import paste special
    Figure 2. Paste special values only

    Template type validations

    Server-side validation verifies that the import template contains the necessary format.

    Table 2. Template type validation
    Template type Validation done
    Insert template
    • Template contains a header row with valid field names.
    • Template contains one or more data rows.
    • Template does not contain a sys_id column.
    Update template
    • Template contains a header row with valid field names.
    • Template contains one or more data rows.
    • Template contains a sys_id column to match a row to an existing record.

    Data type validations

    Both client-side and server-side validation verify that template cells contain data that matches the ServiceNow field type.

    Table 3. Data type validations
    ServiceNow field type Validation done
    Choice list Cell contains a value that matches a choice option from the choice list.
    Integer Cell contains a number without any decimal points.
    Reference Cell contains a value that matches an existing related record. This validation applies only to fields in which the list of possible choices is relatively small and mostly static. It does not apply to fields such as ‘Assigned To’ in which the list of possible choices is dynamic and large. Validation takes place when the data is inserted into the database, but not in Excel.
    Note:
    When you enter reference field values in the Excel spreadsheet, enter the display value and not the sys_id of the referenced record. Enter this value the same as you would on a form. For example, for a reference to a user record, enter the username.
    True | False Cell contains a true or false value.