Export chart data
The charts in Geo Tracker cover speed and altitude. To build your own charts or analyze a track in a spreadsheet, convert the track file into a table.
Convert a GPX file into a table
Section titled “Convert a GPX file into a table”- Share the trip as a GPX file and save it on your computer.
- Download the stylesheet GeoTracker.xslt.
- Convert the file with
xsltproc:On macOS, installTerminal window xsltproc --nonet --output track.tsv GeoTracker.xslt track.gpxxsltprocwithbrew install libxslt. For Windows, see the libxml downloads. - Open
track.tsvin Excel, Numbers, Google Sheets or another spreadsheet app.
What the table contains
Section titled “What the table contains”Each row is one track point, with these columns:
- Date
- Time, in UTC
- Latitude
- Longitude
- Altitude, in meters
- Speed, in meters per second
- Speed, in kilometers per hour
The speed columns are filled only if the file was exported with Export extended data turned on. See Extended data in GPX and KML files.