How to insert excel spreadsheet data into a table

[SNExploreGuru]

Hi,

I have a task to create records in a specific table in ServiceNow with spreadsheet data( ~60K rows), I don't want to do it manually as it takes months time.

Is there any way where I can import automatically in one go or any other option.

Thanks in Advance.

[Muhammad Khan]

Try looking into Import sets. Refer to below link for better understanding.

Exercise: Import Historic NeedIt Data 

[Mike_R · Accepted solution]

Here's a good video I found that goes over importing from excel

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

[Gontla Mythily]

Hi,

You can use import sets to import excel sheet into instance.

Steps:

1.Go to system import sets>load data , select file option and upload your sheet.

2. Create transform map, mention target table name where u want to import.

3. Map the fields from source table to target table.

4. Click Run transform.

Mark as correct if it helps you.
Regards Mythily.

[Akin1]

Looks like you will need to use import sets to help achieve your goal. You can use this link to research some of the best options for you. https://docs.servicenow.com/bundle/tokyo-platform-administration/page/administer/import-sets/referen...