Issue
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?sysparm_query=state%3D1&sysparm_view=&EXCEL&sysparm_default_export_fields=all
(List of Incident Records in State of "New")
Alternatively, you can use XML export or JSON export (Jakarta and later versions) which contain Sys IDs.
Release
All Releases
Resolution
Append to the end of the URL:
&EXCEL&sysparm_default_export_fields=all
Related Links
More on exporting data with Sys IDs in this blog post on the Developer site: Exporting data with Sys IDs