I try to add geocaches with x,y coordinates in a xls-table to qgis and convert to shp.file.

Usally geocach-coordinates are like this: N 51° 29.440' E 011° 56.430' (WGS84) (in german its called "bogenminute) . But it seems that qgis only know geographic coordinate system (WGS 84) with coordinates like this one: 51.754683 12.000967 ("dezimalgrad"). So i can charge them from one to another but i think its sensless. There must be a easier way.

Is there another geographic coordinate system ,qgis has, to add the points directly from the first format (bogenminute)?

  • Are your coordinates in two columns - one for latitude one for longitude?
    – Simbamangu
    Jun 4, 2013 at 7:11

3 Answers 3


You could use regular expressions in the field calculator (QGIS 1.9 / 2.0, not 1.8!) to extract the appropriate numbers and do some basic arithmetic. If your latitude is in the 'lat' column:

regexp_substr("lat", '(\\d+)') + (regexp_substr("lat", '(\\d+).(\\d+)') / 60)

From your example - N 51° 29.440' – this gives 51.4906667.


Unfortunately, QGIS' Add Delimited Text Layer plugin can only import coordinates in decimal degrees (51.754683 12.000967) format and not in the degrees, minutes, seconds (N 51° 29.440' E 011° 56.430') format.

  • ok thank you for helping. is there another way/plugin who can import in format deegrees, minutes, seconds?
    – user12700
    Nov 12, 2012 at 15:02
  • 1
    Not in Qgis, but in Excel: office-loesung.de/ftopic512318_0_0_asc.php. You can import the result into Qgis.
    – AndreJ
    Nov 12, 2012 at 15:21
  • as Andre Joost already told you, you can easliy convert to decimal degrees in your spreadsheet (Excel, OO, Libreoffice,...): Decimal lat/lon = degrees + minutes/60 + seconds/3600
    – Kurt
    Nov 12, 2012 at 16:37
  • 1
    ADDENDUM:Keep in mind that South latitude and West longitude are negative
    – Kurt
    Nov 12, 2012 at 16:44

In QGIS 2.8 it is possible to load it with Add Delimited Text Layer and check the DMS Coordinates checkbox next to the X field and Y field combo boxes.

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.