export field schema into tabular format (ArcPro)

[MalcolmLittle]

For the life of me, I cannot figure out how to export the field structure of a shapefile into something useable in Excel. For instance, I have a Waterloo streets shapefile, which I want to compare their fields to other municipality shapefiles:

I use ArcPro 2.4

[LanceCole · Accepted solution]

Malcolm‌, 

You can use the Export XML Workspace Document tool from Pro or Catalog, select as a Schema only and uncheck Metadata.  This file can then be opened using Excel.  Excel may ask if you want options, I normally use "As a XML table" and just click OK if you receive the message the source does not refer to a schema.

[MalcolmLittle]

Thanks, Lance. That worked, providing decent output, though there are a lot of junk columns added. Any idea if there's a way to export the field schema as it appears in the Fields table within Pro?

[LanceCole]

Malcolm Little,

Nothing I am aware of yet.  I know there are a few items under consideration, if you look through the ideas section.  It would be nice if the fields table simply supported copy so it could be pasted into excel as you do for attribute data.

[SarahThompson6]

I think I've just found a solution to this issue. For example, if you have a File Geodatabase Feature Class, in Catalog View, right-click | Data Design | Fields to see the Fields view. Then, with your mouse, click on the little half-arrow in the top left corner of interface window, to the left of "Field Name". This selects the entire thing. Copy (ctrl c) and then paste into Excel (ctrl v). It works, exactly as we want. Highlighting all the rows does not work, but clicking the upper left arrow to highlight the entire "table" does. (ArcGIS Pro 2.9.3, Excel for Microsoft 365, Windows 10).