How to format in creating a CSV to export directly into ServiceNow table

[SooraC]

Hi everyone,

I am working on formatting a CSV file to import data into a ServiceNow table. I want to make sure the data is in the correct format for a smooth import process.

Can anyone guide me on where to find the correct field names and order for the CSV? This will help ensure that ServiceNow can successfully import the data and populate the table correctly.

Looking forward to your responses!

ps. adding the screenshot of the table fields below:

Thank you!

[Dr Atul G- LNG]

Hi @SooraC 

To import data into SN, the best practice is to use the ServiceNow-specific template. Go to the native view of the relevant table, click on any field, and then import/download the Excel format. This way, you can bring your data into the relevant fields. By doing this, it's easier to perform field mapping during the transform map.

You can also use your own format, but in that case, you'll need to manually do the field mapping during the transform map process.

[Rohit Singh]

Hi @SooraC ,

You can upload the data in ServiceNow table using Import set and use transform map to do the mapping of source filed to the target field.

If the mapping is complex then you can also explore Transform Script to achieve dynamical mapping of fields.

If my response helped, please mark it helpful and accept the solution so that it benefits future readers.

Regards,
Rohit

[Medi C]

Hi @SooraC, 

A csv with the same header as your screenshot should do the work. You can load the data in ServiceNow (System Import Sets > Load Data) to let ServiceNow create the import set table for you based on the uploaded file.

Rest would be on you to define the field mapping.

Something to bear in mind while working with CSVs, Ensure that your csv does not have BOM characters. Otherwise, you will have weird characters on your tables.

How to identify an Import CSV file having UTF-8 or UTF-16 BOM characters?
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1581735

How to import csv which charset is UTF-8 BOM?

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0827242

 

[Ankur Bawiskar]

@SooraC 

how are you bringing the csv to ServiceNow?

how are you planning to load that data?

You can add that file to data source, trigger the transform map and load the data.

If my response helped please mark it correct and close the thread so that it benefits future readers.