Export guide · Checked against ServiceNow documentation 2026-11-17
How to export all your data from ServiceNow
Any ServiceNow user can export the records they are allowed to read from a list: right-click a column header and choose Excel, CSV, JSON or PDF. XML needs the admin role. Each format stops at 10,000 rows by default, so full table exports use URL exports in pieces, export sets or the Table API.
Who can export from ServiceNow
ServiceNow exports are per table, and what you can export follows what you can read. The documentation lists no role requirement for exporting a list to Excel, CSV, JSON, PDF or Google Sheets. Exporting to XML requires the admin role, and using an export set requires the export_set_admin or admin role. From a form, PDF export is open to all users and XML again needs admin.
URL exports also need no role, but ServiceNow enforces basic authentication for direct URL access and the output only includes fields the authenticated user can read. For the Table API, the calling user must have sufficient roles to access the data in the table named in the request.
Raising the export row limits is an admin task, done in System Properties > Import Export. At the time of checking, ServiceNow recommends keeping those properties at or below their defaults and breaking large exports into smaller pieces instead.
How to export, step by step
Route 1 of 4
Export from a list
Any user for Excel, CSV, JSON and PDF; admin for XML
- 01Go to the list of records you want to export.
- 02Press and hold, or right-click, any column header in the list.
- 03Choose an export option from the menu, such as Export CSV, Export JSON or Excel.
- 04Select Download when the export finishes.
If the list is larger than the warning threshold property, a dialog offers to wait for the export or to receive the records as an email attachment. ServiceNow warns that exported data may differ from the list view, because the export runs in a background thread without the user's session data.
Route 2 of 4
Export directly from a URL
Any authenticated user, limited to fields they can read
- 01Start with the instance URL, in the form https://<instance name>.service-now.com/.
- 02Add the table list, for example incident_list.do.
- 03Add the export processor: ?CSV, ?XLS, ?XLSX, ?JSON or ?XML.
- 04Add sysparm_query to filter records, for example &sysparm_query=priority=1.
- 05Add sysparm_orderby to sort, for example &sysparm_orderby=sys_id.
- 06Add sysparm_fields to name the fields you want, or sysparm_default_export_fields=all to export all fields including sys_id.
Without a view or field list, CSV and Excel exports use the default list view, while XML exports include all fields.
Route 3 of 4
Export set to a MID Server
Users with the export_set_admin role
- 01Go to All > System Export Sets > Create Export Set.
- 02Enter a descriptive name for the export set.
- 03Select an existing export definition, or select a table and let the system create a definition from that table's default list view.
- 04Select an existing export target, or select a MID Server and specify a file path on it.
- 05Click Submit.
- 06Set the file name, format and any recurring schedule on the Export Set form that opens.
An export set writes records to a file on a MID Server inside your own network, which suits repeated or scheduled exports.
Route 4 of 4
Table API
An API user with roles that can read the table
- 01Send GET /api/now/table/{tableName} with the table you want, such as incident.
- 02Set sysparm_fields to the columns you need and sysparm_query to filter or order the records.
- 03Set sysparm_limit to the page size and increase sysparm_offset by that amount on each request.
- 04Follow the next URL in the Link response header until no more records are returned.
The default sysparm_limit is 10,000. ServiceNow notes that unusually large values can affect performance, and that the limit is applied before ACL evaluation.
What comes out
Each export is one table in one format. CSV exports the displayed fields as comma-separated text and, by default, in Windows-1252 encoding. Excel also exports the displayed fields. XML exports all table data with an element per column, and JSON exports the table records as a JSON string, again with an element per column. Column headers are labels in Excel and PDF, and field names in CSV, XML and JSON.
Tables are linked by sys_id. To keep those links when you export several tables, ask for all fields including sys_id, since the default list view often leaves it out. Dot-walked fields in CSV appear under their full field name.
The Table API returns JSON by default, or XML on request, as a result array of field names and values. An X-Total-Count header gives the number of records the query matched.
| In the export | What it contains |
|---|---|
| CSV | Displayed fields as comma-separated text with field names as headers, in Windows-1252 unless glide.export.csv.charset is set to UTF-8. |
| Excel (.xlsx) | Displayed fields as a spreadsheet with column labels as headers, 32,000 rows per sheet by default. |
| XML | All table data for the records, one element per column. Image field data is not preserved. |
| JSON | Table records as a JSON string with an element per column. |
| Displayed fields in portrait or landscape, optionally with the form for each record. | |
| Export set file | A file such as CSV written to the path you set on a MID Server, with an optional timestamp in the name. |
| Table API response | A JSON or XML result array, paged with sysparm_limit and sysparm_offset. |
Before you rely on it
Limits and gotchas.
- XML, CSV, JSON and Excel exports each default to 10,000 rows. The platform checks the format-specific property first, such as glide.csv.export.limit, then glide.ui.export.limit, then the default.
- Excel exports are meant for fewer than 500,000 cells. Past that the export stops and the last row reads: Export stopped due to excessive size. Use CSV for a complete export.
- PDF exports default to 1,000 rows and 25 columns.
- The XML processor in a URL export does not export attachments or journal fields. ServiceNow says to use the Export XML option on the list context menu for those.
- Export sets do not export attachments to records. ServiceNow points to the REST Attachment API for downloading them.
- Records emailed as an attachment after the warning dialog must fit within the instance's email size limits.
- CSV files default to Windows-1252, so translated or non-Latin text needs the charset property changed to UTF-8 before export.
Handle with care
Personal data inside a ServiceNow export.
- Reference fields that point at people, such as who opened a record and who it is assigned to
- Free-text descriptions written by employees or customers
- Journal fields such as comments and work notes, when the export route includes them
- User table records, if you export the tables that hold staff or customer profiles
- Attachments fetched separately, which can be screenshots or documents with personal details
- sys_id values that still link a cleaned record back to a person in another table
An export is a copy outside the access controls of ServiceNow. Store it encrypted, limit who can open it and delete working copies when you are done. The personal data scrubber removes common identifiers in your browser before a file is shared.
What the export can be worth
Outrich Data is a direct buyer of de-identified company data for AI training, from companies with 50 or more employees. We never connect to your ServiceNow account: your team runs the export above and removes what is out of scope. Not every export qualifies, and a rights review comes before any offer.
Questions
Exporting from ServiceNow: common questions.
How do I export more than 10,000 records from ServiceNow?
What role do I need to export data from ServiceNow?
Does a ServiceNow export include attachments?
Why does my ServiceNow CSV show broken characters?
Sources
- ServiceNow: Exporting data2026-11-17
- ServiceNow: Export limits2026-11-17
- ServiceNow: Export data from a list2026-11-17
- ServiceNow: Export directly from a URL2026-11-17
- ServiceNow: Create an export set2026-11-17
- ServiceNow: Table API2026-11-17
Steps were checked against ServiceNow documentation on 2026-11-17. Vendors change menus, plans and limits, so confirm against the linked pages. ServiceNow is a trademark of its owner. Outrich Data is not affiliated with ServiceNow.
Find out if your data qualifies.
Eleven questions, about five minutes, no call required. You get an answer on screen and a written follow-up.