Convert waypoint data in Excel file to gpx file?

  • Thread starter Thread starter AllenMcB
  • Start date Start date
A

AllenMcB

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 said:
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.
Click to expand...

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.
 
AllenMcB said:
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
Click to expand...

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
 
Ted Edwards said:
It looks very interesting but does it require Windoze? I run eCS 1.2R.

Ted
Click to expand...

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
 
Ted Edwards said:
It looks very interesting but does it require Windoze? I run eCS 1.2R.
Click to expand...

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.
 
AllenMcB said:
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.
Click to expand...

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.
 
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/
Click to expand...


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?
 

Members online

Total: 41 (members: 1, guests: 40)
Back
Top