load data from excel

[Basina Akash]

Iam having the data of users in the excel sheet , The excel sheet consisting of user's name and managers and location of the users now i need to load data from excel to servicenow

[Sohail Khilji]

Hi @Basina Akash,

Its quite easy to load the data in servicnow via excel sheet. There are multiple ways you can load data in servicenow via excel. I suggest the below navigation and links to load data from excel.

1. From servicenow navigation enter 'Load data' from System import sets module.

2. A page opens asking import set table 1. create a table or existing table (meaning > if  you want to create a new staging table or use an exisitng table) you can choose 'create table' 

[This staging table is a temp table in servicenow were you load data on temporary basis to perform pre and post operations....]

3.  Now choose 'Source of the import' > file

4. from file load icon choose the file which you have to load.

5. leave rest of the infos default (i belive your data in in 1sheet sheet if excel).

 click in submit...

6. now you can set your source and target table.

7. create a transform map if any,

8. Load the data .... (make sure your template header name matches the servicenow fields name, else its omited to load data)

I hope this helps...

Summary > 

1. go to system import sets-->load data module
2. enter table name..chose file(.xls file) make sure 1st row in excel match fields in your destination table.so it will automap.
3. then click on create transform link
4. give it a name,select destination table(table in which u want to upload data)
5. click on auto map matching fields..if required fields do not match then click on mapping assist and match fields.
6. set colesce true to any one field from related list. it will be your unique field
7. click transform

Link > https://www.youtube.com/watch?v=UQJmZxrDSjk