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.

#8 User is offline   map turtle 

  • Tadpole
  • Group: Members
  • Posts: 3
  • Joined: 30-March 06

Posted 05 July 2014 - 09:55 AM

I just want to say THANK YOU to all the people who take the time to answer questions on forums. Excel opened my GPX file beautifully after a few odd dialogue boxes and some wild guesses on my part. There were a lot of columns I didn't need, but the stuff that I really needed was there!

#9 User is offline   mineral2 

  • Premium Member
  • Group: +Premium Members
  • Posts: 563
  • Joined: 01-July 07

Posted 05 July 2014 - 02:08 PM

What are you trying to do in excel?

If you need to then re-save your data in gpx format, be careful not to delete any of the columns "you don't need."

#10 User is offline   ecanderson 

  • Premium Member - This Space for Rent
  • Group: +Premium Members
  • Posts: 3477
  • Joined: 13-January 08

Posted 05 July 2014 - 05:53 PM

View Postmineral2, on 05 July 2014 - 02:08 PM, said:

What are you trying to do in excel?
I haven't had occasion to do it for ages, but one reason I have done this is to evaluate My Finds to determine whether I qualify for some challenge cache or another. For example -- did I really have caches that started with ever letter from A to Z? (Not much of a question now, but it was back then). Easy to do a quick sort in Excel to check for all of the letters. Then there are the challenges related to coordinates of caches, etc. Sometimes it's just handy.

Share this topic:


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