English
Continue in the app
Be The First To Get Support Updates
Want to know about the latest technical content and software updates?

How To: Export an attribute table from ArcGIS Pro to Microsoft Excel

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

To export an attribute table from ArcGIS Pro to Microsoft Excel, use one of the following methods:

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 folder icon), and select the feature layer with the desired attribute table.
  4. In the Output Excel File (.xls or .xlsx) section, click Browse.... (the folder 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 window, click the drop-down menu of Input Rows or Browse.... (the folder icon), and select a desired feature layer.
  3. Under Output Location, click Browse.... (the folder icon), select the desired output location, and click OK.
  4. Under Output Name, specify a name with the .csv file extension for the exported table, and click OK.
Fill in the required fields in the Export Table window to export the attribute table to a CSV file.
  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 and paste all the records in the attribute table into 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 Microsoft Excel file.
  2. In the Microsoft Excel file, right-click the A1 cell. Under Paste Option, select a desired paste option, and paste the records.
  3. Save the file.

Related Information

Last Published: 3/20/2022

Article ID: 000021825

Software: ArcGIS Pro 2.4.3, 2.4.2, 2.4.1, 2.4, 2.3.3, 2.3.2, 2.3.1, 2.3, 2.2.4, 2.2.3, 2.2.2, 2.2.1, 2.2, 2.1.3, 2.1.2, 2.1.1, 2.1, 2.0.1, 2.0