Importing Excel Coordinates in QGIS | Convert to Shapefile

hi hello everyone welcome to terah special today i will show you how to import the excel data into qgis so let's get started so now let me show you the excel data i'm going to input into this qgis so let me show my show you my excel data so this is my excel data this is excel data consisting of our sum my sample location and latitude and longitude values so to import into our uh qgas you have to if i go to the file section save as browse so now let me save as a sample location so now choose the save as a type make sure that you choose the delimiter option csv command delimited choose this option now save so the files has been saved into a csv command delimiter so let's import the file into our qgis so now go to the option called layers and go to the option called data layers and add delimiter text layer choose this option delimited text layer so now browse your file location of your excel so so this is my file location the excel data i'm going to import into the into our qgis so click this file so open so now the file has been uh open now you can see that our file mentioning our sample location latin latitude and longitude so i'll show you up so we have all our files from l12 so l20 so we have all our locations now so make sure that our file format csv comma separated values and next is uh make sure the in geometry definition then always in x field always choose a longitude and similarly in y field always choose the latitude now in geometry part in the projection path of the geometry crs make sure that you choose your projection system in my in my case i will choose wgs 84 you can also choose the other projection according to your requirement but wgs is a standard for for my work so i will choose the wgs 1984 that is 84 with authority id of 4326 so now let me click ok so now let me close this minimize it so these are sample location latitude and longitude so now let me add so now close so you can see that these are this is my study area sample locations uh which is in the projection called 90 wgs 1984. so it is in the current projection we have all of the sample points so now suppose if you want to verify the coordinates that has been imported into this qgs it is currently imported to a correct geographic coordinate make sure that go to check that go to the option called web quick max quick map services osm osm standard so now yeah yeah i just added a correct location so it's the points are in the correct location so suppose now if you want to change the color of this uh the point location or you want to label this little this point feature all you have to do is go to the valet called sample location double click the layer now let me choose the single label option so now choose the field uh what field you required to display here in value section i will choose sample locations so i will choose a color for this in the blue color so now the size is in 10 it is okay apply and click ok so now you can able to see my sample location there numbers in our map now let me show you in our attribute table go to the section called the open attribute table so now you can able to first view over sample locations so suppose if you want to view the properties or the details about this uh above this sample location layer all you have to do is right click go to the properties now in the information section you can see the it's our last modified source and the extent and the reference the name the name of the coordinates uh the projection system we are using is wgs 84. so now you can see that still the fight is in the delimited text which is not in our proper geographical data so now to convert to a proper geographical data follow the step so let me uh close this so to know to convert up to a proper geographical data go to the sample location right click export save the feature as so now choose the file format as a esr that is vsr esri shapefile and choose a file name as the sample location so let me choose the file location for that so now let me name as a sample location so click save so after that make sure that you are chosen a correct projection system so in this case i will choose as a wgs1984 suppose if you want to change the projection system click this option and you can change to your required projection so i will choose as wgs that is wgs84 so now click ok so you can see that our geographically geographical data has been added data has been added to here now we can remove our csv delimited file that is that layer we can remove that so now this is a this is a slayer sample location in our layer so now let me show you its property now so now you can able to see that so now you can able to see that it is in the proper sre shape file before it was in the delimited csv file now it is in a proper s3 shapefile that is in proper geographical data so now click ok so now in this video i have shown you how to import the excel data into a qgis so thanks for watching please subscribe to our channel terraspation for more contents please give a like to our channel you

Channel: Terra Spatial

Views: 10,363

Keywords: importing excel file in QGIS, Convert excel to shapefile, QGIS, excel to shapefile, convert, excel coordinate value, shapefile, layer, in QGIS, lat & long to shapefile

Id: cO6ygxZBVCc

Length: 8min 55sec (535 seconds)

Published: Thu Jul 21 2022