[GIS] Export attribute table values to CSV

arcgis-10.2arcgis-desktopasciicsvexport

I am getting false parsing and un-necessary quotes for 3 numeric fields when exporting table to ascii (CSV). Items are all DOUBLE. "675,654","5,567,000" is the resulting export format which should be …..,675654",5567000,….. I have checked all ITEM property settings at table level but not yet in catalogue. Will do that next. This is with Arc GIS 10.1, Windows 7 Enterprise P1. Everything points to the fields being well defined as numeric Double INT, no decimals. Anyone have problems with the ASCII table exporter doing bad parsing of numerics?

Best Answer

This process maybe lengthy, but it's worth it. Click on "file" on the attribute table. Go to Export, and click on the "Output", click on "Save as type" and select dbase table. After this process, simply go to conversion tool in ArcToolbox. Select "To Excel from Table". You can then change the data to CSV from there.

In Excel, Click on "File", select "Save as", and choose CSV.