How to export data into multiple sheets in one Excel file.?

[Supriya25]

Hi Team,

We have 37 Lakhs records in PROD, so we need to export data into Single Excel file by using Scheduled Data Export.

but Excel sheets allows only 1M rows only, so how to overcome this and  export 3.7M records now ?

[Tony Chatfield1]

Hi, can you clarify your business driver\requirements.
I can understand that there may be a 1 off need to export large volume data,
but subsequent exports should be delta IE records that have been updated since the last export,
and if this is 3.7M records per export then it might be time to review your business needs and look into a better solution.

[Supriya25]

we are exporting this data and moving file to shared drive , after reaching to shared drive other Team will take .

As a ServiceNow person I have to export that data into a single file. here issue with 37Lakhs records. 

just because if this huge data export not happening.

[Akash4]

Hi Supriya,

Did you try using the sys_property.list to find Row limit and Cell limits for Excel. More info found here in link: Export Limits in SN . I would also suggest considering CSV (glide.csv.export.limit) instead of Excel which is faster and allows more record exports.

If the above is already considered, then you can have a look at this link: Best way to Export More than 1 Million data from ServiceNow table.? which indeed presents solution under https://davidmac.pro/posts/2021-07-02-sn-bulk-export/

Regards, Akash

[Supriya25]

The Solution which you share 'https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0727636' is about using REST API. how it would be helpful it with ?

Here Case we are sharing file into Shared Drive.  please guide me .