View Single Post
Old 04-25-2009, 10:03 AM   #3 (permalink)
dcb
needs more cowbell
 
dcb's Avatar
 
Join Date: Feb 2008
Location: ÿ
Posts: 5,038

pimp mobile - '81 suzuki gs 250 t
90 day: 96.29 mpg (US)

schnitzel - '01 Volkswagen Golf TDI
90 day: 53.56 mpg (US)
Thanks: 158
Thanked 269 Times in 212 Posts
It looks like gpx is a standard XML schema based format, can be read directly by most anything these days without writing your own parser or resorting to perl

for this excel example I had a gpx file at c:\tmp.gpx (actually I just saved http://www.topografix.com/fells_loop.gpx since I don't have a gps)

I went into Excel
then hit:
Data->Import External Data->New Web Query
Then for address I put in the location of the gpx file:
file:///C:/tmp.gpx

And then I was looking at tons of data I had to scroll right to see the parts that change since it is expanded to rows.

fyi, using excel 2002
Attached Files
File Type: xls Book1.xls (55.5 KB, 43 views)
__________________
WINDMILLS DO NOT WORK THAT WAY!!!
  Reply With Quote