Description

Excel export does not contain Sys ID field but in some cases it's required to provide it when importing data back to the system. Below is one of the methods how to include the Sys ID value associated with a record in the export.

Procedure

Append the following parameter to a URL of a list view to get it to include Sys ID in the resulting file: 

?EXCEL&sysparm_default_export_fields=all 

This parameter tells the web service to export all fields from the table including the Sys ID. Beware that this also brings every other field along with it. Example URL:

https://<instance_name>.service-now.com/incident_list.do?EXCEL&sysparm_default_export_fields=all

Alternatively, you can use XML export or JSON export (Jakarta and later versions) which contain Sys IDs.

Applicable Versions

All

Additional Information

More on exporting data with Sys IDs in this blog post on the Developer site: Exporting data with Sys IDs