Importing Spreadsheets or xlex file and Join Data - QGIS
Spreadsheet Layer plugin
2. Plugins window is appears, click all in the left panel. Type Spreadsheet in the search box, select spreadsheet layers and click Install plugin button.
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, finally click OK button.
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 it in custom field name prefix check box and remove the neme, click OK button. Now see added the data, finally click Apply and OK
3. Now check it your join Data. Right click Vector file(mexico) and click open Attribute Table.