Export attribute tables from ArcGIS to Excel.

Okay not the most exciting topics ever approached but hopefully this is useful.

  1. Open ArcMap and Excel
  2. ‘Right-Click’ on your polygon layer in ArcMap and select “Open Attribute Table”
  3. Now Click on the Options button and then “Select All”
  4. In the right left* hand grey column (see the small black arrow? click there) ‘Right-Click’ to see this menu:
  5. Now switch to a blank workspace in Excel and paste your data, voila!

Okay you can export this data as a file but after step 3, select ‘Export’ and select your file format dbase, txt, File and Personal Geodatabase tables. I tend not to use this method as I find copy and paste far simpler.

Updated: Click on the left column/border (in grey), thanks to Pepix for spotting my error, apologies for any confusion.

{lang: 'en-GB'}

39 Responses to “Export attribute tables from ArcGIS to Excel.”

  • Pepix:

    wow, it works! thanks,
    any clou about how too it backwards (copy excel edited table into arcgis??

  • Elliot:

    Thanks for your kind words, I'm glad my blog post has been of some use! As to your query I haven't pasted it in the way you descibe. I'll have a look and post something here if I find anything…

  • Anonymous:

    perfect!! But i am still wondering how to make this with "export data" thing which results with .csv format :)

    • Oli:

      In response to Elliot and Anonymous on the 15th of May regarding exporting into .csv file you do not necessarily have to export it as a .txt before converting it into a .csv in Excel as long as you already have a .csv file anywhere on your pc. When using ‘Export’ (under ‘Option’ in your opened ‘Attribute table’) you simply have to find your way (browse) to this already existing .csv file (browse ‘Output Table’ in the ‘Export Data’ pop up window, then use ‘Look in’ in the ‘Saving Data’ window to go where the file is) and click on it (once!) (Make sure that ‘Save as type’ is ‘Text file’ while you are looking for you old .csv file otherwise it won’t appear). Once you have clicked on it and its name appears in the ‘Name’ window of the ‘Saving Data’ window, change the name of the file (write the name you want to save it as) but leave the .csv extension. Then browse back to where you really want this file to be saved using the ‘Look in’ drop down bar (i.e you have now chosen the name and the format, but need to find the right folder where you want to save it as the current folder was only used to find the old .csv file). Click ‘Save’. Done, your data is now in a .csv file that can be directly opened in Excel without having to import it as .txt. Hope this is not too convoluted.

  • Elliot:

    In response to Pepix (apologies for the substantial delay): If you have MS Access you can always open up your geodatabase in there, I have found that useful for pasting in excel data. Obviously this depends on whether this is just a data table or actually a layer with say polygons in it. You need a feature in the layer to paste you data to, so create using edit in ArcMap your polygons/points/lines and then open it up in excel and paste the data. WARNING: I'm only outlining how you might go about it, please proceed with caution and always backup your data before trying this!

  • Elliot:

    In repsonse to Anonymous on the 15th May 2010 – I'm not sure exactly what you want to do but if its creating a csv file then follow the steps above to make a TXT file. This is a csv file (i'm not sure why you can't name it a csv), anyway you can open up txt files in Excel, it then asks a series of questions (a text import wizard) before opening it. Basically the txt file is your table seperated by commas (,) not tabs….. hope this helps!

  • Anonymous:

    i have found that the column you are referring to is on the left side of my screen, then select copy all.

  • Anonymous:

    this helps thanks a lot!!!!!!!!!!!!

  • Olga:

    thank you much!!

  • Anonymous:

    very helpful, thanks!

  • Anonymous:

    thanks for the post. however, when I try to do step 4 "Copy selected" can not be selected. Does anyone know why or do you have another idea on how to export the data into excel.
    Thanks a lot!

    • jonah:

      use the xtools pro version 6.0. When you have it? a lot of tricks you can make…. it will make your work more easier…. gudluck!!!!!!

    • alam:

      I Guess you are in the editing mode. i had problem with exporting as dbf and exporting this way is way too easy. just stop editing and follow the steps.

  • Elliot:

    In response to anonymous on the 6th August:
    Thanks for reading my post, the "copy selected" can only be clicked on if you have selected rows in the table. Sometimes you can unselect by accident when right clicking on grey column…. hope this helps!

  • Anonymous:

    Well, I have the same problem… Everything is selected, but the "copy selected" doesn´t work…
    Any idea?

  • Elliot:

    hmmm I've not come across this, what filetype is this and is anything else going on (edit mode on or off? etc)? Can anyone reading this help? I'll tweet it and see if anyone can respond….

  • Pepix:

    you have to right-click on the left border of the table, not on the cells

  • Anonymous:

    That just blew my mind!!! Thank you sooo much for your help!

  • Anonymous:

    THANK YOU!!! This saved me a few hours of work.

  • GeoPlanIT:

    You're welcome, can you pass those saved hours on to me? :)

  • arcdumb:

    i’m trying to do this with a table i created within arcmap i opened it selected all the cells but the “copy selected” is greyed out still, i really need help….

  • I’ve not come across the option being greyed out as you describe it. As long as you have selected all the cells I would have thought this method works. Perhaps you could provide more details or go to the ESRI web forums for more expert help? Anyone reading this got any suggestions?

  • Asirin:

    thanks a lot, mister

  • Odin:

    YES!
    Thank You!!
    Holy heck, I messed around a lot trying to figure this out, and so simple. Why not have this in the ARC help menu?

  • Tobbe:

    Thank you!

    You saved my summer. Why didn’t I see this before?!

    Tobbe

  • Najoua:

    c pratique, merci bien pour votre aide :)

  • Juan:

    Voila! Perfect! Thanks!

  • Albin:

    It doesn’t works if I want to copy a lots of rows to excell. When I copy and paste about 3000 rows (only two columns),after this operation in excell is only about 2000 rows.
    I dont know why.

  • Patrice:

    Excel didn’t let me paste it when I tried this, but then again I tried it with 15,000+ rows… Maybe there is a limit from ArcMap or something… Exporting to .txt and opening as a csv from Excel worked great though. :) Thanks for the tips!

  • Jason:

    When I export a database to (.DBF) it ends up truncating the last digit (in my case from 10 digits to 9) from any LONG field types in my database. It happens with both File Geodatabase and (.MDB) ones. I am using ArcGIS 10 SP5. Does anyone else experience this?

  • mikel:

    how can i copy a column in excel to arcgis 10?
    in arcgis9 you can copy a column from excel to a column of arcgis table but in version10 it is not allowed? how can we do?

  • TT:

    I was having trouble with getting it to paste into Excel (using Ctrl-V), but finally got it to work by right clicking in a cell in Excel and selecting Paste Special, then selecting Text. Takes a couple seconds for a big file, but not too bad..
    Hope this helps.

  • Patrick:

    Hi.
    This works for me on some layers, on others the attribute table just shows row one but none of my data?
    Do you know why this happens, and what i can do about it.
    When selecting the data everything shows up in the identify window, but somehow it forgets everything when i want to look at it in the attribute table?

  • David:

    This is amazing, I’ve been looking for this for a while. Thank you! I don’t know why the hide the function in the side bar, they should put it in the main drop down list.

  • Claire:

    That is amazing, thank you. You have saved me lots of time stressing about how to do this :)

  • Tom Bombadillo:

    Thanks buddy!

Leave a Reply

CityEngine Consulting & Training
CityEngine can handle lots of data types & isn't just about modelling cities.
  • OS Opendata or Mastermap
  • OpenStreetMap
  • GIS data
  • 3D Models
    I can advise you on how to use CityEngine effectively.
    I can help you obtain 3D City data from CyberCity3D
    I can also hold training and workshops for you.
    You can connect with me in a number of ways click here to choose :
    http://about.me/elliothartley
  • Mini-Bio
    You can find out more about me here at : http://about.me/elliothartley
    Google+
    I'm supporting