Step-by-step tutorials for working on mapping projects using GIS methods and software.
This tutorial will cover how to add tabular data to a QGIS project.
Tip: GIS software prefer tabular data to be in
.csv
format, rather than.xlsx
. Before attempting to bring any spreadsheets into either QGIS or ArcGIS Pro, please be sure to Save as .csv.
Open QGIS.
In the main QGIS menu (banner across the top of the computer screen), select Layer → Add Layer → Add delimited text layer
.
Under File name
select the ellipses dots icon to navigate to the .csv
you wish to import.
Pay attention to Record and Field options
. You can start by accepting the defaults, but depending on the way your data is structured, you may want to make use of some of these settings.
Geometry definition
select No Geometry (attribute only table)
.Point coordinates
and define which field in the spreadsheet is X
(longitude), and which is Y
(latitude).Select Add
.
Close
.