Now Knowledge Exchange - Export Excel/CSV With Sys_ID

[pgarg]

In ServiceNow, we have multiple approaches for obtaining the sys_id of records, but it can be challenging to export the Excel file containing the sys_id.  

Below are the steps for exporting the Excel and CSV files with the sys_id included. 

Excel with all the columns including Sys_Id 

By adjusting the URL of a record, we can add URL Parameter to export the sys_id and all fields to Excel. 

Steps to use this parameter.  

• Navigate to the list of records where we want to find the sys_id. 
• Paste the URL into a new browser window.  
• Add &EXCEL&sysparm_default_export_fields=all to the end of the URL.  
• Excel file with all fields AND the sys_id is exported. 

CSV with all the columns including Sys_Id 

By adjusting the URL of a record, we can add URL Parameter to export the sys_id and all fields to CSV. 

Steps to use this parameter.  

• Navigate to the list of records where we want to find the sys_id. 

• Paste the URL into a new browser window.  
• Add &CSV&sysparm_default_export_fields=all to the end of the URL.  
• CSV file with all fields AND the sys_id is exported. 

Excel with Filter Data along with Sys Id 

By adjusting the URL of a record, we can add URL Parameter to export the sys_id and all fields to Excel. 

Steps to use this parameter.  

• Navigate to the list of records where we want to find the sys_id. 
• Build your filter Right click the Filter and select Copy URL.  
• Paste the URL into a new browser window.  
• Add &EXCEL&sysparm_default_export_fields=all to the end of the URL.  
• Excel file with all fields AND the sys_id is exported. 

CSV with Filter Data along with Sys Id 

By adjusting the URL of a record, we can add URL Parameter to export the sys_id and all fields to CSV. 

Steps to use this parameter.  

• Navigate to the list of records where we want to find the sys_id. 
• Build your filter Right click the Filter and select Copy URL.  
• Paste the URL into a new browser window.  
• Add &CSV&sysparm_default_export_fields=all to the end of the URL.  

• A CSV file with all fields AND the sys_id is exported. 

Easy way to export the excel with the specific columns and data

Here is a creative way to use the Import Template to export the sys_id along with the data. 

• Navigate to the list of records where we want to find the sys_id. 
• Apply your filter. 
• Right click the header bar and select Import.  
• Do you want to insert or update data? Update 
• Do you want to create an Excel template to enter data? True 
• Include all fields in the template? True or False
• Click Create Excel Template 
• Click Download 
• Open the Excel Spreadsheet 
• Select Page 1 

 Thanks & Regards,

Pooja Garg

[Abbas_5]

Hello @pgarg,

Please refer to the link below:
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0691394

Mark my correct and helpful, if it is helpful and please hit the thumbs-up button to mark it as the correct solution.
Thanks & Regards,
Abbas Shaik