Excel to GPX converter

What your spreadsheet needs first

Out on the trail the device shows exactly one thing from this workbook: the name beside each position. That makes naming the real preparation work, since the name column travels into the GPX with the coordinates while budgets, contacts and schedule columns stay home in the planning file.

Shaping a workbook into a waypoint list

• Build labels a glance can read. Names such as Camp 2 or Ford, east bank work in sunlight, and a formula can assemble them, =TEXT(A2,"00")&" "&B2 joining a station number to a site name in one cell.
• Collect coordinates the quick way. A right-click in Google Maps copies a ready latitude and longitude pair, and Data > Text to Columns splits that pair into the two cells the converter expects.
• Keep the tab a clean grid. Summary blocks, subtotal lines and notes paragraphs belong on another sheet, leaving the waypoint tab one header row and one row per stop.

A column headed with a GPX field's own name is the lone exception that carries beyond the label. Treat the workbook as the master copy regardless, and re-export a fresh GPX whenever the plan shifts; the conversion takes seconds to repeat, and the file on the device is always the disposable copy.

Why convert Excel to GPX?

Waypoint lists get built in Excel because a workbook is where planning happens: sites named, coordinates pasted in, rows reordered until the trip makes sense. A Garmin or a phone app cannot open any of that, so the sheet has to become GPX, the one format every handheld and fitness app reads. Converting in the browser keeps the loop tight, and a list of trailheads, sample sites or checkpoints turns into waypoints in the time it takes to drop the file.

Coordinate system handling

A workbook is blind to coordinate systems, and GPX sits at the opposite extreme, accepting WGS84 decimal degrees and nothing besides, so the whole job on this front is delivering degrees. Values copied from Google Maps or a phone's GPS readout already qualify and pass through unchanged.

Numbers pasted from a CAD drawing, a survey report or a national mapping portal usually live in a projected grid measured in meters or feet, and those need their source system declared so the tool can reproject them into degrees on the way in. Nothing needs choosing on the output side, because every GPX reader assumes EPSG:4326 without being told.

What to check when converting Excel to GPX

Set the workbook up before converting: the coordinate table belongs on the first tab, the latitude and longitude columns need clear headers, and the values must be plain WGS84 degrees rather than projected meters. Only the name column travels beside the coordinates, so elevation, date and note columns stay behind; the workbook remains the master copy. Rows without a valid latitude and longitude are skipped.

Troubleshooting Excel to GPX

• Coordinates typed into Excel keep turning into dates. On a system set to comma decimals, Excel reads an entry such as 1.5 as January 5 the moment the cell is confirmed. Format the two coordinate columns as Text or Number before pasting, or change the decimal separator under Excel's advanced options, and re-enter any cells already mangled.
• Rows fed by lookup formulas quietly vanish. A VLOOKUP or XLOOKUP that misses writes #N/A into the coordinate cell, and an error is not a number, so the row is skipped without a warning. Filter for errors, repair the lookups or paste the columns as values, and drop the file again.
• The columns are misread even though headers exist. A decorative title row or a band of merged cells pushes the real headers out of the top row, where column detection looks for them. Delete everything above the header line so the first row holds nothing but column names.
• Stops hidden by a filter still reach the device. Filtering hides rows on screen while leaving them in the workbook, and conversion reads what the workbook stores. Isolate the rows to exclude, delete them outright rather than hiding them, and save before converting.

About the formats

An Excel workbook is where a waypoint list usually starts life: you type site names, notes, and latitude/longitude columns into rows, then need those points out on a device. GPX is what a Garmin unit or a Strava import expects instead, so this conversion reads each spreadsheet row and writes it as a GPX waypoint. It turns an office planning sheet into something a handheld GPS can navigate from in the field.

Related converters