idea Right Click to export table schema to excel in ArcGIS Pro Ideas

Right Click to export table schema to excel

MarkVolz — Fri, 25 Jun 2021 19:14:13 GMT

I would like an option to export table schemas to excel. That would make it easier to compare two tables and verify if they have the same schema or not.

For example:

my_shapefile.shp --> export schema to excel -->my_shapefile_schema.xls

Fieild Name, Field Alias, Field Type, Field Size, Domain, etc
_____________________________________________________
PIN , Parcel ID, String, 11, <null>, ....

Thanks

Re: Right Click to export table schema to excel

DuncanHornby — Wed, 09 Apr 2014 09:38:09 GMT

Are you aware of the Table Compare tool? I don't think it gives you a break down of field type but it will identify if tables are different and there are a whole bunch of options to play around with.

Re: Right Click to export table schema to excel

RichardFairhurst — Fri, 11 Apr 2014 23:10:59 GMT

If you buy a Standard Licence or Advanced License you can use Export XML Workspace Document tool for geodatabase tables/feature classes the http://resources.arcgis.com/en/help/main/10.2/index.html#//00170000015s000000
The tool options even are part of the context menu in the Catalog Window, so you don't even need to go to the toolbox if you have the correct license. ESRI assumes if you only bought a Basic license, you are a viewer only and not interested in creating schemas or examining them using their support tools.

Re: Right Click to export table schema to excel

RichardFairhurst — Fri, 11 Apr 2014 23:13:58 GMT

Just to be clear, the Export XML Workspace Document tool lists all you should need to know about the schema of your table/feature class.

Re: Right Click to export table schema to excel

KoryKramer — Mon, 07 Oct 2019 22:50:13 GMT

ArcGIS Pro - Export Fields Table is in product plan for ArcGIS Pro 2.5. Which makes it pretty quick to Ctrl+A, Ctrl+C, go to Excel Ctrl+V

Re: Right Click to export table schema to excel

MarkVolz — Thu, 17 Dec 2020 22:29:50 GMT

Hey sorry for the late reply...

@ Kory, yes that is exactly what I hoped for.

@Richard, I noticed this does not work against shapefiles. Also in my own opinion I think that basic users should be able to use this as well as it is an excellent documentation tool.

Thanks!

Re: Right Click to export table schema to excel - Status changed to: Implemented

KoryKramer — Fri, 25 Jun 2021 19:13:20 GMT

Marking this implemented with the copy functionality added to the Fields View in ArcGIS Pro 2.5.

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/create-modify-and-delete-fields.htm

Re: Right Click to export table schema to excel

Anonymous User — Tue, 12 Oct 2021 18:51:44 GMT

@KoryKramer you're the best! I was looking for this today! Thank you!! If you weren't on here posting things I would never know how to use Pro! 🙂

Re: Right Click to export table schema to excel

KoryKramer — Tue, 12 Oct 2021 18:55:17 GMT

It makes me very happy to know that our efforts are helping! 🙂

Thank you for the note @Anonymous User

Re: Right Click to export table schema to excel

KateCarlson — Wed, 16 Mar 2022 21:06:07 GMT

I am with @Anonymous User, @KoryKramer! Thanks for the visual, mind blown at the simplicity of this. Excellent!

Re: Right Click to export table schema to excel

AndrewRudin1 — Wed, 21 Sep 2022 18:16:21 GMT

I noticed that the copy and paste does not bring over the precision and scale if they are present. So I guess I'll open up a follow up enhancement request along the lines of "copy and paste all columns in the fields view regardless of what is displayed."

Re: Right Click to export table schema to excel

GabrielScarcella — Thu, 22 Sep 2022 20:21:10 GMT

@KoryKramer thanks a lot for the simplicity of this solution. Very helpful!
It would be nice to see this functionality also available to copy and paste the whole attribute table of any given feature class.
Thank again.

Re: Right Click to export table schema to excel

KoryKramer — Thu, 22 Sep 2022 21:44:53 GMT

@GabrielScarcella

https://pro.arcgis.com/en/pro-app/latest/help/data/tables/keyboard-shortcuts-for-tables.htm

What you might be missing (I can't be sure without more details) is that the copy all rows you need to use the Copy Selection button or Ctrl+Shift+C, rather than Ctrl+C, which will copy an individual cell value.

Hope this helps!

Re: Right Click to export table schema to excel

GabrielScarcella — Fri, 23 Sep 2022 15:54:29 GMT

Thanks @KoryKramer for the quick reply and for pointing me in the right direction, I was missing that cool functionality and didn't know it was already available.
It works wonderfully using the Copy Selection button, however, every time I use the Ctrl+Shift+C it copies the value of the first cell selected (using ArcGIS Pro 2.9.2). Was it implemented in a recent revision of ArcGIS Pro?
Thanks again for your help.

Re: Right Click to export table schema to excel

KoryKramer — Fri, 23 Sep 2022 16:33:51 GMT

I'm not sure why the shortcut wouldn't be working on your machine. That has been in place for a long time (definitely not something new after 2.9...). i.e. if you hover over the Copy Selection button like in my screenshot, you should see the shortcut tip.

Re: Right Click to export table schema to excel

wayfaringrob — Thu, 20 Oct 2022 20:34:49 GMT

So, I'm noticing a couple weird things. The first is that if you open the fields view and then immediately Ctrl+A and copy, it only copies the rows visible on your screen plus a few more:

Going back to Pro, they all show up as selected, though, if you scroll down or expand the window.

Pressing Ctrl+A again after scrolling and then pasting gets all the fields to copy and paste, but the aliases still don't come along for the ride. Getting the aliases out of Pro was the main reason I'd hoped that this would just work properly.

Re: Right Click to export table schema to excel

GregAO — Fri, 14 Feb 2025 02:26:23 GMT

I replicate @wayfaringrob 's post of not every field being copied to the clipboard. Tried to copy & paste several times over - it seems to be a hit and miss affair. One should not need to scroll all the way to the bottom of the fields window, to get everything copied. With the number of fields being up to 300 or more, this needs to be corrected as an unsuspecting user would think all fields are copied when in fact they may not be. Note @KoryKramer I am using the method you mentioned in your post dated Oct 7 2019 "ArcGIS Pro export fields table".