Hello TEam, I am able to export 35000 rows into excel with 2 tabs (32000 3000). Is this correct ? Anything changed in recent times? As per wiki we can only download only 10000 records in Excel as a limitation in SNOW.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-13-2016 02:06 AM
I have downloaded 35000 record information to Excel and it accepted. I am able to see the data of 35000 records. (But in 2 tabs)
Is this correct and is there an enhancement that happened?
Note: As per SNOW Wiki and other trainings what we attended, SNOW has the limitations of holding only 10000 rows of data.
Need clarification on this .... Pl.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-13-2016 03:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-06-2017 05:16 AM
Hi Ravi,
Chuck has pointed you in the correct direction above. More detail:
You can either Create or Amend (if they already exist) the following System Properties yourself,
- glide.ui.export.limit
- glide.excel.export.limit
- glide.excel.max_cells
or if you are working on Fuji or above have a look under System Properties > Import Export in the Application Navigator.
Here you will see 2 entries for Excel 'Excel Format .xls' and 'Excel format .xslx' you can adjust the Row Limit and Cell Limits value settings accordingly. The default is 10,000 Rows and 500,000 cells. So the size you need is dependent on the number of rows and how many cells each Row has. Only export the columns you really need. When exported to Excel you will get the first 32,000 rows in each Worksheet and the remainder in subsequent Worksheets. If you do exceed the limit, then ServiceNow will warn you by placing the following text in the last row of the last worksheet:
"Export stopped due to excessive size. Use CSV for a complete export."
if you see this message, then up your limits accordingly.
As you can see from the message above it's pushing you to use CSV for such large exports, so you may want to experiment with that. Also be very wary of increasing these limits too far, it will have an impact on your instance performance. There are limits for good reasons
To avoid impacting your instance performance with such large individual exports, you can also break very large exports up as explained here: Exporting Data - ServiceNow Wiki
See section - 8.2 Breaking Up Large Exports
Hope that helps.
Paul.
Regards
Paul
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-27-2018 02:16 AM
Hello,
Did you able to get all the data in one page itself?
Share your experience here pls.
Thanks & Regards,
Ram Prakash