1

I want to find the least challenging method of getting a shapefile into Excel.

I understand this is often achieved using an .svg file (which must be converted from an .shp).

Improve this question

2 Answers 2

Reset to default
2

Once you create a shp file, it creates five other extensions and one of them is the DBF extension, which you can open it in Excel.

Improve this answer
3
  • Oh thanks. How do I take this dbf file which extracted in excel and manipulate it to develop a choropleth
    – Sam
    Commented Apr 13, 2017 at 19:45
  • 1
    In Excel you have to locate to the DBF file for that specific shp file by using Open/Browse/All Files(file type). Once you manipulate the data then you can simply load the shp file into a GIS software.
    – Selim Erguden
    Commented Apr 13, 2017 at 20:03
  • 3
    @Sam IMO unless you really know what you're doing, make a copy of the DBF to use in Excel. You can potentially corrupt the attributes of your shapefile.
    – Bjorn
    Commented Apr 13, 2017 at 20:06
1

Do you mean you want it to display in excel? if youre just wanting the attribute data then you can either select all the records in the attribute table and copy them over to a new excel sheet, or you can open the DBF file for the appropriate shapefile and then edit the data that way.

Improve this answer
2

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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