Import Spreadsheets or xlsx File and Join Data in QGIS

Spreadsheet Layer plugin

You can use the Spreadsheet Layers plugin to convert Spreadsheet in Excel to GIS in QGIS. The advantages are that you don’t need to replicaie the same data over and over again, and it’s more accessible to non-GIS.people also.

Install Spreadsheet Layers Plugin-

1. Click on Plugin menu and select Manage and Install plugins.

2. In the Plugins window, click (i) All in the left panel > Type Spreadsheet in the search box (ii) > then select Spreadsheet Layers plugin (iii) from the below window and click Install plugin button (iv) > click the close button to the close window.

3. As you can see a new Tool is added to Manage Layers Toolbar.

4. Click Spreadsheet layer tool, Spreadsheet window is appears, Browse File (Excel file-mexico data),Excel file has multiple sheet, select sheet. your Data is added.

5. Finally, click the OK button to close the Create a layer from a spreadsheet file window.

Now see, add to Excel data file your QGIS layer panel.

Join Data

1. Now Right click on your Vector data (mexico), select Joins, click ‘+’ sign button.

2. Add vector join window is open, select Join layer (i), then Join field (ii), and Target field (iii) (remember- ‘join field’ and ‘target field’ are same). Check custom field name prefix check box and remove the name. Click OK button.

Now see added the data, finally click Apply and OK, to close the Layer Properties window.

3. Now check it your join Data. Right click Vector file (mexico) and click open Attribute Table.

Remember, that table join is not permanent, only saved temporarily within the project (.qgs) file. So Save your project immediately.