Do you need to export a large set of data to an Excel or XML file? Are you perplexed why the platform stubbornly allows only a certain amount of data for export? The reason for this is intentional; the platform sets a default limit to prevent performance issues caused by large exports. Here are some format-specific export limits:
You'll notice if you try to export data from a list that exceeds this limit (for example, more than 10,000 records to Excel), a dialog box appears indicating that your records are being exported, but only until it reaches the default limit:
In cases where you absolutely need to export a large chunk of data at once, you can create a system property to increase the limit:
- Enter sys_properties.list into the filter text field.
- Click New.
- In the Name field, enter glide.ui.export.limit.
- For type, select integer.
- In the Value field, enter <new amount>.
- Click Submit.
You can now export all of your records (for this one, the limit was increased to 20000):
Although this property can be set to any value, exceeding the default export limit can impact system performance. To save resources, another option is to break up the data into smaller sets. See Breaking Up Large Exports for more information.
See Export Limits and Troubleshooting Exports for additional resources.
To watch the YouTube video, see Troubleshooting ServiceNow Export Limits.
14 Comments
