How to Import data into service now tables without using transform map?

[keshav77]

How to Import data into service now tables without using transform map?

[Dr Atul G- LNG]

Hi @keshav77 

Use XML based.

https://youtu.be/irp8J6rkgqQ?si=GUDP7OVDCphYVL56

[Moin Kazi]

Hi @keshav77 ,

You can use the Import template to load data into ServiceNow without needing to create a Transform Map.

Steps:

Step 1:
Navigate to the list view of table. Right-click on any column and select Import.

Step 2:
Click on Create Excel Template. Once the template is downloaded, enter your data in the spreadsheet and save it.

Step 3:
Return to the same location, upload the saved template file, and click Submit. Then, click Preview Import. Finally, click Submit Import to load the data.

See the image below for reference:

-

If you have XML file so you can directly right click on list view, column header and click import XML to load xml file in snow.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

If you found my response **helpful**, I’d appreciate it if you could take a moment to select **"Accept as Solution"** and **"Helpful"** Your support not only benefits me but also enriches the community.

Thank you!
Moin Kazi
www.linkedin.com/in/moinuddinkazi

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

[jyotigupta]

Hi Moin,

how can i get the same functionality , i need to load data in import set table using my custom excel upload.

[NiloferShaik]

You need to have matching column names in spreadsheet and the import set table.