|Converting GPX Files to Other Formats for Import to Chart Plotting Software|
|GPX files (Click
on Link to View GPX Specification) appear to have become the accepted standard for the exchange of GPS data
(waypoints, routes and tracks). All current Garmin GPS
accept and generate GPX files and
open source navigation sofware uses GPX as its Import and Export
However, I like many other navigators use Chart Plotting Systems that will either never accept GPX files as input or will only do so via an expensive upgrade.
In 2010 I first found the need to be able to import GPX files to my navigation systems, that include:
|Each of these systems have their own import/export data
formats. SOB and Fugawi use Comma-Separated (CSV) text
files, although Fugawi will also accept GPX files. Raymarine uses a proprietary binary file format,
but it does provide a program to convert waypoints in a formated
Excel workbook to the proprietary file format. Therefore
my immediate need was a means to convert GPX files to either the
CSV format or the Raymarine Excel Workbook. My initial
attempt at this conversion is the Excel VBA program
GPXconvertVBA. The initial release of this program was
The current version is 1.7a.
It is distributed in a zip file that can be downloaded from this site at: Excel/GPXConvertVBA.zip. The contents of this zip file is shown below.
|There are six files in this zip file:|
|If you would like to just download and review the documentation on GPXconvertVBA, the pdf file can be downloaded by clicking here.|
|I have also published a few tutorial videos on using this program, which can be accessed here.|
|This is just an initial version of what I plan to enhance to a more complete waypoint and route management package. Further development of that program will likely not begin until sometime in 2013.|