Increase Excel Export Limit?

[rexicon]

Hello all,

I'm looking to export around 80000 rows to Excel and am currently limited by the export limit. I have read the Wiki and it has stated that the system property glide.excel.export.limit can be modified by changing the integer to whichever row limit is required. We are currently using Fuji and I cannot find this system property in any of our instances. I have also created a new system property in our dev environment but am unsure which Category to relate it to for the system to pick it up.

Could I ask what the best approach to take with this is? I can currently export 32001 rows into Excel 2010 so that is the starting point. I would rather know whether this can be done before I start splitting it into multiple exports.

Also, apologies if this is the wrong place to put this question.

Many thanks,

J

[Swarup Patra]

The system property glide.excel.export.limit is used to control the maximum number of rows that can be exported to Excel from a list in ServiceNow. If you can't find this property, you can create it. Here are the steps:

1. Navigate to System Properties > All Properties in your ServiceNow instance.
2. Click on the "New" button to create a new property.
3. In the Name field, enter "glide.excel.export.limit".
4. In the Type field, select "integer".
5. In the Value field, enter the number of rows you want to be able to export. For example, if you want to export 80000 rows, enter "80000".
6. You can leave the Description field blank or enter a description that helps you remember what this property is for.
7. Click on the "Submit" button to save the property.

Please note that increasing the limit may impact system performance. It's recommended to test this change in a non-production environment first.

Also, keep in mind that Excel has its own limitations. For example, Excel 2010 has a limit of 1,048,576 rows. If you try to export more rows than Excel can handle, you may encounter issues.

If you still face issues after increasing the glide.excel.export.limit, you may need to split your data into multiple exports.

nowKB.com

If you want to know any information about Service Now . Visit to https://nowkb.com/home

[TejasriK]

Search "Import Export" in filter navigator, under system properties you can find "Import Export" module. If you open that you can find the export and import limits. Update the row limit and try exporting.