Join a polygon layer with an Excel file (GMR): reads the Excel workbook with its real column headers, matches on a join field you choose, and outputs only the polygons whose codes match, keeping the polygon attribute table enriched with the Excel columns.
Polygon & GMR links your plots (polygons) to a management table (Excel file, GMR). The plugin takes two inputs: a polygon layer (already loaded in QGIS or imported from a file such as Shapefile, GeoPackage or GeoJSON) and an Excel file (.xlsx / .xls). It reads every sheet of the workbook and extracts the real column headers, which are listed grouped by sheet, so you can pick exactly which header to join on. You then choose the join field on the polygon side and the matching header on the Excel side. The plugin performs the cross-check: the output layer contains only the polygons whose code matches a row of the Excel file, with the original polygon attribute table completed by the columns of the Excel file. Code comparison is robust (trimmed spaces, integers read as reals such as 12.0 versus 12, optional case-insensitive matching). A detailed log reports the number of matches, polygons with no match and Excel codes that were not found. Excel reading relies on GDAL/OGR shipped with QGIS, so there is no external dependency (no pandas, no openpyxl), and everything works fully offline with your local data. Typical use: matching agricultural or cadastral plots with a producer register, for example for EUDR due diligence in West African cooperatives. VERSION FRANCAISE - Polygon & GMR relie vos parcelles (polygones) a un tableau de gestion (fichier Excel, GMR). Deux entrees : une couche de polygones (chargee dans QGIS ou depuis un fichier) et un fichier Excel (.xlsx / .xls) dont il lit toutes les feuilles et les vrais en-tetes de colonnes, presentes regroupes par feuille. Vous choisissez le champ de jointure cote polygone et l'en-tete correspondante cote Excel, puis le plugin realise le croisement : la couche de sortie ne contient que les polygones dont le code concorde avec une ligne du fichier Excel, avec la table attributaire d'origine des polygones completee par les colonnes du fichier Excel. Un journal detaille indique le nombre de concordances, de polygones sans correspondance et de codes Excel non trouves. Fonctionne entierement hors ligne, sans dependance externe.
Plugin Tags