cad-guy Posted May 20, 2007 Share Posted May 20, 2007 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 Quote Link to comment
+PDOP's Posted May 20, 2007 Share Posted May 20, 2007 IIRC the latest versions of excel will open a GPX directly. Quote Link to comment
+fratermus Posted May 20, 2007 Share Posted May 20, 2007 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. Quote Link to comment
+NightPilot Posted May 20, 2007 Share Posted May 20, 2007 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. Quote Link to comment
+PDOP's Posted May 20, 2007 Share Posted May 20, 2007 What are the benefits of GPX? GPX is based on the XML standard, so many of the new programs you use (Microsoft Excel, for example) can read GPX files. Quote Link to comment
John E Cache Posted May 21, 2007 Share Posted May 21, 2007 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 Quote Link to comment
+naviguesser74 Posted May 22, 2007 Share Posted May 22, 2007 you can use GPSVisualizer (a facade for babel) and convert gpx or loc to tab-delineated. then open in excel. Quote Link to comment
map turtle Posted July 5, 2014 Share Posted July 5, 2014 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! Quote Link to comment
+Mineral2 Posted July 5, 2014 Share Posted July 5, 2014 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." Quote Link to comment
+ecanderson Posted July 6, 2014 Share Posted July 6, 2014 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. Quote Link to comment
Recommended Posts
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.