Sign in to follow this  
Followers 3
cad-guy

convert a gpx file to excel

10 posts in this topic

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

0

Share this post


Link to post

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

0

Share this post


Link to post

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.

0

Share this post


Link to post

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.

0

Share this post


Link to post

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
0

Share this post


Link to post

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

0

Share this post


Link to post

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!

0

Share this post


Link to post

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."

0

Share this post


Link to post

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.
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 3