Add a table to the existing list of import set tables

[becks_kirk]

I have an excel file that I'd like to load against an existing table in ServiceNow. My issue is that when I attempt to "Load Data" the table isn't listed in the existing tables list. How would I go about getting this table added so I can update the table with 300 records in an excel file?

[SanjivMeher · Accepted solution]

If you are using Load Data option, It is actually asking you for an import set table.

Import set table will be a staging table, where data will be stored temporarliy. And then you can create a transform map to map that table.

So you should select Create Table option.

Another option is directly go to the main table, where you want to load data. And rigth click on header and select Import, where you can directly load data.

[becks_kirk]

Thank you! My next issue is having a script for inserting the records... Not sure where to start on that.

[Jaspal Singh]

Hi Becky,

You need to create a new table "ABC" & make sure you set the Extends as "Import set row". Then add all the fields in the excel to the table.

Thanks,

Jaspal Singh

Hit Like/Helpful or Correct based on the impact of answer.

[becks_kirk]

Thank you! My next issue is having a script for inserting the records...