Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

Help converting co-ordinates to GPX

  • 21-01-2013 04:45PM
    #1
    hamguy
    Registered Users, Registered Users 2 Posts: 53 ✭✭


    Hi everyone,
    I'm looking for assistance convert an excel file containing about 270 gps coordinates to kml or gpx.

    I've managed to convert - but my co-ordinates are possibly the correct format.

    For example, this is one line:

    Regional Hospital (Limerick) Limerick 52N3804 08W3910

    Is there anyone that can assist please?

    (I hope this is the correct forum!)

    Thanks


Comments

  • #2
    Alun
    Registered Users, Registered Users 2, Paid Member Posts: 21,534 ✭✭✭✭Alun


    Checking on my maps, they would appear to be degrees / minutes / seconds rather than decimal degrees, so your example of 52N3804, would be 53° 38' 04" North, for example (and NOT 53.3804° North).

    If you have them as an excel file you should be able to write a simple formula to convert them into the format required by GPX, i.e. decimal degrees, with any latitudes W of Greenwich being negative, and any latitudes S of the equator being negative also.


  • #3
    MunsterGeo
    Registered Users, Registered Users 2 Posts: 8 ✭MunsterGeo


    Not strictly related but probably the best place to ask witput starting a new thread...

    What is the format of coordinates used in Geocaching? Is it decimal degrees or degrees / minutes / seconds?


  • #4
    GhostInTheRuins
    Registered Users, Registered Users 2 Posts: 6,022 ✭✭✭GhostInTheRuins


    MunsterGeo wrote: »
    Not strictly related but probably the best place to ask witput starting a new thread...

    What is the format of coordinates used in Geocaching? Is it decimal degrees or degrees / minutes / seconds?

    It's degrees and decimal minutes, I think.

    This format anyway:
    N 53° 14.591
    W 006° 17.887


Advertisement