QGIS will load (and save) most kinds of spatial data. However, often our starting points is some spreadsheet data with coordinates, so we'll start by loading some data into QGIS from a spreadsheet. Let's assume you have been sent some vulnerability analysis data, and you need to load it in order to carry out some analysis.
Note: You can use the buttons down the left-hand of the screen to add various kinds of data layers.
QGIS doesn't work well directly with Excel or other spreadsheet files, but you can load CSV, so if you are working with a spreadsheet, save it as CSV first.
Layer > Add Layer Add Delimited Text Layer, and select the data
Note: Loading spreadsheet data is something that can be done in a number of ways in QGIS. As well as the method described here, you can also use
Add Vector Layerand browse to an Excel file (though all the fields will be imported as strings), or try the
Note: You will get a message saying there are some errors in the file - this is because some records in the CSV don't have cooordinates - just click
Closeand carry on
We'll now have a look at the data in a bit more detail.
Fields button, you will see a list of the columns from the CSV which you imported
Pop_1 column appears as
Text, instead of an integer field.
, in it, it decided (wrongly) that it was text.
Pop_1 to omit the commas.
Note: If you want full control over the datatypes (i.e. string, date, integer etc) used by QGIS on importing a CSV file, use a CSVT file to set them explicitly.