Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.
Sign up to join this community
Possible Duplicate:
How do I export an attribute table in ArcGIS version 9.3.1 to Excel?
We are running 10.0 and are trying to simply export an attribute table to Excel other than exporting to dbf and opening straight away in excel.
The problem is our GIS Manager does not trust everything that is exported as far as formatting etc..changed info from database to excel.
In other words..when we view the attribute table they want the same identical view in excel!
You can select all records in the attribute table using the grab handle (left most column) and by holding the Shift key (then choose 'Copy Selected'). Then simply open Excel and paste the values.
This is much quicker than exporting to .dbf (unless of course you need to edit the attribute table data, in which case, it's preferable to do this in ArcMap using the Field Calculator and/or Editor utilities).
The Xtools Pro extension will do this, it will also let you choose the fields you want to include in the export, which can make things go faster if you have a table with dozens of fields and you only need a few of them. It's a paid extension but only some of its features require paid registration, most of them (including the Export to Excel one) are free to use indefinitely.
One of the table export options is Text, which is really in CSV format, so it can be easily opened in Excel without concern of truncated field names (and other DBF issues).
Alternately, there is an add-on that allows export to Excel.
