Export the fields view in ArcGIS Pro to Excel

Summary

The fields view in ArcGIS Pro provides insight into the structure and properties of a dataset. Exporting field information to Excel is particularly useful for aligning data structures with project requirements and reviewing schema elements within a feature class. This is also helpful for examining datasets with many fields. This article describes the workflow to export the fields view to an Excel file in ArcGIS Pro.

Procedure

Export the fields view using the Generate Schema Report tool

1. Open the ArcGIS Pro project.
2. Export the fields view using the Generate Schema Report tool.
   1. On the Analysis tab, in the Geoprocessing group, click Tools.
   2. In the Geoprocessing pane, search for and click Generate Schema Report.
   3. For Input Dataset, select the feature layer from the drop-down list.
   4. For Output Location, click Browse and navigate to the folder. Click OK.
   5. For Name, specify an output name.
   6. For Output Formats, check the XLSX check box.
   7. Click Run.

The image below shows the example of the exported schema report containing fields view information.

Export the fields view using the Export XML Workspace Document tool

1. Open the ArcGIS Pro project.
2. Export the fields view to an XML file.
1. In the Catalog pane, right-click the feature layer and click Export > Feature Class(es) To XML Workspace Document....
2. In the Export XML Workspace Document pane, for Output File, specify a name and location.
3. For Export Options, select Schema only from the drop-down list.
4. Click Run.

3. Open the exported XML file in Excel.
   1. Open a new Excel file.
   2. In the Excel file, click File > Open. Browse to the location that contains the exported XML file.
   3. In the Open dialog box, select the XML file and click Open.
   4. In the Open XML dialog box, select As an XML table, and click OK.

The image below shows the exported XML file opened in Excel.

Copy and paste the fields view information to Excel

1. Open the ArcGIS Pro project.
2. Open the fields view and copy all the information.
1. In the Contents pane, right-click the feature layer, and select Data Design > Fields.
2. In the fields view, click the row header (the small gray square containing the row number) to select all the information.
3. Right-click the selection and select Copy.
3. Paste the selection in Excel.
1. Open a new Excel file.
2. In the Excel file, on the A1 cell, press CTRL + V to paste the copied information.
3. Save the file.

The image below shows the fields view information pasted in Excel.