GPX to CSV / XLSX / KML / GeoJSON
Convert GPS trackpoints & waypoints into spreadsheets, KML, or GeoJSON — 100% private client-side processing.
Active Converter
GPX to CSV / Excel / KML / GeoJSON: Translating Garmin, Strava & Outdoor GPS Logs
Technical Anatomy of GPX 1.1 XML Tracks
GPX (GPS Exchange Format) is the open Topografix XML schema used by handheld GPS units, cycling computers, and running watches. A .gpx document anchors all coordinates on the WGS84 datum inside <wpt> (waypoints), <rte> (planned routes), and <trk><trkseg><trkpt lat="..." lon="..."> (recorded trackpoints), carrying child <ele> altitude in meters and UTC <time> stamps.
Translating .gpx into KML reorders coordinates into lon,lat,ele tuples for Google Earth 3D terrain viewing; exporting to GeoJSON builds RFC 7946 LineString or Point features for Leaflet and Mapbox; and exporting to Excel / CSV unlocks elevation-profile charting and fleet mileage auditing.
Raw GPX Trackpoint Input vs. KML & GeoJSON Output
<!-- Input: Garmin / Strava Track (atlas_trail.gpx) -->
<trkpt lat="33.5271" lon="-5.1104">
<ele>1645.2</ele>
<time>2026-11-18T08:15:00Z</time>
</trkpt>
# Converted Excel / CSV Output:
Latitude,Longitude,Elevation,Time
33.5271,-5.1104,1645.2,"2026-11-18T08:15:00Z"
Real-World Software & Hardware Ecosystem
Hikers, surveyors, and fleet managers export .gpx files from Garmin Edge / Fenix, Strava, Komoot, AllTrails, OsmAnd, and DJI flight logs, then convert them for Google Earth Pro, QGIS, ArcGIS, Mapbox, and Microsoft Excel.
Troubleshooting & Edge Cases
- Missing Elevation (
<ele>) on Planned Routes: Web route planners sometimes omit elevation tags; the CSV exporter outputs empty elevation cells rather than shifting timestamp columns. - 1 Hz Trackpoint Bloat: A 6-hour bike ride at 1-second sampling generates 21,600+ trackpoints. Use Batch ZIP mode when converting an entire season of rides simultaneously.
- Coordinate Precision: Five decimal places of latitude/longitude provide ~1.1-meter ground precision; never round GPS coordinates to 2 decimal places in Excel or your trail will snap into coarse 1-km blocks.
Spatial Coordinate Order Comparison (GPX vs. KML vs. GeoJSON)
| Format | Coordinate Order | Primary Ecosystem |
|---|---|---|
| GPX 1.1 | lat="..." lon="..." | Garmin, Strava, Komoot, OsmAnd, Suunto |
| KML 2.2 | lon,lat,altitude | Google Earth Pro, Google My Maps |
| GeoJSON (RFC 7946) | [lon, lat, alt] | Mapbox, Leaflet, PostGIS, QGIS |
Desktop GIS CLI Equivalents (GPSBabel & GDAL ogr2ogr)
Surveyors and GIS pipelines often script bulk track conversions using gpsbabel or GDAL's ogr2ogr. Adawaty Pro brings the same WGS84 coordinate translation directly to your browser without installing binary GIS libraries:
# Convert GPX tracks to KML or GeoJSON via command line:
gpsbabel -i gpx -f atlas_trail.gpx -o kml -F atlas_trail.kml
ogr2ogr -f GeoJSON atlas_trail.geojson atlas_trail.gpx tracks
Calculating Segment Distance, Pace & Cumulative Elevation Gain in Excel
After exporting a Garmin, Strava, or Suunto .gpx activity to .XLSX or .CSV, you have direct access to every WGS84 Latitude, Longitude, Elevation, and UTC Time sample. You can compute accurate point-to-point ground distance between consecutive rows using the spherical Haversine formula in Excel: =6371000*ACOS(COS(RADIANS(90-A2))*COS(RADIANS(90-A3))+SIN(RADIANS(90-A2))*SIN(RADIANS(90-A3))*COS(RADIANS(B2-B3))).
For elevation analysis, sum only positive deltas (=MAX(0, C3-C2)) across smoothed 5-point rolling averages to filter out barometric or GPS vertical jitter (typically ±5–10 meters on handheld units). When preparing routes for 3D terrain flythroughs in Google Earth Pro, exporting directly to KML automatically flips coordinates into lon,lat,ele order and wraps the entire track cleanly.
When sharing outdoor trail routes with hiking clubs or emergency rescue coordinators, export both a GPX file for dedicated Garmin/Suunto watches and a KML file for quick 3D terrain inspection in Google Earth. Stripping redundant heart-rate and cadence XML extensions when converting to CSV keeps route spreadsheets clean, compact, and ready for instant distance and slope-gradient charting in Microsoft Excel or Google Sheets.
Frequently Asked Questions
Each
GPX writes lat="34.03" lon="-5.00" as separate attributes, whereas KML
Yes. Export to .XLSX or .CSV to get clean Latitude, Longitude, Elevation, and Timestamp columns ready for elevation charts, distance formulas, or GIS attribute joins.
Waypoints (