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.
nmtoken
13.6k5 gold badges39 silver badges91 bronze badges
-
2What 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– Curlew2013年12月19日 12:42:51 +00:00Commented 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– Kimmo2013年12月19日 12:57:07 +00:00Commented Dec 19, 2013 at 12:57
-
Making plots of thousands of files is probably best done using a script, e.g. written in R.Paul Hiemstra– Paul Hiemstra2013年12月19日 18:44:44 +00:00Commented Dec 19, 2013 at 18:44
2 Answers 2
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?
answered Dec 19, 2013 at 13:03
-
1I 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– Kimmo2013年12月19日 13:11:40 +00:00Commented Dec 19, 2013 at 13:11
-
1@Kimmo: That's not correct. The input data can be in any CRS.underdark– underdark2013年12月19日 13:29:44 +00:00Commented Dec 19, 2013 at 13:29
-
1Under
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– AndreJ2013年12月19日 13:39:52 +00:00Commented Dec 19, 2013 at 13:39 -
1Hmm. 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– Kimmo2013年12月19日 13:41:45 +00:00Commented Dec 19, 2013 at 13:41
-
1Problem 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– Kimmo2013年12月19日 14:10:04 +00:00Commented Dec 19, 2013 at 14:10
You may also wish to try the "XY Tools" Plugin, that will let you read Excel files directly, without saving them to .csv first.
answered Dec 19, 2013 at 14:11
-
Thank you very much. That would be great. I will test it right away.Kimmo– Kimmo2013年12月19日 14:33:49 +00:00Commented Dec 19, 2013 at 14:33