Load the data from excel to ServiceNow

Gurpreet Kaur5 · ‎11-09-2023

Hi,

I have a list of Business services, Application services, Assignment group as well as users list which i need to upload with ServiceNow on daily basis.

How do i get it loaded please?

I tried to open business service list view> right click> import> but it did not work. I keep getting this message:

i am not getting the - Complete Import either.

Dr Atul G- LNG · ‎11-09-2023

HI @Gurpreet Kaur5

https://youtu.be/urcz82rZW9A

https://youtu.be/bpzYYJpBTcw

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

OlaN · ‎11-09-2023

Hi,

Importing directly into a list is only doable if you have a XML-file thats formatted according to the table structure you're importing to.

For an Excel file, the easiest way is to navigate to System import sets > Load data and create a file data source, and a transform map for importing records.

You can get more details on Nowlearning, or on the Developer site.