Excel export limit

richofing
Mega Contributor

‎08-29-2016 07:23 AM

I am trying export records to Excel using the scheduled report, and I am emailing it to myself.   I cannot seem to get more than 32001 rows in the exported file.   I have set the Export Import parameters as follows:

find_real_file.png

The report is 80K rows, and 4 columns wide, so these parameters should easily accommodate the report.   Am I missing something?

Ric

Preview file
44 KB
0 Helpfuls
  • 1,684 Views
3 REPLIES 3

sergiu_panaite
ServiceNow Employee
ServiceNow Employee

‎08-29-2016 07:36 AM

Aren't you getting multiple sheets populated in the Excel file?



Exporting Data - ServiceNow Wiki


8.3 Excel Export Threshold


The export will put the information into the Excel document with 32,000 rows per spreadsheet.



Regards,


richofing
Mega Contributor
In response to sergiu_panaite

‎08-29-2016 07:45 AM

If you could see me right now you would see that my face is red with embarrassment. Yes, there are other sheets and all the rows are there. I did not even notice this, even after reading the Wiki article. Thank you for your help.



Ric


0 Helpfuls

sergiu_panaite
ServiceNow Employee
ServiceNow Employee
In response to richofing

‎08-29-2016 07:47 AM

Glad I could help!



Regards,


0 Helpfuls