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.