操作方法

操作方法:将属性表从 ArcGIS Pro 导出到 Microsoft Excel

Last Published: July 20, 2023

摘要

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.

过程

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

文章 ID:000021825

从 ArcGIS 专家处获得帮助

联系技术支持部门

下载 Esri 支持应用程序

转至下载选项

相关信息

发现关于本主题的更多内容