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).

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.

1

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.

  • Oh thanks. How do I take this dbf file which extracted in excel and manipulate it to develop a choropleth – Sam Apr 13 '17 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 Apr 13 '17 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 Apr 13 '17 at 20:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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