Export limits

The platform provides a default upper limit for XML data exports.

The purpose of the upper limit is to avoid creating performance issues when a table is excessively large. If you need to export more records than the threshold permits, break up the export into separate manageable chunks.

Export limit properties

You can set the number of records to return during an export using the URL parameter sysparm_record_count.

However, the system analyzes the following settings to determine whether an export limit should be applied.
  1. First, the platform checks the property that defines the format-specific export limit (see table). Each format can have a different limit. Although this property can be set to any value, exceeding the default export limit can impact system performance. You may want to set the property at or below the default limit and have users export large amounts of data in smaller increments.
  2. If the format-specific property is not set, the system checks the property for the general export limit (see table). This property can also be set to any value, but exceeding the default export limit can impact system performance.
  3. If neither the format-specific export limit nor the general export limit property is set, the system enforces the default export limit (see table).
Important: To set these properties, navigate to System Properties > Import Export.
Table 1. Default export limit
Format Format-specific export limit General export limit Default export limit
XML glide.xml.export.limit glide.ui.export.limit 10,000
CSV glide.csv.export.limit glide.ui.export.limit 10,000
EXCEL (XLSX) glide.xlsx.export.limit glide.ui.export.limit 10,000
EXCEL (XLS) glide.excel.export.limit glide.ui.export.limit 50,000
EXCEL (XLSX) glide.xlsx.max_cells N/A 500,000
EXCEL (XLS) glide.excel.max_cells N/A 500,000
PDF glide.pdf.max_rows N/A 5,000
PDF glide.pdf.max_columns N/A 25
JSON glide.json.export.limit glide.ui.export.limit 10,000

Although the number of columns can be set higher than 25 in the PDF export, this is not advisable as only 25 header labels fit on a page.

A warning threshold property called glide.ui.export.warn.threshold controls how the records are exported. If a user attempts to export a number of records from a list that exceeds the warning threshold, a dialog box offers the choice of waiting for the export to complete or having the exported records emailed as an attachment. The warning threshold can be changed in the system property. The email attachment must not exceed the maximum allowed email size or configured email attachment size.

Table 2. Export limit examples
Example Property Table Note
Exporting to CSV
  • glide.csv.export.limit = 20,000
  • glide.ui.export.limit = 10,000
  • com.glide.processors.XMLProcessor.max_record_count = 20,000
  • Default export limit for CSV = 10,000
Table 3. Exporting to CSV
Records to be Exported Records Returned
15,000 15,000
30,000 20,000
In the second export, the number of records returned from the database is limited because the number of records specified for export exceeds the value set in the glide.csv.export.limit property.
Exporting to Excel (XLSX)
  • glide.xlsx.export.limit = no entry
  • glide.ui.export.limit = no entry
  • Default export limit for Excel (XLSX) = 10,000
Table 4. Exporting to Excel
Records to be Exported Records Returned
10,000 10,000
30,000 10,000
In the second export, the number of records returned from the database is limited because the number of records specified for export exceeds the default export limit for Excel, 10,000 records.
Exporting to PDF
  • glide.pdf.max_rows = 3,500
  • Default and maximum export limit for PDF = 5,000
Table 5. Exporting to PDF
Records to be Exported Records Returned
2,000 2,000
10,000 5,000
In the first export, all records are returned because the number of records specified for export does not exceed the glide.pdf.max_rows property. In the second export, the number of records returned is limited because the number of records specified for export exceeds the value in the glide.pdf.max_rows property.