From the course: Learning QGIS
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Adding data from Excel (CSV) - QGIS Tutorial
From the course: Learning QGIS
Adding data from Excel (CSV)
- [Instructor] Often, data does not come in a GIS format. CSV files, or comma-separated values, can contain the X and Y or latitude and longitude, however. They can be created from an export from another GIS or even from a GPS device. Let's look at one now. Here's the incidents.csv. I'll open that up in Excel. Inside the file, it gives all sorts of data about the information and the incidents that happened. The thing that is most important to us is the latitude and longitude. We can use these points or these numbers to create points inside of QGIS. Let's close up Excel. Go back into QGIS. In the background, I've just added an OpenStreetMap layer from the XYZ Tiles, just to give us some context. Next I'll go into Layer, Add Layer, and I'm going to add it from the Delimited Text Layer. This is where I'm going to actually look at that text file and use the X and Y columns to put dots on the map. The first thing I need…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.