Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 2 down vote favorite

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?

share|improve this question
1  
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

2 Answers

up vote 8 down vote accepted

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"
share|improve this answer
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
up vote 2 down vote

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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