List export
- UpdatedAug 3, 2023
- 2 minutes to read
- Vancouver
- Data Management
You can export a list of records in a variety of formats.
The Export option is available in the column heading context menu in List v2. In List v3, it is available in the list title menu.
- Excel
- CSV
- XML
- JSON
- PDF (Portrait)
- PDF (Landscape)
- PDF (Detailed Portrait): Exports the list and the associated form for each record.
- PDF (Detailed Landscape): Exports the list and the associated form for each record.
You can control how line breaks appear in exported CSV data using the glide.csv.export.line_break system property.
To remove unwanted HTML tags from list data, see the blog Rendering HTML in Exported Lists by a ServiceNow employee in the ServiceNow Community.
When exporting to XML, a dialog box may prompt you to save the file, or the browser may automatically save the XML file to the downloads folder specified in the browser preferences.
Related Content
- Export limits
The platform provides a default upper limit for data exports.
- Form export
Any user role can export form data in a variety of formats.
- Export controls
Control the column value and header value in export files using query parameters, export set properties, and system properties.
- Exporting currency fields to Excel
Exporting currency fields to Excel applies Account formatting and can be configured to convert all values to US dollars or to export values in the user's session currency.
- Export directly from a URL
You may want to export data from the URL if you need to dynamically export data from a script or web service.
- Break up a large export
If the number of records to be exported exceeds the actual export limit, you may want to break the export into smaller increments that do not place a significant performance load on the platform.
- Enable export debug logging
When the property glide.export.debug is true, the instance logs export processing including database query time and the time taken to write data to the file.