Groundspeak Forums: convert a gpx file to excel - Groundspeak Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

convert a gpx file to excel how do I do it

#1 User is offline   cad-guy 

  • team Henson
  • Group: +Premium Members
  • Posts: 85
  • Joined: 17-January 05

Posted 20 May 2007 - 06:42 AM

can anybody tell me how to convert, or export a loc/gpx file to an excel spreadsheet. I have been using easygps for editing the coords, but that program doesn't seem to be able to do it. Any help will be greatly apprecaited.

Mike

#2 User is offline   PDOP's 

  • Chinook Country Cacher
  • Group: +Charter Members
  • Posts: 3732
  • Joined: 23-April 01

Posted 20 May 2007 - 08:42 AM

IIRC the latest versions of excel will open a GPX directly.

#3 User is offline   fratermus 

  • prodigal cacher
  • Group: +Premium Members
  • Posts: 1185
  • Joined: 08-January 05

Posted 20 May 2007 - 10:49 AM

View Postcad-guy, on May 20 2007, 09:42 AM, said:

can anybody tell me how to convert, or export a loc/gpx file to an excel spreadsheet.


If I were convinced Excel could do something useful for me I would export out to a poi (.csv) file that excel could read directly.

Most of the time when people are editing/sorting waypoint data in Excel it's something that could be done faster, more accurately, and easier with a gpsbabel filter. Your mileage may vary, of course.

#4 User is offline   NightPilot 

  • Helicacher
  • Group: +Premium Members
  • Posts: 2382
  • Joined: 26-October 03

Posted 20 May 2007 - 12:18 PM

You can use Open Office or Word to do it. They will open the .gpx files as .xml, and then do conversions for you. IMO Open Office is the better way to go. It will also save files directly as .pdf. It does everything MS Office does, including opening, editing and saving Office files, and more, and it's free.

Easier, use GSAK to open the .gpx file and save as a .csv, which Excel can open. GSAK uses GPSBabel to do the conversions, and can handle most file types. You can do everything using GPSBabel directly if you can do command line stuff. I agree with fratermus that GPSBabel is the best way to do this.

#5 User is offline   PDOP's 

  • Chinook Country Cacher
  • Group: +Charter Members
  • Posts: 3732
  • Joined: 23-April 01

Posted 20 May 2007 - 03:12 PM

What are the benefits of GPX?

Quote

GPX is based on the XML standard, so many of the new programs you use (Microsoft Excel, for example) can read GPX files.


#6 User is offline   John E Cache 

  • Premium Member
  • Group: +Premium Members
  • Posts: 945
  • Joined: 09-February 02

Posted 20 May 2007 - 05:58 PM

View PostNightPilot, on May 20 2007, 01:18 PM, said:

You can use Open Office or Word to do it. They will open the .gpx files as .xml, and then do conversions for you. IMO Open Office is the better way to go. It will also save files directly as .pdf. It does everything MS Office does, including opening, editing and saving Office files, and more, and it's free.

Easier, use GSAK to open the .gpx file and save as a .csv, which Excel can open. GSAK uses GPSBabel to do the conversions, and can handle most file types. You can do everything using GPSBabel directly if you can do command line stuff. I agree with fratermus that GPSBabel is the best way to do this.
XML Notepad 2007

#7 User is offline   naviguesser74 

  • Premium Member
  • Group: +Premium Members
  • Posts: 255
  • Joined: 03-December 05

Posted 22 May 2007 - 06:50 AM

you can use GPSVisualizer (a facade for babel) and convert gpx or loc to tab-delineated. then open in excel.

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic