Jump to content

convert a gpx file to excel


Recommended Posts

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.

Link to comment

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.

Link to comment

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
Link to comment

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!

Link to comment

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.
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...