Unable to export an attribute table to an Excel file in ArcGIS Pro

Description

When attempting to export an attribute table to an Excel file using the Table To Excel geoprocessing tool in ArcGIS Pro, the tool fails and returns the following error message:

Error:   
Table To Excel failed.

Cause

This issue occurs when the layer name or attribute table contains Unicode symbols or characters.

Solution or Workaround

Use one of the options provided to resolve this issue.

Remove the Unicode symbol from the layer name

1. Open the ArcGIS Pro project. In the Contents pane, browse to and double-click the layer.
2. In the Layer Properties: <layer_name> window, click the General tab.
3. In the Name section, rename the layer or remove the Unicode symbol, and click OK. In this example, the Unicode symbol is removed from the layer’s name.

Remove the Unicode symbol from the field in the attribute table

1. Open the ArcGIS Pro project.
2. In the Contents pane, browse to and right-click the layer, and select Attribute Table.
3. In the attribute table, browse to and double-click the field to remove the Unicode symbol.
4. On the top ribbon, click the Edit tab.
5. In the Manage Edits group, click Save to save the edits made in the attribute table.

Export the attribute table to an XLS file

Using the Table To Excel tool, export the attribute table to an XLS file.

1. Open the ArcGIS Pro project. On the top ribbon, click the Analysis tab > Tools.
2. In the Geoprocessing pane, search for and click Table To Excel (Conversion Tools). The Table To Excel window opens.
3. In the Table To Excel window, click Parameters.
4. Click the drop-down menu of Input Table, or Browse (the folder icon), and select the feature layer with the desired attribute table. In this example, a layer titled Point_layer is selected, and the Output Excel File (.xls or .xlsx) parameter is populated automatically.

5. Click and browse to the end of the Output Excel File (.xls or .xlsx) parameter, and change the output format to .xls.

Note:
By default, the output format is set to XLSX.

6. Click Run.

The image below shows the attribute table is exported as an Excel (.xls) file.

Use the Table To Table geoprocessing tool

Export the attribute table to a CSV file using the Table To Table geoprocessing tool.

1. Open the ArcGIS Pro project.
2. In the Contents pane, browse to and right-click the layer. Click Data > Export Table.
3. In the Export Table window, click Parameters.
4. For Output Location, click Browse.
5. In the Output Location window, select the desired folder for the output file, and click OK. In this example, a folder named Point Line Polygon is selected.

6. Specify a name for Output Name, and include the .csv extension. Click OK.

The image below shows the exported CSV file titled Point_layer is stored in the Point Line Polygon folder.

Use the Copy Rows geoprocessing tool

Export the attribute table to a CSV file using the Copy Rows geoprocessing tool.

1. Open the ArcGIS Pro project. On the top ribbon, click the Analysis tab > Tools.
2. In the Geoprocessing pane, search for and click Copy Rows (Data Management Tools). The Copy Rows window opens.
3. In the Copy Rows window, click Parameters.
4. Click the drop-down menu of Input Rows, or Browse (the folder icon), and select the feature layer with the desired attribute table.
5. For Output Table, click Browse.
6. In the Output Table window, specify the Name section, and include the .csv extension. Click Save.

7. In the Copy Rows window, click Run.

The image below shows the attribute table is exported as a CSV file.