new & interesting places for your GPS

GPX to CSV

 

Hi,
Does anyone know how to convert a GPX file to a CSV file so I can download it into my Garmin I5?
Thanks

Are you using POI Loader to

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.

http://www.gpsu.co.uk/

http://www.masterclass.com/gpxtopoi/gpxtopoidownload.html
.

GPX to CSV

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.
Thanks again
*THE-KING*

.gpx files

How do you open a gpx file in Excel to read it's content?

--
Garmin 660

.GPX

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.
http://www.poi-factory.com/node/2073

--
Garmin Nuvi 660,Software Ver. 3.2, Audio 1.8, GTM 3.7, GPS 2.9, BT 2.4, NA Map v8: Mapsource; Cingular Treo 650

Excel...

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.

--
------------------------ Phil Hornby, Stockport, England ----------------------               http://GeePeeEx.com - Garmin POI Creation made easy           »      

Opening GPX with Excel

Robert660 wrote:

How do you open a gpx file in Excel to read it's content?

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.

JM

Excel 2002

JM wrote:

(works with Excel 2003

I stand corrected smile ... it works with Excel 2002 as well.

--
------------------------ Phil Hornby, Stockport, England ----------------------               http://GeePeeEx.com - Garmin POI Creation made easy           »      

Excel / XML Support

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?

JM

Can I add phone numbers to a

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

hokieguy wrote:

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.

Easy GPX to CSV conversion and Phone support

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:

http://sites.google.com/site/lschwabe/

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
Collingwood, ON
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.

--
GARMIN nuvi 760 sites.google.com/site/lschwabe/

?

LSchwabe wrote:

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.

--
------------------------ Phil Hornby, Stockport, England ----------------------               http://GeePeeEx.com - Garmin POI Creation made easy           »      

sponsored links



Navigation



User login

Leave this blank! This field helps block spambots.

poi factory



Who's online

There are currently 17 users and 68 guests online.

Online users

  • Tim_Devlin
  • Michael1368
  • pierre123
  • d-moo70
  • Patrick Warren
  • blake7mstr
  • adck4545
  • brentrn
  • t923347
  • johnm405