---
title: "Exporting Record Data"
canonical: "https://help.agiloft.com/space/HELP/43715139/Exporting+Record+Data"
format: markdown
---
You can export data from one or many records into several formats: text file, Excel spreadsheet, XML file, or JSON file. This can be useful for reporting data to others outside the system, or for adding or correcting a large amount of data. You can also export record data in order to create a template file which can be used to determine the appropriate format for importing data.

> 📝 When exporting Contract records, note that the attached contract documents are stored in a separate table, typically the Attachments table. Though you can view related attachments from Contract records, those files aren’t included in Contract table exports because they aren’t stored in that table. To export Contract records and their attached files, export records from your Contracts table as well as any attachment tables.

This article includes instructions for exporting records from a single table or from multiple tables at once.

# Export Data from a Table

You can export records you manually select in the table, records matching a saved search, or all records in the table. If you want to use a saved search, create the search before you begin the steps below.

1. Navigate to the table that holds the data you want to export.
2. If you want to export certain records that don't share useful search criteria, select the checkbox for each record you want to export. Otherwise, you can use a saved search later, or export all the records in the table.
3. Click More on the action bar and select Export. The Export wizard opens.
4. On the Destination tab, select where you want to save the export file. You can export to your local hard drive or the home directory on the server.
5. On the Data Format tab, select the format for the export file.
  - Tab-delimited text: Exports a text file containing tabs that separate information into one record per line, similar to an Excel file.
  - Other text file: Exports a CSV file where you can choose which characters separate and enclose each field in a record.
  - Excel'97 (.xls) spreadsheet: Exports an Excel file in .xls format. By default, the maximum file size is 200 MB, but it can be changed in the [Maximum XLS Size to Export](https://agiloft-public.atlassian.net/wiki/spaces/HELP/pages/43713942) global variable.
  - Excel'2007+ (.xlsx) spreadsheet: Exports an Excel file in .xlsx format. By default, the maximum file size is 200 MB, but it can be changed in the [Maximum XLS Size to Export](https://agiloft-public.atlassian.net/wiki/spaces/HELP/pages/43713942) global variable.
  - XML file: Exports an XML file. Field and column labels are stored within the <metadata> element of the file.
  - JSON: Exports a JSON file. Each record is stored as an object in the JSON array.
6. On the Options tab, choose which records you want to export:
  - Only selected records. Export only the records selected in the table view. If you didn't select any before clicking Export, this option is disabled.
  - Only records matching search. Export any records in the table that match the selected saved search. You must select an existing saved search, or exit the wizard, create a saved search, and repeat the previous steps.
  - All records. Export every record in the table.
7. Choose whether to export table labels.
8. If you want to include attached files, set "Export files to folders" to Yes. The exported files are organized into folders for each exported record ID.
9. If you chose to include attached files, you can optionally select a list field to organize the record folders into groups. For example, you could group records by status. To do so, select a field from the drop-down under "Store files in folders named after a list field value." The drop-down only includes supported field types.
10. Choose whether to convert HTML and XML content into plain text. The HTML/XML option strips formatting tags out and exports only the text content.
11. Select the time zone to use for date/time fields.
12. Choose which fields to include in your export. If you're exporting records that contain linked fields, and you plan to import the data into another KB with existing records, export only one of the fields in each linked set. Choose a field that is required and unique, such as the ID field. For example, when exporting Attachment records, you might select only the Contract ID and Sourcing Event ID fields from their respective linked sets. However, if you have linked sets that include [loose links](https://agiloft-public.atlassian.net/wiki/spaces/HELP/pages/43714961), make sure to include the loose link fields as well.
  - All. Export all fields you have permission to view.
  - Use this View. Export all fields included in the selected table view. You can also edit the selected view from here to make changes.
  - These fields only. Manually select the fields you want to export from a list of the table's fields. You can clear or select every field using the buttons at the bottom of the list.
13. Click Finish to complete your export. When the file is ready, a link appears for you to download the file.

# Export Data from Multiple Tables

To export records and attachments from multiple tables at once, follow the steps below.

> ℹ️ Depending on the number of tables you export and number of records in those tables, exporting multiple tables at once can take a significant amount of time and system resources. Consider performing large exports outside of working hours.

1. Go to **Setup > Export**.
2. On the Destination tab, select where you want to save the export files. You can export to your local hard drive, TMP directory on the server, or home directory on the server.
3. On the Data Format tab, select the format for the export files.
  - Agiloft: This option is for KB backups. It’s generally not necessary to create manual backups. The system creates automatic backups each night by default.
  - Tab-delimited text: Exports a tab-delimited TXT file for each table.
  - Other text file: Exports a CSV file for each table. You can choose which characters separate and enclose each field in a record.
  - Excel'97 (.xls) spreadsheet: Exports an Excel file in .xls format, with a tab for each table. By default, the maximum file size is 200 MB, but it can be changed in the [Maximum XLS Size to Export](https://agiloft-public.atlassian.net/wiki/spaces/HELP/pages/43713942) global variable.
  - Excel'2007+ (.xlsx) spreadsheet: Exports an Excel file in .xlsx format, with a tab for each table.
  - XML file: Exports an XML file for each table. Field and column labels are stored within the <metadata> element of the file.
4. On the Options tab:
  1. Choose whether to zip the files. This compresses all files into one .zip file per table.
  2. Choose whether to export all versions of each attachment. If you don't select this option, only the most recent version is exported. Attached files are saved to a folder named files.
  3. Choose whether to convert HTML and XML-formatted text into plain text. This removes HTML and XML tags and exports only the content.
  4. Select the tables you want to export. You can select All to export all the table data in the KB, or you can select the Tables option and press the Ctrl key to select multiple tables from the list.
5. Click Finish to generate the export file.

#### Related articles

> Macro (contentbylabel)