In ServiceNow,Import Setsallow administrators toimport and transform datafrom external sources into ServiceNow tables. The platform supports multiple file formats for importing data, includingXML, CSV, and Excel.
XML (Extensible Markup Language)
Used for structured data exchange between systems.
ServiceNow canimport XML filescontaining records formatted according to its schema.
CSV (Comma-Separated Values)
One of the most common formats for bulk data imports.
ServiceNow can processCSV filesand map them to target tables.
Excel (XLS/XLSX)
ServiceNow allows direct imports fromMicrosoft Excel spreadsheets.
Users can upload Excel files via the Import Set UI.
Supported Data Formats for Import Sets:
Import Data:The user uploads a supported file (XML, CSV, or Excel) into an Import Set table.
Mapping:The imported data is mapped to target tables using aTransform Map.
Transformation & Processing:Data is transformed, validated, and inserted into the correct destination tables.
How Import Sets Work in ServiceNow:
A: CSS, SOAP, and Excel#CSS is a styling language, and SOAP is a protocol, not a data format.
C: SOAP, REST, and XML#SOAP and REST areweb service protocols, not file formats used for import sets.
XML is valid but alone is insufficient.
D: XML, SOAP, and CSS#SOAP and CSS are incorrect as they are not standard import file formats.
Why Other Options Are Incorrect:
ServiceNow Documentation:Importing Data into ServiceNow
CSA Exam Guide:Coverssupported data formats for Import Sets (XML, CSV, and Excel).