How to convert GPX to Excel
- Drop the .gpx log from your watch, Garmin or app export.
- Everything in the file is read together: waypoints, routes and tracks alike.
- Choose Excel and convert, then open the .xlsx in Excel, LibreOffice Calc or Google Sheets.
What changes when you convert GPX to Excel
| What | GPX → Excel | |
|---|---|---|
| Geometry | Changes | Point features become X and Y columns; lines and polygons are written to a WKT geometry column, so no shape is lost in the table. |
| Attributes | Changes | GPX stores a fixed set of fields per feature (name, comment, description, symbol, type, elevation, time and a few GPS quality values), and those become attribute fields in Excel. Heart rate, cadence and other app extensions are not carried. |
| Styling & labels | Kept | Neither GPX nor Excel stores visual styling, so there is nothing to lose. Geometry and data carry straight over. |
| Coordinate system | Changes | Excel stores raw coordinates without a CRS tag, so note the coordinate system separately for whoever opens the file. |
| Elevation (Z) | Changes | Z values, if present, appear as an extra column rather than 3D geometry. |
| File structure | Kept | A single, self-contained .xlsx file you can move around on its own. |
Why convert GPX to Excel?
GPX comes off a Garmin, a running watch or a Strava or Komoot export as XML, a shape built for devices rather than for desks. A workbook turns the recording into something you can work through: sort the timestamps, chart the elevation profile, delete the stray points a receiver logged under tree cover. It also travels well around an office, since a .xlsx opens for colleagues who have never installed a GPS tool and never will.
Coordinate system handling
No datum decision reaches this page, because a GPX can hold nothing but WGS84, so the latitude and longitude columns fill with the exact degree values the receiver logged, reprojected from nothing and into nothing.
An .xlsx offers no field for a coordinate system, so the workbook stays silent about what its numbers mean, and headers that say it, lat_wgs84 and lon_wgs84 for example, spare the next person the guesswork. Any tool that later maps the rows should be told EPSG:4326, and a round trip through the Excel to GPX converter works because both ends of that loop assume the same datum.
What to check when converting GPX to Excel
The coordinate columns hold WGS84 degrees, and degrees are not meters: the moment the sheet feeds a distance calculation, subtracting two longitudes gives nonsense rather than a length. Keep the latitude and longitude columns as plain numbers rather than formatted text, so the sheet can become a map or a GPX file again later.
Troubleshooting GPX to Excel
- Every timestamp sits a few hours off. GPS hardware logs time in UTC, and the workbook shows the recorded values rather than shifting them to local time. Add a helper column that applies the offset, =B2+TIME(5,0,0) for a zone five hours ahead, and leave the original column as the authoritative record.
- The climb numbers look far too small. Elevation in a GPX is meters, so a 3,000 foot ascent reads as roughly 914 to anyone expecting feet. Multiply into a spare column by 3.28084 rather than overwriting the recorded values, and the original log stays intact for later use.
- The time column shows five-digit numbers or hash marks. Excel stores each timestamp as a day serial and displays hashes when the column is too narrow, or the bare serial when no date format is applied. Widen the column and apply a custom date-time format; the stored values arrived complete and need no repair.
- The workbook opens locked in Protected View. Windows marks files that arrive through a browser, and Excel responds by opening them read-only until Enable Editing is clicked on the yellow banner. The lock says nothing about the conversion, and the rows beneath it are already complete.
About the formats
A GPX file lands on your computer straight from a Garmin unit or a Strava export, packed with track points, waypoints, and timestamps. Excel is where those coordinates become something you can sort, chart, and total. This conversion flattens each recorded point into a spreadsheet row, so distance, elevation, and time turn into columns you can work with in Microsoft Excel or LibreOffice. That is the bridge between field recording and desk analysis.
Frequently asked questions
How many decimal places should I keep in the coordinates?
Six decimal places already pin a point to about 11 cm. Round the display format; do not edit the stored values.
Why choose Excel over CSV for a GPS log?
A workbook keeps typed cells, so times and long decimals are not reformatted on opening.
Can I send the edited points back to a GPS device?
Yes. The Excel to GPX converter turns the rows back into waypoints, and the name column becomes the label the device shows.
What columns should I expect in the Excel file?
Expect a name plus the coordinate pair for every point, with elevation and time filled only where the device recorded them. Fields such as comment, description and symbol appear when the source carries them, and fitness extensions do not get columns of their own.
Related converters
Ready to convert?
Drop a file and download the result in seconds. Nothing is uploaded, nothing is stored.