Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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!

share|improve this question
    
I suspect your GIS manager has no problem reading dbf files in excel as a terminal process, although does not want to see spatial data edited in excel and brought back into ArcGIS. –  Aaron Jan 9 '13 at 15:22
1  
I am not realy sure what is the eact problem, but csv format is much faster than the dbf format. –  A.R Jan 9 '13 at 15:36
    
There are many questions of this kind on this site already, example: gis.stackexchange.com/questions/28308/… –  artwork21 Jan 9 '13 at 16:03
add comment

marked as duplicate by artwork21, whuber Jan 9 '13 at 19:38

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

4 Answers

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).

share|improve this answer
add comment

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.

share|improve this answer
add comment

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.

share|improve this answer
add comment

These tools (which work in 10/10.1) convert to Excel. Download from ArcGIS.com

share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.