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

[ralphho]

Hi Jonathan,

There's a lot of good information in this product documentation: https://wiki.servicenow.com/index.php?title=Exporting_Data

The page has information on the export limits and how to work around them and break up your exports into more manageable chunks.   Section 8.1 explains that the default properties are not defined, but have to be done via system properties (so it seems you are on the right track). It contains a link to a page that explains how to create a system property (which contains a link to a page that has a table with possible system properties and an explanation about each property).

Regards,

Ralph

[johnram]

The ServiceNow Wiki content is no longer supported. Updated information about this topic is located here: Exporting Data

Visit http://docs.servicenow.com for the latest product documentation

[shimongabai]

Hi Jonathan,

Exporting to Excel is actually limited by 2 system parameters: glide.excel.export.limit and glide.excel.max_cells. So, if you increase the default 10000 to 80000 of row limit, you might still not get all data as by default the cell limit is 500000. You might need to increase that value as well. However, keep in mind that Excel itself has a limit of how much data can it display when you open the file.

Actually, If you are in Fuji, you can simply use the new properties page for Import/Export and avoid adding properties:

1. Go to System Properties => Import Export

2. Change the Export Row Limit value to 80000

3. Change the Export Cell Limit (as needed)

FYI, when dealing with such large files, I will recommend using CSV instead of Excel. Excel is good for small result sets but limited when it comes to moving large amount of data between systems.

[kutvaram]

Hi J,

Did you manage to pull the records more than 32,000 records in single page of the excel file?

Thanks & Regards,

Ram Prakash