How to export attribute tables to Excel?

Question

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!

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 09 '13 at 15:22
I am not realy sure what is the eact problem, but csv format is much faster than the dbf format. — Gago-Silva, Jan 09 '13 at 15:36
There are many questions of this kind on this site already, example: http://gis.stackexchange.com/questions/28308/how-do-i-export-an-attribute-table-in-arcgis-version-9-3-1-to-excel — artwork21, Jan 09 '13 at 16:03

veedub · Answer 1 · 2013-01-09T15:42:36.880

9

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

edited Jan 09 '13 at 15:42

answered Jan 09 '13 at 15:36

veedub

658
5
13

There is no 'Copy Selected' in 10.2.2, what other options are there? – randomblink Aug 12 '14 at 13:36
There certainly is in my version (also 10.2.2, version 3552), are you sure that you're looking in the attribute table? – veedub Sep 30 '14 at 13:07
1

right click on grab handle (left most column) opens the dialog too – EikeMike Apr 16 '15 at 10:48

score 5 · Answer 2 · 2013-01-09T16:00:06.280

5

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.

edited Jan 09 '13 at 16:00

answered Jan 09 '13 at 15:43

score 5 · Answer 3 · answered Jan 09 '13 at 15:56

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.

score 3 · Answer 4 · answered Jan 09 '13 at 16:04

3

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

answered Jan 09 '13 at 16:04

KHibma

16,786
1
31
55

How to export attribute tables to Excel?

4 Answers4