 Hello, this is Hans van der Kwaas, senior lecturer at IHEAD Dovet Institute for Water Education. In this video I am going to demonstrate how to import spreadsheets into QGIS using the spreadsheet layers plugin. Let's inspect the data. So I'll open now the KNMI stations excel sheet. And I'll see there are different columns with station number, longitude, latitude, altitude and the name of the station. These are meteor stations in the Netherlands. In the other file I see the station number, I see a date and I see the temperature with some conversion value. And I also saw that they have in common the station number, so we can join them together. Of course you can do that in excel, but in QGIS we can also join data. I'll show that in another video. So I installed the spreadsheet layers plugin and I choose add layer, add spreadsheet layer. Then I open the stations file and I indicate the data type because it's not always automatically read in the right way from the excel sheet or if in the excel sheet the things are not set right. So here we see that we define the station number as an integer, altitude as a real and the name of the station as a string. You can change the name there. It will be the label of the layer given in the layer list. We indicate the geometry, the columns that contain the coordinates and the projection EPSG4326 which is latitude, longitude. Now we see our layer is loaded. It is not a GIS file, it's a memory. So let's load the other file. Same procedure. We add the spreadsheet layer, browse to the layer, open it and we set the data type. So again the station numbers should be integer, we can put the date as a date. And indeed the temperatures are real values. This file does have a geometry so we don't have to tick the box. And when we press OK we can see in the layers list that the table is loaded. Now we need to put the point file in the right projection and save it as a shape file so it becomes a real GIS file on our hard disk. So we export it to an S3 shape file and I call it KNMI stations. I choose the projection, the Dutch one in this case. You can also find it through the dialogue if you don't know the EPSG code or you haven't used it before. It will be automatically added to the map can if I press OK. There it is. It's a copy. So they are exactly on top of each other thanks to the on the fly reprojection. So let's remove the old one. And let's set also the on the fly reprojection of the project to the Dutch projection Amersfoort which means that from now on everything loaded in this project which has a projection will be on the fly reprojected to the Dutch projection. Now let's verify if we are still in the Netherlands and everything went well. So I add here the open street map layer from the quick map services plugin and we see indeed that the stations are on the map on the right location. In this video I've demonstrated how to import spreadsheets into QGIS and also how to save those two vector layers to a shape file on the disk. In another video I will show you how to join these two spreadsheets. If you would like to see updates of videos then please subscribe to my YouTube channel. For more free materials on GIS go to IHGDelft OpenCourseWare at GISOpenCourseWare.org.