{"id":4599,"date":"2017-12-27T13:06:18","date_gmt":"2017-12-27T12:06:18","guid":{"rendered":"http:\/\/www.sigterritoires.fr\/?p=4599"},"modified":"2018-02-27T19:59:47","modified_gmt":"2018-02-27T18:59:47","slug":"qgis-joins-with-excel-tables","status":"publish","type":"post","link":"https:\/\/www.sigterritoires.fr\/index.php\/en\/qgis-joins-with-excel-tables\/","title":{"rendered":"How to join data from Excel to an attribute table in QGis"},"content":{"rendered":"

The present topic is meant as a brief review since the possibility of loading and attach Excel tables was introduced by QGis 1.8.
\nAs we do not follow the general logic, for new users it is not easy to find the answer. So, step by step, how to make a join between a spatial layer (we’ll take an example here with a shapefile<\/a>) and a non-spatial table like Excel (with or without XY fields). To load an Excel table in QGis it is not necessary to go through a plugin (XY Tools, MMQGIS, …). You will use XY Tools if you want to transform the Excel table with X and Y fields as a spatial layer of points.<\/p>\n

By cons if what you want is to join the Excel table to an existing spatial layer through a key (plot number, name of the owner, …) it’s quick and easy.<\/p>\n

1- Load the Excel table in QGis<\/h2>\n

This is the trap. To do this, you will use the Load Vector Layer button.<\/strong><\/em>
\n\"bouton<\/a>It must be known because the Excel table is not a vector layer.<\/p>\n

Check that \u00ab\u00a0 All files <\/strong><\/em>\u00a0\u00bb is selected, otherwise you will not see Excel files.<\/p>\n

\"s\u00e9lection<\/a><\/p>\n

The Excel table then appears in the list of layers. You can open the table in the same way as other tables in the spatial layers loaded in QGis. You can also switch to edit mode, edit the table and save it. You will have updates to your Excel table, in the same way as if you had done them with Excel.<\/p>\n

\"table<\/a><\/p>\n

2- Load the spatial layer<\/h2>\n

Now load the spatial layer to which you want to attach the information contained in the Excel table.
\nFor our example we will load a shapefile with oyster farms.<\/em><\/p>\n

\"table<\/a><\/p>\n

We will now join the Excel table using the ZTABISSEM <\/strong> field of the shapefile layer and the STATION <\/strong> field of the Excel table.<\/p>\n

Joining Shapefile – Excel<\/h2>\n

Double-click the shapefile layer in the Layers panel
\nThe properties window of the layer opens. Select Joints <\/strong> <\/em> tab and click on the green cross to add a join.<\/p>\n

\"onglet<\/a><\/p>\n

The join definition window opens<\/p>\n

\"dialogue<\/a><\/p>\n