Importing CSV (Excel) Coordinates into QGIS

hello guys welcome to another tutorial in this tutorial we will talk about how we can add this kind of latitude and longitude information into a gem in the form of point data there might be multiple sources how you might end up with this kind of latitude and longitude coordinates now if you are actually using a GPS unit and you're trying to extract the point coordinates of certain points of your interest then your points will be given in terms of latitude and longitude or if you're retrieving data from another external portal or some external source then there's a good chance that the point data might come in latitude and longitude but if you won't use this information to carry out some geospatial analysis it's actually quite essential that you transform this data into some GIS data or at least into GIS software like qga so that you can proceed with the other geospatial operations that you can do based on the needs so let's go ahead and get started with the tutorial first you need to save this file as a CSV file you can see that I have three columns over here out of which these two columns are going to be the most important two columns but then there will be the necessity of knowing what each point actually refers to so it's good if you can add a third point which specifies what the significance or maybe the location of the exact particular point is so once you do that you can just go to file and save as and from here save as type select CSV comma delimited and I'm going to name this as cities Asia alright now as you can see in this example we have some points taken from different cities across Asia South and Southeast Asia so let's see how we can transform this information into a map so go ahead and open up QGIS and you can go to layer and add layer and add delimited text layer now from here just go to the place where you saved your CSV file you can see that there's a CSV called cities Asia over here I'm going to open that up and once you do that you can see that the table already sort of more or less got imported over here it shows it shows up in the sample data right down here but before we proceed we just want to make sure that we have a certain number of correct settings so first the file format is CSV as we already know that and then go to geometric definition and we know that we are going to actually work with point coordinates so just make sure that you have selected point coordinates and one of the most important things over here is that the X and the y field the longitude always comes at the X field so make sure that you select launch longitude at X field and latitude at Y field all right now this decimal degrees were recorded according to the WGS 1984 geographic coordinate system so the coordinate reference system you can actually select this WGS 1984 which is corresponding to e BSG 43:26 and you can click OK and after that you can simply hit add and press close so you can see that we managed to add some points now we would like to verify whether these points were added according to the correct geographical location or not what you can do is we can simply if you do have a shapefile maybe of course your corresponding area a properly geo reference shapefile you can even add that but if you are using quick map services you can simply go to open straight map and add Open Street Map and from here you will be clearly able to see that we managed to successfully import the data like this what I can do is I can even just go to this Open Street Map and maybe decrease the opacity so that the focus will be given to our points like this and now if you go to the cities Asia and go to this attributes table you can see that all of our data is here for example if you select Beijing China you can see that it's actually placed at the correct location similarly if you go to Tokyo Japan you can see that it's over here Kuala Lumpur and Mumbai India like this you can see that the location is actually correct if I now go to properties of this cities Asia you can see some information regarding the the properties of this data but just keep in mind that still this data is actually not geographical data necessarily so in order to convert this into proper geographical data what you can do is you can go to export and save features as and over here select the geographical data type that you would like to I mean now for example you can save it as a shapefile and the file name I'm going to specify as cities Asia and the file type you can see that it's already dot SHP shapefile and the coordinate reference system by default it selected the correct coordinate reference system and what we can do is we can simply hit OK and now we can get rid of this the file which we had earlier which was sort of directly extracting the data from the CSV file all right now you can see that this new cities underscore Asia if I go to the properties you can see that it's a history ESRI shapefiles so now we can do all the stylings that we would normally do with shapefile such as maybe changing the color and the size of the the point and also we can add labels if we wish to we can maybe select the name over here and click apply and click OK and from here you can see that we quite successfully managed to export the data into a shapefile now even if I navigate to the place where I saved this shapefile you can see that this set of files actually corresponding to that particular shape file which we exported so you can just as easily pass on these files to somebody else if you would like them to have this this data in the form of geographical data so the process of adding XY data into GIS is just as easy as that using QGIS so that's about it for this tutorial if you did like the tutorial don't forget to give it a thumbs up and don't forget to subscribe to our channel to stay tuned for the upcoming tutorials as soon as we publish them I'll see you guys in the next one

Channel: GeoDelta Labs

Views: 280,652

Keywords: qgis, plotting, points, adding, importing, csv, data, into QGIS, excel, coordinates, how, how to, plotting coordinates in qgis, adding coordinate data into qgis, from excel, ArcGIS, global mapper, geographic information systems

Id: Xgi-UdyDi1k

Length: 6min 0sec (360 seconds)

Published: Mon Jun 29 2020