Does anyone know how to convert a GPX file to a CSV file so I can download it into my Garmin I5?
Are you using POI Loader to load your POI? Are using the most recent version? POI Loader will read from a GPX file.
However, if you still want to convert it, there are lots of options.
Yes, I am using POI loader...I'm new to this stuff and I didn't realize that it could read a GPX file, I thought I could only use CSV... Thanks so much for the help, hopefully I'll get the hang of it soon.
How do you open a gpx file in Excel to read it's content?
Excel will not allow you to open gpx files only csv. Mapsource will allow you to make gpx files but not csv.
POI Edit and a number of other programs can work both ways.
Here is another tread that discusses some of the issues.
Short of writing yourself onehelluvamacro, you don't.
You can copy it to a .XML file extension and let Internet Explorer open it for you -- this is quite useful if you want to print it.
If you convert it to CSV, then by definition the original structure of the original GPX file will be lost.
Or - the limited, beta version of the editor listed below will READ your file and let you browse through the entries.
I'm assuming it's 'Waypoint' information you're interested in ... and not 'Route' or 'Track' data.
Right click the file and select Open With > Microsoft Office Excel (works with Excel 2003). Then, select "As a read-only workbook".
This will show all of the data that's inside the file. The useful data is several columns to the right, where you'll find:
/wpt/@lat = latitude
/wpt/@lon = longitude
/wpt/name = name
Files may also include other data such as address, phone number, etc.
If you delete the "extra" columns, you could rearrange the remaining columns and save as a CSV file from Excel.
(works with Excel 2003
I stand corrected ... it works with Excel 2002 as well.
One user has reported difficulty opening / saving GPX files with Excel 2000. To work correctly, your copy of Excel needs to have XML support installed.
Does anyone know if Excel 2000 was shipped with XML support?
Can I add phone numbers to a CSV file and actually make phone calls from the Garmin unit or does the file have to be a GPX type?
No, the file has to be in the GPX format in order to use the Bluetooth function on your GPSr to dial the number automatically.
This POI Converter will easily convert your GPX to CSV, then you can look at the CSV with either Excell or Notepad, edit it, and convert back to GPX if you want:
This method is so easy and simple that it is good even if all you want is to see the contents of the GPX file in a more reading friendly format and with the least amount of "clicks" or steps.
And yes, it DOES allow for "Phone" support in the CSV file, the phone number will be preserved and formatted correctly when Converting to GPX, just put the Phone number in the following format:
-80.307999,44.501709,Westin Trillium House,"Blue Mountain
220 Mountain Rd
Phone: (705) 443-8080"
Note that the description needs to be quoted, as it is a multi-line value, and the phone number needs to be on a line by itself prefixed with 'Phone: ', this will load properly, whether loading the CSV file, or the resulting converted GPX file.
If loaded from CSV the Phone number is for info display only, but if you want it to be understood as a phone number then it must be converted to GPX.
I am not aware of any other POI converter tool that will allow you to maintain the Phone number on the CSV file, and then map it correctly to a GPX file.
GeePeeEx Editor has long had that capability. It can recognise Phone numbers, either through the use of column headers, or using its in-built rules to find them in free-form text.
terms | privacy | contactCopyright © 2006-2021