how to export more than 10000 records in servicenow without changing system property

[Yu_G]

Hi everyone,

I'd to export more than 10000 records into one excel or CSV file without changing system property.

Now the Export Row limit is 10,000. Is there a way to cheat ServiceNow and manage to export more than 10000 records at one time?

Thank you very much.

[Dnyaneshwaree]

Hello @Yu_G ,

Are you trying to export data of any specific table?

if yes, have you tried this? -  From the "Tables" module, export required records from the required table.

[Yu_G]

Hi  @Dnyaneshwaree 

Thank you for your reply.

I have managed to make a download button to download the records that i want from a table. However, the amount is limited to 10,000 which is not enough. 

Is there anyway to download more than 10,000 records from a table without changing the default Export Row limit in system properties?

[QI XING HONG]

Have tried to find the same but to no avail. 

At the moment, for this specific need we are doing it manually to break up a large export.

Source - https://www.servicenow.com/docs/bundle/yokohama-platform-administration/page/administer/exporting-da...

[_ukasz Rybicki]

Summary

You can bypass the 10 000-row UI export limit by using the ServiceNow Table API with paged requests (via sysparm_limit and sysparm_offset) to fetch records in 10 000-row batches and merge them externally 😊 (ServiceNow Support, ServiceNow). Alternatively, a server-side Background Script leveraging GlideRecord and GlideSysAttachment can generate a CSV attachment of all records in one go 🚀 (ServiceNow, ServiceNow).

---

Name of Problem

UI export row limit of 10 000 records in ServiceNow 🚩

---

General solution proposition

Use the REST Table API in Postman or SN Utils to page through data using sysparm_limit=10000 and incremental sysparm_offset, then concatenate the batches into one CSV; or run a Background Script that loops GlideRecord, builds a CSV string, and writes it as an attachment via GlideSysAttachment 😊 (ServiceNow Support, ServiceNow).

---

Detailed step-by-step solution

1. Identify table & fields

   • Decide on the target table (e.g., incident) and required columns (e.g., number, short_description, assigned_to) (ServiceNow).

2. Construct initial REST URL

   GET https://<instance>.service-now.com/api/now/table/incident
     ?sysparm_fields=number,short_description,assigned_to
     &sysparm_limit=10000
     &sysparm_offset=0

   (ServiceNow Support)

3. Configure authentication

   • Use Basic Auth or OAuth in Postman/SN Utils with a user having rest_api_explorer or API role (ServiceNow).

4. Fetch & save batch

   • Export response as JSON or CSV.

5. Loop paging

   • Increment sysparm_offset by 10 000 and repeat until no more records returned (ServiceNow).

6. Merge batches

   • Use a simple Python or shell script to concatenate CSVs or merge JSON arrays into one file (ServiceNow).

7. Alternative: Background Script

   var gr = new GlideRecord('incident');
   gr.query();
   var csv = 'number,short_description,assigned_to\n';
   while (gr.next()) {
     csv += gr.number + ',' + gr.short_description + ',' + gr.assigned_to + '\n';
   }
   var sa = new GlideSysAttachment();
   sa.write(current, 'all_incidents.csv', 'text/csv', csv);

   • Run in Scripts – Background as admin; check System Logs for attachment (ServiceNow, ServiceNow).

---

Example solution

A data-integration developer uses Postman to page through 250 000 incident records (25 batches of 10 000), then runs a Python script to merge them into one CSV for BI ingestion 😊 (ServiceNow, ServiceNow).

---

Sources

1. Exporting Bulk Data via REST – support.servicenow.com; explains sysparm_limit default and offset usage (ServiceNow Support)

2. Break up a large export – docs.servicenow.com; official paging guide for >10 000 records (ServiceNow)

3. Script to export data in csv – community.servicenow.com; shows GlideSysAttachment for CSV attachments (ServiceNow)

4. How to get more than 10000 records – community.servicenow.com; notes default sysparm_limit and how to override (ServiceNow)

5. Report unable to export more than 10000 rows – community.servicenow.com; UI property-based limits explained (ServiceNow)

6. Has anyone been successful at exporting more than 10000 rows – community.servicenow.com; community endorsement of paging (ServiceNow)

7. Export limits – docs.servicenow.com; details default CSV/Excel export caps (ServiceNow)

8. Increase Table API response limit – community.servicenow.com; pagination for Table API >10 000 records (ServiceNow)

9. Export FAQ – support.servicenow.com; suggests background script troubleshooting (ServiceNow Support)

10. GlideSysAttachment API – docs.servicenow.com; API reference for attachments (ServiceNow)

Please mark this as the correct answer if it helped! 😊