Create multiple Incidents by importing data from an Excel spreadsheet

[Wayne Richmond]

We've identified 700 machines that are missing a security patch. We've exported the data from the monitoring software into an Excel spreadsheet. Is there a way to import the data into 700 individual Incident records?

[Pradeep Sharma · Accepted solution]

Hello Wayne,

You can get the data via import set tables and make sure coalesce value is set to false for all the fields. By default coalesce value will be false for all the fields.

Reference:

http://wiki.servicenow.com/index.php?title=Import_Sets

Please let me know if you have any questions.

[Wayne Richmond]

Great! And Service Now will create new incident numbers for each record?

[Pradeep Sharma]

Correct.

[Pradeep Sharma]

The other option is to get data via Easy import.

Easy Import - ServiceNow Wiki

Both the option I have mentioned here will work in your case.