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?
-
2The answer is in the second hit when you Google "ArcGIS export .csv".– whuberJun 23, 2011 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.– AbeJun 23, 2011 at 19:22
Add a comment
|
2 Answers
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. Jun 24, 2011 at 15:19
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
- Download the tool for ArcToolbox written by Dan Patterson here