Importingspreadsheet datainto 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 toSystem Import Sets > Load Data.
Upload thespreadsheet (CSV, Excel, etc.)or connect to anexternal data source.
The system creates anImport Set Tableto temporarily store the imported data.
ATransform Mapis created to definehow fields from the Import Setmap to fields in thetarget table(e.g.,incident,cmdb_ci).
Field mappingscan be manually configured orauto-mappedif field names match.
Coalesce fieldsare defined toprevent duplicate recordsby identifying unique keys.
TheTransform Mapis executed, transferring data from the Import Set to thefinal target table.
Anytransformation 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 createdafter data is loadedinto the system.
C. Select Data Source, Schedule Transform
WhileData Sourcesdefine where data comes from, theydo not load data directly.Scheduling transformationsis 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 isnot 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: