I have an Excel file containing data collected over many years as latitude and longitude coordinates for archaeological sites.
How can I import it into QGIS as a new layer?
-
If your data is formatted correctly in Excel (column headers, no extraneous data) then 'save as' from Excel as type CSV.. you will get warnings about CSV not supporting multiple sheets etc but you can ignore them if you keep your existing sheet. Can you give a screen shot of what you have in Excel and indicate what you've tried and where it's failing.– Michael StimsonMar 30, 2017 at 22:26
Add a comment
|
5 Answers
If you already have your data in excel make sure of the following
a)Data must be in decimal degrees
b)First row of the file has the name of the field (this is just an example)
then you have to save the file as a csv comma delimited (not msdos or mac). After opening Qgis you have to look for the "add delimited text layer plugin (a blue postit with commas icon).
You have to define that the delimiter is commas and choose the appropiate x and y fileds. When Qgis Opens the data it will ask for the CRS, you have to define the one for your data. The data you are looking in the image is latlon wgs 84, so I choosed EPSG4326. Once your data is loaded you can save the text layer to another type of file like shp. Hope it helps
-
Improve your answer by adding @Radar note on CRS. As you may be aware, the delim txt import should ask for the CRS.– WillyNov 25, 2012 at 10:49
You can control your tabular data with XYtools plugin.
The aim of the xy-tools-plugin is to fill an x- and y-column of a given attribute table by clicking on a (reference) map. After 'filling the x and y column' you are able to export the table to a point shape file. Since version 0.2 you can also open Excel files, and using an x- and y-column load it as a Point layer.
Importing Spreadsheets or CSV files explains how to do just that.
Note that if your data is in UTM:
You can follow the same process, but choose the appropriate UTM CRS in the Coordinate Reference System Selector instead of WGS84.
-
6I think it would be best if you can post an outline or a summary of the tutorial you linked. Your answer is great but it would be useless if the blog you linked to suddenly went offline.– R.K.Dec 3, 2012 at 4:12
-
And also this doesn't answer the question very well - the question was about Excel files– TomasJul 5, 2013 at 11:33
-
I would argue that a CSV created in Excel is as much an 'Excel file' as a file with a .xls extension as they can be converted to and from each format using Excel. If you want to be really picky the intermediate step would be conversion of the .xls file to CSV using Excel.– RadarJul 5, 2013 at 15:47
-
I agree this answer should be a bit more than a link. Information that you can't simply load Excel file into QGIS and need Excel or other alternative software first to convert it into CSV is critical.– MiroFeb 24, 2016 at 1:28
In QGIS 3, I can recommend the plugin "Spreadsheet Layers" which worked very smoothly for me. No need for multiple steps or a tutorial! https://github.com/camptocamp/QGIS-SpreadSheetLayers
There's an Importing Spreadsheets or CSV files tutorial.
There's an old question with answers at Importing coordinate data from Excel into QGIS
And here's another tutorial: http://maps.cga.harvard.edu/qgis/wkshop/import_csv.php
Basically, you convert your file to a .csv and then use the 'Add delimited text layer' tool, available in the 'layer' -> 'add layer' toolbar.
