8

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!

| 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. – Gago-Silva 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
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).

| improve this answer | |
  • 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
5

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.

| improve this answer | |
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.

| improve this answer | |
3

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

| improve this answer | |
  • Cool ! thank you, my favourite is TableToCSV ;-D – maycca Apr 24 '17 at 7:31

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