How to Add Excel file CSV with Shape file in QGIS 2021 ENGLISH

hello viewers have a good day today we will learn how to add excel file into qgis as well as how to add excel file with shapefile i have this excel file before going to open this excel file into qgis we have to save this excel file as a csv file so how can this excel file save as csv file you just click here file after that you can click here save as and you just write this file name i want to write this file name as table okay table table one after that you should remember that save as type should be csv comma daily meet it that mean dot csv file you should select this and after that save this okay so now i will again go to qgis now i want to open that excel file in qgis so for that go to layer then add layer and here search add daily meter text layer just click on it new window will open you just search here your file name so my file is table 1 so select this table 1 file and then click on open so after that you can see the layer name that is table one that i have saved so after that you click on geometry definition because you don't have any point coordinate so you should select on no geometry you should select this no geometry and you can see whatever the values or attribute was in my excel file all are showing here the state code state name person mental female so it's okay after that just click on add and close so you can see in layer panel table one little edit now i want to add this table with my shape file so how can i add this you just click on india shape india state right click go to properties here you can see the join after that in the lower portion you can see add new join just click on this green plus icon a new window will appear you can easily see that join layer autumn automatically air selected table one because only one csv file is open in my layer panel that is why the join layer automatically selected okay the next one is join field click on drop down menu and select in which criteria by you want to join this table so i want to join by state name okay after that there is a one field target field so i you just select this so join field state name and target field is sd name okay after that you just you can also click here join and join field after that you can only select whatever you need or what kind of activity you want to join so i want to join this person male and female these three attribute i only i want to add with my shape file so click this then okay apply and okay after that you can we can open attribute table and when i enlarge this table you can see the table one person table one male and table one female these three these three new attributes are added with my shapefile we can do further work such as photoplate map so i want to show one demo that is go to properties go to symbology go to categorize [Music] select a value that is i want to select the person after then you can just click on classify [Music] so on the message of that values you can just click on apply and okay so on the basis of the attribute whatever you add from the excel file you can do any kind of uh root map for your further study so thank you for watching you

Channel: RS and GIS with Dr. Manoj

Views: 63,543

Keywords: Excel file, Adding points, CSV file, Import excel file, QGIS, CSVfileinQGIS

Id: q6yVNcpnD8I

Length: 6min 26sec (386 seconds)

Published: Fri Jun 11 2021