Export maximum threshold

ddd
Tera Contributor

Hi

Excel Format (.xlsx)

What is the maximum threshold that can be filled in, and is there a clear maximum limit?

System Properties > Import Export

ddd_0-1703040153810.png

 

6 REPLIES 6

kriangkrai
Tera Guru

Hi @ddd,

 

AFAIK, the maximum threshold to import Excel Format (.xlsx) is due to file size not number of rows/cells.

If your file is too large, you might slit the file e.g. 10 files of 10,000 rows instead 100,000 rows in a file or increase the system memory.

 

See Excel import properties for more info.

 

Hope this help

Oat

ddd
Tera Contributor

Thank you for your answer

I want to know the exported data.

 

What is the maximum number of values can be set for Export Row Limit and Export Cell Limit? Does ServiceNow have any restrictions set?

Sorry, I don't understand your question clearly.

I assume ServiceNow do not have the maximum number of value but users have to mange it carefully as it might impact system performance.

 

FYI. I used to set the Export Cell Limit to 50M once then exported and set back to default value.

 

See Export limits for reference.

 

Regards,

Oat

ddd
Tera Contributor

Can I set the default value of 10000 for the current "Export Row Limit" to 100000, 1000000, or 10000000? Is there a clear restriction on the environment for the values I want to set?

ddd_0-1703042812885.png