Export maximum threshold
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-19-2023 06:47 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-19-2023 07:05 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-19-2023 07:12 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-19-2023 07:23 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-19-2023 07:29 PM
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?