About data exporting

[Komazawa Akane]

I would like to ask you a question.
When outputting data from ServiceNow,
How many rows and cells should the csv threshold be?

[Sumanth16]

Hi @Komazawa Akane ,

Exports

Exports are windowed by the property glide.ui.export.limit which has a default value of 50000. BUT, that does not apply to all exports and there are other limits.

Excel

You are going to get 50000 records (32000 in the first page, 18000 in the second page) unless you exceed the other limit which is that we will only export a maximum of 500,000 CELLS. The maximum number of cells is controlled by the property glide.excel.max_cells. This is also done so that an export can't bring a system down because of using all the memory. The limit of 32000 per page of excel output must be based on the code that we are using to create the excel document as I don't see that excel has this limit. 

CSV

This is limited by the glide.ui.export.limit 

PDF

PDF has its own limits which is controlled by the property glide.pdf.max_rows which has a default of 5000 and also limited to 5000. Users can, however, limit the size under the default value. The min of glide.pdf.max_rows and glide.ui.export.limit will be used to limit the output.

XML

The property com.glide.processors.XMLProcessor.max_record_count determines max record count for XML exports.

If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!

Thanks & Regards,

Sumanth Meda

[Komazawa Akane]

Sumanth-san,
kindly your support thank you.
I referred to is this one
（https://docs.servicenow.com/bundle/tokyo-platform-administration/page/administer/exporting-data/conc...
Regarding export, SNow's default export row limit seems to be 10,000 rows for both Excel and CSV.
However, the threshold in SNow Excel is less than 500,000 cells, so if there are more than 500,000 cells, the export process will stop and
A message will appear asking you to use csv for a complete export.
It says that Excel stores information in a document with 32,000 rows for less than 500,000 cells, so I think 32,000 rows is the maximum number of rows in Excel.
I think CSV can support more cells and rows than that, but it didn't seem to be officially written in the doc.
After all, how many cells and rows can Snow export with CSV, and how many cells and rows can export with Excel?

[Komazawa Akane]

Some people say that Excel can export 500,000 rows, but is that true?