Is there a possible way to Load list of cases data which is in excel to servicenow

[poornima batchu]

Hi experts, 

I have a requirement where for the list of 10,000 HR cases I have to update the watchlist Users. As I cannot add this manually for these huge number of cases. Is there a way to bulk upload the list of cases which is excel format to ServiceNow system so that the watchlist users get updated automatically without creating duplicate records.

Please provide soultions.

Thank you in advance.

[Maik Skoddow]

Hi

The watchlist field is of type GlideList that means it contains a comma-separated list of Sys IDs. Just using an Excel-Upload will not be a solution as you have to merge the values for each record. 

The better approach would be writing a script which does the job for. 

Maik

[poornima batchu]

Hi Maik, 

Thank you for the response, can you please help me with the script.