So I have a shapefile with 133 rows of data, and I want to add 4 extra fields to it. My problem is that after I have created the new fields in the attribute table, I have no way to quickly paste the data for these columns from my spreadsheet. Can someone show me how to do this?


Save the spreadsheet as .csv (text) and open it using the CSV button in QGIS. You can then define a join in the properties tab of the shapefile. This will allow you to choose which columns to add to the shapefile. Finally you can save the shapefile using Save As to make the change permanent if required.


You could just open the .dbf file in OpenOffice/LibreOffice Calc and paste it normally the data from your spreadsheet. The dbf file is in your shapefile folder.

  • The problem is, I have many dbf files in my folder for this shapefile, so which one do I pick? – Shuryu Kisuke Jul 12 '17 at 0:54
  • 4
    You only have one .dbf file per shapefile. You can do this to make sure you are editing the right one. Copy the one shapefile you want to edit into an empty folder. This contains probably 4 types: .shp, .prj, .dbf and may be .shx. and they all have the same name of the shapefile. – MKJ Jul 12 '17 at 7:13
  • Thanks, my mistake, I was looking at the entire folder which contained multiple layers of data. – Shuryu Kisuke Jul 12 '17 at 14:20
  • one problem, it is currently taking a very long time to load the document into either libre office or open office, will it load eventually? – Shuryu Kisuke Jul 12 '17 at 14:45
  • I am not sure. Make sure the quality of your data is intact. It is always easy to make some mistakes when pasting over the fields. – MKJ Jul 12 '17 at 14:59

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.