This tutorial will cover how to add tabular data to a QGIS project.
Tip: GIS software prefer tabular data to be in
.csvformat, rather than
.xlsx. Before attempting to bring any spreadsheets into either QGIS or ArcGIS Pro, please be sure to Save as .csv.
In the main QGIS menu (banner across the top of the computer screen), select
Layer → Add Layer → Add delimited text layer.
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.
No Geometry (attribute only table).
Point coordinatesand define which field in the spreadsheet is
X(longitude), and which is