Sign in to follow this  
Followers 0
coman123

Converting GPX files

9 posts in this topic

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

0

Share this post


Link to post

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/

Edited by sdarken
0

Share this post


Link to post

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.

0

Share this post


Link to post

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)

0

Share this post


Link to post

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.

0

Share this post


Link to post

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.

0

Share this post


Link to post

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

0

Share this post


Link to post

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.

Edited by wkmccall
0

Share this post


Link to post

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

0

Share this post


Link to post

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
Sign in to follow this  
Followers 0