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.

krk3
Kilo Explorer

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.

3 REPLIES 3

Chuck Tomasi
Tera Patron

Hi Ravi



This article should be helpful.



Increasing the Export Limit


Paul Curwen
Giga Sage

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.


***If Correct/Helpful please take time mark as Correct/Helpful. It is much appreciated.***

Regards

Paul

kutvaram
Tera Expert

Hello,

 

Did you able to get all the data in one page itself?

 

Share your experience here pls.

 

Thanks & Regards,

Ram Prakash