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

[Community Alums]

Hello @Basina Akash,

You can use the Load Data functionality to load this data in ServiceNow, Use the transform map to map the fields. 

Make sure to use either user id or email id to make it unique (set coalesce).

Load Data 

If this solves your query mark this as correct and helpful.

Thanks

Anand

[Vishal Birajdar]

Hello @Basina Akash 

You can load the data using Import set and transform map.

Below link might help you - 

https://docs.servicenow.com/bundle/vancouver-integrate-applications/page/administer/import-sets/conc...

[siva krishna M2]

Hello @Basina Akash 

Please refer below link to know how to load excel data into ServiceNow tables

https://developer.servicenow.com/dev.do#!/learn/learning-plans/tokyo/new_to_servicenow/app_store_lea...

If it helps click on like icon and mark it as accepted solution

[Danish Bhairag2]

Hi @Basina Akash ,

Before loading the data in servicenow via transform map u need to make sure that u have a unique field value in ur Excel sheet for eg email I'd or employee number else if u upload with the current fields which is name manager name n location it will possibly modify other records as well which u don't intend to.

Once u have the unique field in ur Excel sheet then u can utilize transform map functionality to load the data as suggested by others.

Thanks,

Danish