Export data

[Shabbir1]

Hello Team,

We want to export incident table data into excel but when we are exporting we are getting only 10k records but in our instance incident table contains 10800 records can anyone suggest us how to download the remaining records from 10001-10800 in excel format

[Dr Atul G- LNG]

Hi  

You can change the import/export property and increase the count to 11,000, then export. After the export, change the count back to 10,000. This is a better practice to avoid system performance issues.

https://INSTANCENmE.service-now.com/now/nav/ui/classic/params/target/%24impex_properties.do

[Tanushree Maiti]

Hi @Shabbir1 

Exports are windowed by the property glide.ui.export.limit which has a default value of 10000. To set these properties, navigate to System Properties > Import Export. You can change the import/export property.

Note: In prod - Don't keep the export property with large size (like 100K) as large data exports can significantly degrade platform performance.

Once as an Admin you exported the data , revert back to default value or a bit high value.

ref:https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0518655

Default export limitFormat 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	10,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_detail_pages Note: The number of rows can be set from 0 to 250. If no value is specified, the default is 250. If a value greater than 250 is specified, the default value of 250 is used.	250	250
PDF	glide.pdf.max_rows Note: The number of rows can be set from 0 to 5,000. If no value is specified, the default is 1,000. If a value greater than 5,000 is specified, the default value of 1,000 is used.	N/A	1,000
PDF	glide.pdf.max_columns Note: Only 25 header labels fit on a page.	N/A	25
JSON	glide.json.export.limit	glide.ui.export.limit	10,000

[VaishnaviK3009]

Hi @Shabbir1 !!

You can increase the limit here,

Mark this as Helpful if it clarifies the issue.
Accept the solution if this answers your question.

Regards,
Vaishnavi
Technical Consultant

[Jaspal Singh]

Hi Shabbir,

You have answers already from the experts but may I know the reason. Is this a one time extract or will be automated?

If one time extract I would rather modify filters to get chunks of records and merge the files later instead of modifying the system properties for export limit to avoid any deviation from platform default/provided recommendations.