Export attribute tables from ArcGIS to Excel.
Okay not the most exciting topics ever approached but hopefully this is useful.
- Open ArcMap and Excel
- ‘Right-Click’ on your polygon layer in ArcMap and select “Open Attribute Table”
- Now Click on the Options button and then “Select All”
- In the right left* hand grey column (see the small black arrow? click there) ‘Right-Click’ to see this menu:
- 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.
Posted in 30 Responses to “Export attribute tables from ArcGIS to Excel.”
Leave a Reply
Mini-Bio
You can find out more about me here at : http://about.me/elliothartley
I'm supporting
Did you attend the GeoDesign Summit 2013?
GeoPlanITon
I'm supporting
Did you attend the GeoDesign Summit 2013?
wow, it works! thanks,
any clou about how too it backwards (copy excel edited table into arcgis??
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…
perfect!! But i am still wondering how to make this with "export data" thing which results with .csv format
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.
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!
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!
i have found that the column you are referring to is on the left side of my screen, then select copy all.
this helps thanks a lot!!!!!!!!!!!!
thank you much!!
very helpful, thanks!
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!
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!!!!!!
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!
Well, I have the same problem… Everything is selected, but the "copy selected" doesn´t work…
Any idea?
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….
you have to right-click on the left border of the table, not on the cells
That just blew my mind!!! Thank you sooo much for your help!
THANK YOU!!! This saved me a few hours of work.
You're welcome, can you pass those saved hours on to me?
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?
thanks a lot, mister
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?
Thank you!
You saved my summer. Why didn’t I see this before?!
Tobbe
c pratique, merci bien pour votre aide
Voila! Perfect! Thanks!
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.
Not sure why this happens, I think the Excel row limit is 65000, perhaps this is a ArcGIS limitation? Sorry can’t be of much help, anyone reading this have any ideas?
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!
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?