Join Gordon Luckett for an in-depth discussion in this video Adding data from Excel (CSV), part of Learning QGIS.
Often data's not in any kind of GIS format.…CSV, comma separated values, can contain the X and Y,…or latitude and longitude columns.…They can be created as an export from another GIS,…or even from a GPS device.…Let's look at a CSV now.…In Exercise Files, under DATA, CSV,…there's a CSV file called incidents.…We open that up in Excel,…you can see we have file,…reportedtime, occurence, and crimetypes.…
Inside the CSV we also have two columns,…a latitude and a longitude with the x and y values…of where each crime took place.…We can actually use this Excel sheet,…or CSV file inside of QGIS.…Let's close Excel,…don't bother saving, and open up QGIS desktop.…Just to add some context I'm going to add…the ROAD_CENTERLINES to the map first,…before I add my crime incidents.…So now under Layer, Add Delimited Text Layer.…
We'll browse to that same text file we were just looking at,…that incidents.csv, and click open.…Make sure the File format is CSV (comma separated values).…We also have to choose what the X and Y field are.…So the X field is long, or longitude.…
Author
Gordon Luckett
Released
8/29/2015- Explain how to determine if you should install the 32-bit or 64-bit version of QGIS on a Windows 10 machine.
- Write the command that will navigate you to the "Add WFS Layer from a Server" dialog window in QGIS.
- Identify what format WMS typically delivers images in.
- State which layer properties tab allows you to edit the line layers of a shapefile.
- List the labels tab that should be selected to edit the visibility of vector data labels at certain scales.
- Identify what programming language the OpenLayers plugin is written in.
Skill Level Beginner
Duration
Views
-
Introduction
-
Welcome47s
-
-
1. Understanding and Installing QGIS
-
Overview of QGIS features5m 21s
-
Installing QGIS1m 30s
-
Exploring the QGIS browser3m 43s
-
-
2. Vector Data with QGIS
-
Adding shapefiles to QGIS2m 22s
-
Adding WFS data to QGIS3m 52s
-
3. Raster Data with QGIS
-
Adding ECW data3m 51s
-
Adding WMS data4m 46s
-
Adding DEM data4m 22s
-
4. Styling Data
-
Working with point layers3m 52s
-
Utilizing polyline layers3m 30s
-
Exploring polygon layers4m 6s
-
Using thematic layers6m 5s
-
Working with DEM layers3m 1s
-
-
5. Labeling Features
-
Labelling vector data7m 6s
-
-
6. Changing Default Properties
-
Exploring project properties8m 46s
-
-
7. Printing with Print Composer
-
Adding maps5m
-
Adding elements4m 17s
-
-
8. Creating New Data
-
Creating new vector data4m 59s
-
Adding data from Excel (CSV)2m 50s
-
Editing existing data4m 59s
-
-
9. Using Advanced Tools
-
10. Using Plugins
-
Conclusion
-
Next steps38s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Adding data from Excel (CSV)