{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":39880,"path":"platform-administration/table-administration-and-data-management/c_ExportData.md","title":"Exporting data","bundle":null,"doc_type":null,"release":"australia","body":"\n# Exporting data\n\nExport data from the ServiceNow AI Platform in a variety of formats.\n\n## Key benefits\n\n-   Export an individual record to a PDF or XML file directly from a form. See [Export data from a record](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/platform-administration/table-administration-and-data-management/export-form-data.md).\n-   Export multiple records to a CSV, Excel, PDF, XML, or Google Sheets file directly from a list. See [Export data from a list](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/platform-administration/table-administration-and-data-management/export-list-data.md).\n-   Export multiple records from a table using the CSV, Excel, PDF, or XML processor in a URL with optional parameters. See [Export directly from a URL](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/platform-administration/table-administration-and-data-management/t_ExportDirectlyFromTheURL.md).\n\nYou can also export data from your instance using the following options:\n\n-   Export multiple records from a table via a web services request. For example, you can create an external application or process to automate the retrieval of data from an instance via web services such as REST or SOAP. For more information, see [Web services](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/api-reference/web-services/r_AvailableWebServices.md).\n-   Push all the data that you want to export to an external file by creating an export set. For more information, see [Export sets](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/integrate-applications/c_ExportSets.md).\n\n## Associated roles\n\nYou can export form data to PDF or XML, depending on your role.\n\n-   The PDF options are available to all users.\n-   The XML option is only available to users with the admin role.\n\nYou can export records in a list to Excel, CSV, XML, JSON, PDF, or an Export Set depending on your role.\n\n-   The Excel, CSV, JSON, PDF, and Google Sheets options are available to all users.\n-   The XML option is only available to users with the admin role.\n-   The Export Set option is only available to users with the export\\_set\\_admin or admin role.\n\n## Export formats\n\n<table id=\"table_bfs_4kk_2r\"><thead><tr><th>\n\nExport format\n\n</th><th>\n\nDescription\n\n</th></tr></thead><tbody><tr><td>\n\nCSV\n\n</td><td>\n\nExport table records as a comma-separated value text file. Use this option to export the currently displayed fields in the list or form as a text file. Configure the list or form to add or remove fields from the export. When exported to CSV, dot-walked fields appear using their full field name, such as u\\_assignment\\_group.parent.\n\n **Note:** By default, ServiceNow exports all CSV files in Windows-1252 encoding. If you need to export translated data, set the **glide.export.csv.charset** [system property](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/platform-administration/r_AvailableSystemProperties.md) to UTF-8.\n\n</td></tr><tr><td>\n\nExcel\n\n</td><td>\n\nExport table records as a Microsoft Excel spreadsheet. Use this option to export the currently displayed fields in the list or form as an Excel spreadsheet. Configure the list or form to add or remove fields from the export.\n\n</td></tr><tr><td>\n\nXML\n\n</td><td>\n\nExport table records as an XML document. Use this option to export all data from a table or all data for a particular record. The XML file has an XML element for each column in the table. See [Exporting and importing data via XML](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/platform-administration/table-administration-and-data-management/c_ExportAndImportXMLFiles.md).**Note:** Image field data is not preserved when exporting to XML.\n\n</td></tr><tr><td>\n\nPDF\n\n</td><td>\n\nExport table records as a Portable Document Format file. Use this option to export the currently displayed fields in the list or form as a PDF file. Configure the list or form to add or remove fields from the export.\n\n **Note:** The PDF export processor prints data from left-to-right, which can produce rendering errors when displaying right-to-left language data.\n\n</td></tr><tr><td>\n\nJSON\n\n</td><td>\n\nExport the table records as a JSON string. The JSON file has an element for each column in the table.\n\n</td></tr><tr><td>\n\nGoogle Sheets\n\n</td><td>\n\nExport table records directly to cloud-based spreadsheets in Google Drive without going through extra steps. The exported file retains the structure of the original table, including rows and columns. You can view, edit and share these Google Sheets online in real time.\n\n</td></tr></tbody>\n</table>## Column headers\n\nThe file type you export to, such as CSV or PDF, determines how column headers are exported. In general, formats meant for human consumption such as PDF display the column label, whereas formats meant for machine use, such as CSV, use the database field\\_name.\n\n|File type|Column header format|\n|---------|--------------------|\n|Excel|Label|\n|PDF|Label|\n|CSV|field\\_name|\n|XML|field\\_name|\n|JSON|field\\_name|\n\n"}}