export field schema into tabular format (ArcPro)

297
3
Jump to solution
07-24-2019 09:04 AM
MalcolmLittle
New Contributor III

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

0 Kudos
1 Solution

Accepted Solutions
LanceCole
MVP Regular Contributor

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.

Export XML

View solution in original post

3 Replies
LanceCole
MVP Regular Contributor

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.

Export XML

MalcolmLittle
New Contributor III

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?

0 Kudos
LanceCole
MVP Regular Contributor

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.