How to copy an Excel column into QGIS

Let's assume that you have the following table in Excel:


The QGIS attribute table:


You have two options to append the last column from the first table to the QGIS attribute table.

1. Copy/paste the column into a .dbf

The first option is straightforward; open the .dbf file and copy/paste the column (similar to how you'll do it in Excel). If you have errors while trying to save your data, go to the second option.

2. Join the column in QGIS

Notice that to be able to do the join, both tables need a common field.

  1. Save the Excel file as a .csv.
  2. Add a CSV layer.
    • Important: mark the option that the layer does not have a geometry.

Add CSV layer

  1. Right-click on the shapefile layer, and go to the Unions tab. Click on the plus green button and join the Names layer using the field in common.

Add Vector join

  1. If you open the attributes table, you'll see the new column.

Final result

Hi, I'm Erik, an engineer from Barcelona. If you like the post or have any comments, say hi.