Export an attribute table from ArcGIS Pro to Microsoft Excel

Zusammenfassung

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.

Vorgehensweise

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 , and select the feature layer with the desired attribute table.
4. In the Output Excel File (.xls or .xlsx) section, click Browse .

5. 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.
6. Click the All supported drop-down menu, select a format (.xls or .xlsx) for the Microsoft Excel file, and click Save.

7. In the Table To Excel tool, click Run.
8. 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 to specify the location for the .csv file.
4. Click OK.

5. 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.

4. Open a new Microsoft Excel file.
5. In the Microsoft Excel file, right-click the A1 cell. Under Paste Option, select a desired paste option, and paste the records.
6. Save the file.