Easy import template validation

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.