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?
23
-
2Converting an Excel file to CSV is not a GIS question. Converting an Excel or CSV to a shapefile would be. What have you tried so far in the way of testing or research? – PolyGeo♦ Mar 30 '17 at 22:06
-
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 Stimson Mar 30 '17 at 22:26
11
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. – Willy Nov 25 '12 at 10:49
7
This excellent tutorial 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 '12 at 4:12
-
And also this doesn't answer the question very well - the question was about Excel files – Tomas Jul 5 '13 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. – Radar Jul 5 '13 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. – Miro Feb 24 '16 at 1:28
7
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.
2
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
1
There's a tutorial here on importing CSVs or Spreadsheets: http://www.qgistutorials.com/en/docs/importing_spreadsheets_csv.html
There's an old question with answers here: 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.
