What is the best way to import excel data into ServiceNow (as a non-admin)

[aaron47]

Hello,

I have a request to import some excel data into ServiceNow.  I have yet to create the ServiceNow table that the excel data will be imported into.

I have been told that this import will take place periodically, so the task at hand is to remove the manual cut and paste required.

I am hoping to have this so they can do this themselves, meaning, the person that will be importing is not a servicenow administrator.  But they are a ServiceNow user consuming a licence.

Question 1 of 3

What is the best mechanism in ServiceNow available for this?  Is it still the use of Transform Maps?

https://docs.servicenow.com/en-US/bundle/sandiego-platform-administration/page/script/server-scripting/concept/c_CreatingNewTransformMaps.html

Question 2 of 3

Following on from question 1, if yes, what role is required to import data using a Transform Map?

Question 3 of 3

Following on from question 1, if no, is there any other alternative to import excel data.  Ideally something that is user friendly.

[Jaspal Singh · Accepted solution]

Question 1 of 3

What is the best mechanism in ServiceNow available for this?  Is it still the use of Transform Maps?

Yes. You can use Easy Import feature which is OOB limited to Admins but can be modified. Refer blog

Question 2 of 3

Following on from question 1, if yes, what role is required to import data using a Transform Map?

Admin OOB but above blog should help for altering.

Question 3 of 3

Following on from question 1, if no, is there any other alternative to import excel data.  Ideally something that is user friendly.

Well you have other import options JDBC, LDAP, XML, Third party integrations but it depends what system you to pull from.

[Tony Chatfield1]

Hi, based on your description the best mechanism is import via file load,

the minimum role is import_set_loader

https://docs.servicenow.com/bundle/sandiego-platform-administration/page/administer/roles/reference/r_BaseSystemRoles.html

There are many options available for loading data but for non admin users, once your transform is configured, this is the easiest and most reliable data import process.