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. Server-side validation Instance The import pauses and displays an error message. 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.