Exporting 1 Million Records to Excel

[kdurg]

Hey all, 

I am trying to export a massive, 1 Million records to an Excel file (Contacts) and am running into an issue with how to do it. When I filtered down my list, I clicked Export and chose the .xlsx file format. I am then given a warning mentioning that it is a large amount of data and it will take a while. It gives me the option to either wait or email a copy once it is done. The issue is that it seems to only export the first 10,000 records. That is a lot of looping to have to keep track of. Any thoughts on how I can get this information? 

I have looked at the article about Breaking up a large Export (https://docs.servicenow.com/bundle/vancouver-platform-administration/page/administer/exporting-data/...), but it doesn't seem feasible with the number of times I would need to loop through. We need to do this to compare a large data set externally with information in ServiceNow, and it is a 1-time export. 

Thanks in advance for any thoughts or guidance.

-Kyle-

[Saurav11]

Hello,

Can you try to export the same in csv format. I think it should work.

Please mark my answer as correct based on Impact.

[AshishKM]

Hi, 

One million seems large record for any excel file based on default limit, please refer the below limits details.

https://support.microsoft.com/en-gb/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-2...

Try to split the data in few CSV format and update the export limit in the System Property table. ( if default these system properties are not created, you can create and increase the UPPER limit. However it is recommended to break up a large export into separate manageable chunks.

Refer 

https://docs.servicenow.com/en-US/bundle/vancouver-platform-administration/page/administer/exporting...

Thanks

Ashish 

Please mark correct and helpful for others if it helps you

[kdurg · Accepted solution]

Thanks for the assistance. I was able to export all of these via xlsx by going to system properties => import export properties and adjusting the "Export Row Limit" and "Export Cell Limit" fields. Once this was set to 1m records and the cells were adjusted to 15m (to accomidate for field columns), it was able to export. It took about 2 hours to do this.