Select to view content in your preferred language

How do I export the contents of a shape file as a csv or xls file using ArcGIS9.3.1?

4347
3
12-28-2014 10:26 PM
WalterWitt
Deactivated User

I have edited a shape file in ArcGIS 9.3.1. and now I want to export the contents of the shape file in a csv or xls format for use in another software package. I find the Geodatabase export choice unworkable and an unwanted distraction. Same with dbf, the only other choice I am offered by the Arc software.

Walter

0 Kudos
3 Replies
MuhammadAttique
Regular Contributor

Dear Walter

try it

Stop Edit then Open Attribute Table - Export it to .dbf

.dbf file can easily be open by Excel 2010 or you can import .dbf into Ms Access table and get your results.

Thanks

Attique

0 Kudos
WalterWitt
Deactivated User

Thanks jive

There is already a dbf with the shape file name, as part of the shape file package. I could rename it and so on but it seems a round about way of doing things

Cheers

Walter

0 Kudos
MuhammadAttique
Regular Contributor

Actually when we create a shape file , it is not a one file,

it is the combination of 6 files i,e .sbx .cpg .dbf .shp .shx .prj

we can not open a single file.

it only be read by Arc Catalog or Arc Map

that's why I suggest that open attribute table of that shape file and then export it , this .dbf is convertible.

Thanks

Attique

0 Kudos