Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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

Supriya25
Tera Guru

‎03-21-2024 12:26 PM

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 ?

0 Helpfuls
  • 1,088 Views
5 REPLIES 5

Akash4
Kilo Sage
In response to Supriya25

‎03-22-2024 10:44 AM

Hello,

The link (davidmac.pro site) includes an alternative to what paid plugins in ServiceNow do for exporting via the Pagination concept. The code is available here - GitHub, investing an hour to modify a few lines following https://davidmac.pro/posts/2021-07-02-sn-bulk-export/ according to your requirement will help in exporting the file in CSV format, with less time (less than 5% of the total time of traditional exports).

Regards, Akash

Regards, Akash
If my response proves useful, please mark it "Accept as Solution" and "Helpful". This action benefits both the community and me.
0 Helpfuls