0

I have an Excel-sheet where the coordinates are in meters. What is the most efficient way of inputting this file to QGIS? There are thousands of files to put so please recommend some straight-forward solution.

3
  • 2
    What do you mean with inputting? Do you want to generate a point layer? Coordinates in meters according to what? Please specify the nature of your data.
    – Curlew
    Dec 19, 2013 at 12:42
  • Sorry, by inputting I meant importing. I have Excel-sheets where the coordinates are in Adindan / UTM zone 37N -format. I need to be able to import those sheets to QGIS and project the points on a map.
    – Kimmo
    Dec 19, 2013 at 12:57
  • Making plots of thousands of files is probably best done using a script, e.g. written in R. Dec 19, 2013 at 18:44

2 Answers 2

1

You save the sheet as a CSV file (Comma Separate Values format) and then import the layer as Delimited Text. In older versions of QGIS this feature was available as an installed plugin. Now it is available directly from the Layer menu.

see

How to add csv file in QGIS 2.0 using Delimited Text Layer Plugin?

QGIS 2.0 text delimited layer importing data as single row

5
  • 1
    I know the CSV importing, but it only accepts the coordinates in degrees or in DMS. I have the coordinates in Adindan / UTM zone 37N -format. This is the problem...
    – Kimmo
    Dec 19, 2013 at 13:11
  • 1
    @Kimmo: That's not correct. The input data can be in any CRS.
    – underdark
    Dec 19, 2013 at 13:29
  • 1
    Under Settings -> Options, CRS tab you can specify that QGIS should prompt you for the CRS of new layers, instead of using WGS84 as default.
    – AndreJ
    Dec 19, 2013 at 13:39
  • 1
    Hmm. When I try to import the data, Q-GIS creates the "Delimited text file" in WGS-84 without asking to put the CRS. I cannot see the coordinate points of the file on a map.
    – Kimmo
    Dec 19, 2013 at 13:41
  • 1
    Problem solved. There was a thousand separator in the Excel-file which prevented the correct file formation. Now it works like a dream. Thanks for pushing me to try more!
    – Kimmo
    Dec 19, 2013 at 14:10
1

You may also wish to try the "XY Tools" Plugin, that will let you read Excel files directly, without saving them to .csv first.

1
  • Thank you very much. That would be great. I will test it right away.
    – Kimmo
    Dec 19, 2013 at 14:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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