Convert waypoint data in Excel file to gpx file?

Discussion in 'Global Navigation Satellite Systems' started by AllenMcB, Jan 5, 2007.

  1. AllenMcB

    AllenMcB Guest

    Howdy,

    I've been looking for a way (preferably a cmd line method) of
    converting an Excel or csv text file containing waypoint data
    (latitude, longitude, name, description) into a gpx file.

    There are plenty of programs that will save mappoints as gpx files, or
    convert gpx files to Excel, etc, but I haven't found one yet that will
    convert an Excel or a csv file into gpx.

    I've got a series of local points of interest saved in the Excel file,
    and I'd like to be able to export them into a gpx file and forward that
    to some others.

    Can anyone here point me in the right direction?

    Many thanks,

    Allen
     
    AllenMcB, Jan 5, 2007
    #1
    1. Advertisements

  2. AllenMcB

    peter Guest

    I use the g7toWIN program to do that, but it's not cmd line.
    It'll read/write both .csv and .gpx text files so you can convert
    between the two.
     
    peter, Jan 5, 2007
    #2
    1. Advertisements

  3. GeoConv can be used to convert csv-files to gpx and GeoConv is cmd-line
    based

    GeoConv: http://www.kolumbus.fi/eino.uikkanen/geoconvgb/index.htm

    Is you decide to use GeoConv and need any help in setting up or using it,
    please don't hesitate to contact me for help. You find my preferred e-mail
    address from my home page.

    Eino Uikkanen
    http://www.kolumbus.fi/eino.uikkanen/gb/index.htm
     
    Eino Uikkanen, Jan 5, 2007
    #3
  4. AllenMcB

    Ted Edwards Guest

    Ted Edwards, Jan 5, 2007
    #4
  5. Unfortunately I am not familiar with Windoze or eCS 1.2R, but ...

    GeoConv can be run under Window's command prompt as is (without e.g.
    Windoze) without any problems, but I am afraid, that you might encounter
    some problems, if you run GeoConv under some kind of Windows emulators or
    similar. That is because GeoConv uses very deep OS-calls.

    I have started the implementation of the new Java-based GeoConv, but that
    seems to be a never ending project - I haven't touched the code for several
    months - maybe when I retire ;-)

    Eino
     
    Eino Uikkanen, Jan 5, 2007
    #5
  6. AllenMcB

    dold Guest

    What's an eCS?

    gpsbabel.org offers a source download as well as some binaries.
    Google Earth includes a binary of gpsbabel.

    A search for "csv file" on the gpsbabel.org site leads to some help.

    What text manipulation tools do you have? Something like awk or perl could
    build a GPX file pretty easily, presuming there aren't a lot of usable
    columns in the csv file.
     
    dold, Jan 5, 2007
    #6
  7. saying "Excel" is not enough. An excel file can contain the waypoint data in
    any number of different arrangements, coordinate formats, and so on. You'll
    find no program being able to read all kinds of data arrangements.

    Gartrip, for example, will read a tab delimited text file created by Excel
    if the data are arranged like specified in the programs Help.
     
    Heinrich Pfeifer, Jan 6, 2007
    #7
  8. AllenMcB

    Mattan Guest

    With perl the modules Geo::Gpx and Spreadsheet::parseExcel
    should be helpful. See e.g.

    http://www.cpan.org/modules/01modules.index.html

    /Mattan
     
    Mattan, Jan 7, 2007
    #8
  9. AllenMcB

    Kalle Guest

    Kalle, Jan 7, 2007
    #9
  10. AllenMcB

    Ted Edwards Guest

    An operating system. Serenity Systems International took over further
    development and marketing of OS/2 and called the new incarnation
    eComStation. See: http://ecomstation.com/

    More reliable and more secure than Windows.

    Ted
     
    Ted Edwards, Jan 7, 2007
    #10
  11. AllenMcB

    dold Guest


    So it could be fully featured, and not something running on a smartphone or
    PDA, or something.

    I see REXX, java, OS/2, and DOS support, so your choice of tools should be
    pretty broad.

    If it's actually an Excel file, as in Registered-trademark-of-Microsoft,
    the best starting point might be OpenOffice, noted on the ecomstation site.
    But someone noted, maybe you, a dislike for OpenOffice.

    Is this a one-off project, converting a single file, or a continuing and
    large project? What fields exist in the excel sheet?
     
    dold, Jan 8, 2007
    #11
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.