Export tables

You can export selected records or all records in a table to create a new table. For example, you may want to modify a table without altering the original records, share the table with a colleague, or create a table with a particular set of records.

You can save the output table in a dBASE table, geodatabase, or comma-delimited .txt file.

Export a table from a map

To export records in a table to create a new table, complete the following steps:

  1. Right-click the table or layer in the Contents pane and click either Open for a table or Attribute Table for a layer.
  2. Click the Menu button Menu in the upper right of the table view and click Export Export Table.

    The Export Table dialog box appears. The Export Table dialog box runs the Export Table geoprocessing tool in the background when running the export table process.

  3. Type a name in the Output Table parameter of the tool. Optionally, click the Browse button Browse and browse to the folder or geodatabase where you want to place the exported data.

    If the output table is in a folder, include a file extension such as .csv, .txt, or .dbf to export the table to that format. If the output table is in a geodatabase, you do not need to specify an extension.

  4. Click OK to run the tool and export the table.

The new table is saved to the specified location and added to the Contents pane.

Export a table from the Catalog pane or a catalog view

To export a table to another table type or feature class, complete the following steps:

  1. Right-click the table in the Catalog pane or a catalog view and click Export. Optionally, you can select multiple tables of the same type to export many in one batch.
  2. Click Export.

    A list of available table types expands.

  3. Choose the type of table to export from the provided list:

    The Geoprocessing pane appears, prepopulating the respective geoprocessing tool with the selected table name.

  4. Fill in any additional information required by the geoprocessing tool, and set the destination for the output result.
  5. Click Run to run the tool and export the table.