Convert waypoint data in Excel file to gpx file?

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

 

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.

 

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

 

It looks very interesting but does it require Windoze? I run eCS 1.2R.

Ted

 

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

 

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.

 

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.

 

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

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

/Mattan

 

http://www.poiedit.com

Kalle

 

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

 

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?