HOW TO

Export an attribute table from ArcGIS Pro to Microsoft Excel

Last Published: July 20, 2023

Summary

Exporting an attribute table from ArcGIS Pro to Microsoft Excel is a common workflow, as some records are not editable in ArcGIS Pro, or the attribute table must be modified externally without altering original records. This article describes a few methods to export an attribute table from ArcGIS Pro to Microsoft Excel for external editing.

Procedure

Export the attribute table using the Table To Excel tool

  1. Open an ArcGIS Pro project. On the top ribbon, click the Analysis tab > Tools.
  2. In the Geoprocessing pane, search for Table To Excel (Conversion Tools), and click it. The Table To Excel window opens. In the Table To Excel window, click Parameters.
  3. Click the drop-down menu of Input Table or Browse The Browse icon., and select the feature layer with the desired attribute table.
  4. In the Output Excel File (.xls or .xlsx) section, click Browse The Browse icon..
The Table To Excel window.
  1. In the Output Excel File (.xls or .xlsx) window, specify a folder location for the Microsoft Excel file. In the Name section, specify a name for the Microsoft Excel file.
  2. Click the All supported drop-down menu, select a format (.xls or .xlsx) for the Microsoft Excel file, and click Save.
The Output Excel File window.
  1. In the Table To Excel tool, click Run.
  2. Navigate to the specified folder location in Windows. The attribute table is exported and can be opened in the Microsoft Excel Worksheet type.

Export the attribute table to a CSV file

  1. In the Contents pane, right-click the desired feature layer, and select Data > Export Table.
  2. In the Export Table dialog box, click the drop-down menu of Input Table, and select the desired feature layer.
  3. Provide a name for Output Table with the .csv file extension for the exported table, and click Browse The Browse icon. to specify the location for the .csv file.
  4. Click OK.
The Export Table dialog box.
  1. Navigate to the specified folder location in Windows. The attribute table is exported and can be opened in the Microsoft Excel Comma Separated Value File type.

Copy all the records in the attribute table and paste them in a Microsoft Excel file

  1. In the Contents pane, right-click the desired feature layer and click Selection > Select All to select all the records in the attribute table.
  2. In the Contents pane, right-click the desired feature layer, and select Attribute Table to open it.
  3. In the Field section of the attribute table, click Copy to copy all the records.
The Copy records button in the attribute table.
  1. Open a new Excel file.
  2. In the Excel file, right-click the A1 cell. Under Paste Option, select a desired paste option, and paste the records.
  3. Save the file.

Article ID: 000021825

Software:
  • ArcGIS Pro 3 1
  • ArcGIS Pro 3 0
  • ArcGIS Pro 2 x

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options