Importing spreadsheet data into a ServiceNow table follows a structured process that ensures data is accurately mapped and transformed before being added to the target table. The correct process consists of three main steps:
Navigate to System Import Sets > Load Data.
Upload the spreadsheet (CSV, Excel, etc.) or connect to an external data source.
The system creates an Import Set Table to temporarily store the imported data.
A Transform Map is created to define how fields from the Import Set map to fields in the target table (e.g., incident, cmdb_ci).
Field mappings can be manually configured or auto-mapped if field names match.
Coalesce fields are defined to prevent duplicate records by identifying unique keys.
The Transform Map is executed, transferring data from the Import Set to the final target table.
Any transformation scripts (such as data conversions) are applied during this process.
The imported data is now available in the production table.
1. Load Data (Import Set Creation)2. Create Transform Map (Mapping Fields to Target Table)3. Run Transform (Apply Data to the Target Table)
B. Select Import Set, Select Transform Map, Run Transform
You must first load data before selecting an Import Set. Import Sets are created after data is loaded into the system.
C. Select Data Source, Schedule Transform
While Data Sources define where data comes from, they do not load data directly. Scheduling transformations is optional, but it's not the primary step-by-step method for importing data.
D. Define Data Source, Select Transform Map, Run Transform
Defining a Data Source is part of setting up external integrations, but it is not required for a basic spreadsheet import.
Why Other Answers Are Incorrect:
ServiceNow Data Import and Transform Maps
ServiceNow CSA Training Module: "Importing Data and Managing Import Sets"
References from Certified System Administrator (CSA) Official Documentation:
Submit