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.

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 choose 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.
  3. Click Export Export Table.

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

  4. In the Output Name parameter, type a name and set the destination for the output table.

    The default output location is the project's file geodatabase. You can see this destination path by hovering over the output text box.

  5. Optionally, click the Browse button Browse for the Output Location parameter and browse to the folder or geodatabase where you want to place the exported data.

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

  6. Click OK in the Output Location window.
  7. 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.