Help
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
Page 1 of 1
convert a gpx file to excel how do I do it
#3
Posted 20 May 2007 - 10:49 AM
cad-guy, on May 20 2007, 09:42 AM, said:
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.
#4
Posted 20 May 2007 - 12:18 PM
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.
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.
#5
Posted 20 May 2007 - 03:12 PM
What are the benefits of GPX?
Quote
GPX is based on the XML standard, so many of the new programs you use (Microsoft Excel, for example) can read GPX files.
#6
Posted 20 May 2007 - 05:58 PM
NightPilot, on May 20 2007, 01:18 PM, said:
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.
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.
#7
Posted 22 May 2007 - 06:50 AM
you can use GPSVisualizer (a facade for babel) and convert gpx or loc to tab-delineated. then open in excel.
Share this topic:
Page 1 of 1