Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
how did you go? Maybe you will accept one of the answers below. – Willy Nov 25 '12 at 10:50

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) enter image description here

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). enter image description here

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

share|improve this answer
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

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.

share|improve this answer
I 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 at 1:28

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.

share|improve this answer
Nice but it work just with *.xls file... – GeoStoneMarten May 28 '15 at 8:01

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.