Groundspeak Forums: Converting GPX files - Groundspeak Forums

Jump to content

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

Converting GPX files To .xls

#1 User is offline   coman123 

  • Founder of the Lennox and Addington Geocachers
  • Group: +Premium Members
  • Posts: 291
  • Joined: 31-December 08

Posted 01 April 2009 - 10:01 AM

Is there a way to take a pocket queries in a .GPX file and read it in excel, so I can keep a spread sheet of all my finds?

Or convert .GPx to XLS

Thanks

#2 User is offline   sdarken 

  • Geocacher
  • Group: +Premium Members
  • Posts: 459
  • Joined: 24-June 06

Posted 01 April 2009 - 10:17 AM

If you open the .gpx file in GSAK you can export as a .csv file ( File / Export / As .txt .csv). You could then open that .csv file via Excel. I haven't tried this myself so I'm not sure what it would actually look like.

Here's another option that I haven't used myself so I can't vouch for it:
http://gpspois.wikispaces.com/

This post has been edited by sdarken: 01 April 2009 - 10:20 AM


#3 User is offline   Singletree Expedition 

  • Singletree Expedition (Premium Member)
  • Group: +Premium Members
  • Posts: 174
  • Joined: 19-January 07

Posted 01 April 2009 - 10:23 AM

View Postcoman123, on Apr 1 2009, 02:01 PM, said:

Is there a way to take a pocket queries in a .GPX file and read it in excel, so I can keep a spread sheet of all my finds?

Or convert .GPx to XLS

Thanks

What version of Excel do you have? Excel 2003 will open the GPX since it is XML. That said, there are other tools such as GSAK that may be better suited for your needs.

#4 User is offline   coman123 

  • Founder of the Lennox and Addington Geocachers
  • Group: +Premium Members
  • Posts: 291
  • Joined: 31-December 08

Posted 01 April 2009 - 10:31 AM

I am actually using Open Office so in fact they use .ods files but can read .xls files

If I try to open a .gpx file with open office caculator, it converts it to a word doc and wont read in in Caculator (excel)

#5 User is offline   ernbob 

  • Geocacher
  • Group: +Premium Members
  • Posts: 25
  • Joined: 14-October 07

Posted 01 April 2009 - 10:56 AM

View Postcoman123, on Apr 1 2009, 10:31 AM, said:

I am actually using Open Office so in fact they use .ods files but can read .xls files

If I try to open a .gpx file with open office caculator, it converts it to a word doc and wont read in in Caculator (excel)



I tried renaming it to .xml and dropping into Calc and unfortunately that didn't work (worked with Excel...) I think you're best bet it to use GSAK.

#6 User is offline   Singletree Expedition 

  • Singletree Expedition (Premium Member)
  • Group: +Premium Members
  • Posts: 174
  • Joined: 19-January 07

Posted 01 April 2009 - 10:59 AM

View Postcoman123, on Apr 1 2009, 02:31 PM, said:

I am actually using Open Office so in fact they use .ods files but can read .xls files

If I try to open a .gpx file with open office caculator, it converts it to a word doc and wont read in in Caculator (excel)

One option would possibly be using http://gpsvisualizer.com to convert the GPX to plain text, then open (or copy) that into Calc. You may have to use the "Text to Columns" feature to get the columns to work out.

#7 User is offline   Team Olsson 

  • Premium Member
  • Group: +Premium Members
  • Posts: 104
  • Joined: 22-August 07

Posted 01 April 2009 - 12:54 PM

I did a export to csv/txt tab separeted and opened it in exel 2007 no problem.

#8 User is offline   wkmccall 

  • Caching When Can
  • Group: +Premium Members
  • Posts: 598
  • Joined: 31-August 07

Posted 01 April 2009 - 01:06 PM

View Postcoman123, on Apr 1 2009, 01:31 PM, said:

I am actually using Open Office so in fact they use .ods files but can read .xls files

If I try to open a .gpx file with open office caculator, it converts it to a word doc and wont read in in Caculator (excel)


I have one of my laptops that has OpenOffice also and I can open csv and xls files without any problems.

This post has been edited by wkmccall: 01 April 2009 - 01:08 PM


#9 User is offline   robertlipe 

  • Chief Babel-Head
  • Group: Moderators
  • Posts: 4989
  • Joined: 23-December 01

Posted 01 April 2009 - 05:59 PM

GPSBabel has several output formats that work well with OO and Office, too.

Share this topic:


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