How do I create specific catalog item records from Excel sheet (~700 records)

Brian Hatt
Tera Contributor

I created a new catalog item named "Student Loaner Program", that contains a dozen custom fields. I have an Excel spreadsheet with about 700 rows that I need to import into ServiceNow, resulting in 700 newly inserted records of the Student Loaner Program item.

The spreadsheet has 30+ columns of data. I was hoping to be able to load that data into ServiceNow, then somehow use a transform map to map 12 of the columns from the spreadsheet to the 12 fields on my Student Loaner Program requested item, then have it transformed and insert 700 records.

It's easy to do this for the Incident or User tables since those are single tables you can directly map to, but how do I go about mapping source data to fields on a specific catalog item on the Requested Item table? Is this possible? Is there a better way to accomplish my end goal of creating 700 inserted records of a specific catalog item with the dozen values I need for each one? I need these to be newly inserted records so that the workflow runs for each.

I appreciate any assistance. We're on Paris patch 4.

Brian