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.

  • 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 '13 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 '13 at 12:57
  • Making plots of thousands of files is probably best done using a script, e.g. written in R. – Paul Hiemstra Dec 19 '13 at 18:44
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

  • 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 '13 at 13:11
  • 1
    @Kimmo: That's not correct. The input data can be in any CRS. – underdark Dec 19 '13 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 '13 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 '13 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 '13 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.

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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