Importing XY coordinates to QGIS

I was having some problems yesterday trying to import some xy (latitude and longitude) points into QGIS using the Delimited Text plugin. It turns out that a) my Excel spreadsheet should have been exported as “Windows Comma Separated” rather than the default (Mac) “Comma Separated Values,” and b) the last column in the file MUST have values the whole way down in order for the plugin to determine the number of columns (and therefore, apparently, which column has the x and y values). I was being lazy and hadn’t input all the zero values that should have gone in; now I probably should go back and do that.

Hopefully this will help someone else.

P.S. If you’d like to fill in all the empty cells, you can follow these directions. You can just copy and paste into the selection, rather than doing the formula thing.

3 thoughts on “Importing XY coordinates to QGIS”

  1. Topas says:

    Thank you for the tipp. I currently work on a GIS project displaying wolf regions in Switzerland, I have to import x/y coords (sightings) in the map.
    I will try your way.

  2. Val says:

    Thanks for the info! I'm new to qgis…

  3. Anonymous says:

    Add another to the count of qgis noobs you've helped!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.