5

I have a shape file created as per the answer to my previous question, which includes county level means for each county in the US.

How can I now export this data in a .csv file, e.g. with just the state, county, and county_mean fields?

  • 2
    The answer is in the second hit when you Google "ArcGIS export .csv". – whuber Jun 23 '11 at 19:10
  • @whuber yes, but the answer (as restated below) is to first export to .dbf, open the dbf with Excel, and then export to .csv OR to use an third-party tool. The first workflow is frustrating, the second is satisfactory. – Abe Jun 23 '11 at 19:22
15

ArcGIS will export a .dbf to .txt. You can then rename it to .csv. First turn off the fields you do not want exported under Properties, Fields. Right-click the table, data, export. Select the browse folder button, change the "save to type" to .txt.


Step-by-step instructions to follow comment by @Brandon (ArcMap 10.1)

  • Right Click on .shp in TOC
  • Open Attribute table
  • Click 'table options' tab in upper right of Table
  • Export
  • Next to Output table: click yellow folder
    • change "save as type" to "Text File"
    • change extension to ".csv"
  • 2
    +1. To be clear... the export options from the table view are different than when right clicking in the TOC. For a shapefile, you would first need to open the table view and export using the menu there. Additionally, you can add the .csv extensions directly from the dialog and eliminate the need to rename after. – Brandon Copeland Jun 24 '11 at 15:19
4

According to the ArcGIS forums:

Either:

  • Right Click on .shp file
  • Data -> Export
  • Open .dbf file with favourite spreadsheet program (Excel and Gnumeric work)
  • Export as .csv

Or

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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