Upload data to a custom table

[Jen11]

Hello,

We have a custom table called u_distribution_security.  I have an excel file with data, I would like to upload the data from the excel file to the custom table.

How would I do that?

[Alberto Consonn · Accepted solution]

Hi,

you have to go through the Import Set standard steps, you can easily fit your need simply following the below documentation:

Importing data using import sets

• Create the Data Source
• Create the Transform Map
• Run an import

Hope this will be useful for you.

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

Thank you

Cheers
Alberto

[Jen11]

Thank you for your help.

For Create the Transform Map, I'm not sure what I should select for Source table.

[Pradeep Sharma]

Hi Jen,

Start with Load Data Module i.e System Import Sets->Load Data->Select the option "Create Table" and update the Label name to the source Table that you would like to create->Once done click on submit and then follow the steps shared by @Alberto above.

-Pradeep Sharma

[Alikutty A]

Hello Jen,

Here are few sample videos that could help you to learn import sets and how to load data from excel into a Service Now table.

https://www.youtube.com/watch?v=y43JWghmH28

https://www.youtube.com/watch?v=NZ5MNgHMSxU

Thanks!