Exporting large data sets into Excel

[kim_purcell]

Are you having trouble exporting data from your instance into an Excel file? Do you find that all of your data is not exported or that portions of records are missing from your reports?

The reason for this misplaced data may be that the number of records you are trying to export is higher than the maximum number of rows that Excel allows. In some cases, even though all records have been exported successfully into the file, Excel will display only a certain number of rows if your data exceeds the limit.

Excel is intended for relatively small exports, generally 50,000 rows. Older versions of Excel can only export up to 65,000 rows while newer versions (Office 2007 or later) have a maximum limit of just over 1,000,000 rows. If your data number is larger than this, you may not be able to successfully export, and receive this notification:

To fix, it is recommended to export your data into a different file type, such as CSV or XML, which can handle larger exports.

Another option is to increase the maximum export cell threshold. You can do this by customizing the threshold in the glide.excel.max_cells integer property. See Excel Export Threshold for more information.

Note that increasing the threshold to a higher number can cause resource issues in your instance. If you have a very high number of records to export and need to use Excel, you can break up these records into smaller groups. See Breaking Up Large Exports for more information.

For more information on troubleshooting exports, see:

• Determine if the configured maximum rows to export is too low (KB0538324)
• Determine if the version of Excel cannot handle the data set size (KB0538306)

See Export Limits and Exporting Large Data Sets for additional information.