Excel to KML Converter — XLSX to Google Earth, Free
Convert xlsx or xls coordinates to KML or KMZ for Google Earth. Handles text-formatted cells, custom number formats and DMS values. Nothing uploaded.
Paste coordinates or drop a CSV/Excel file, then export KML or KMZ.
Coordinates in
One coordinate pair per line. Decimal degrees, DMS (28°36'50"N) and DDM (N28°36.833') are all recognised, and mixed input is fine. Add altitude and a label after the pair: 28.6139, 77.2090, 216, Tower A
Drop a .csv, .xlsx, .kml or .kmz file here, or
0 points
Nothing to show yet — paste coordinates or drop a file above.
KML output
You're on 7BusyBoss — 300+ free tools that run instantly in your browser. No signup, nothing uploaded.
The problem with coordinates in Excel
Excel is unusually good at damaging coordinate data. A cell holding 28.6139 may be stored as a number, as text, or as a number with a display format that rounds it to two decimals on screen while keeping the full value underneath. Copy that visible value out and you have moved your point by about a kilometre. Cells beginning with a degree sign or a hemisphere letter are always stored as text, and a leading apostrophe — Excel's "treat this as text" marker — is invisible in the grid.
How this tool handles it
The workbook is read at the cell level rather than from the rendered display, so the stored value is what gets converted, not the rounded one you see. Text cells are run through the same coordinate parser as pasted input, which means a column of 28°36'50"N values converts without you reformatting the sheet first.
Sheets, headers and .xls
The first worksheet in the workbook is used. If your coordinates live on a later sheet, move or copy them to the first one before converting. Both the modern .xlsx format and the legacy .xls binary format are supported. Header detection is automatic — if the first row looks like column names, it is treated as one, and you can toggle that if the guess is wrong.
Check the preview before you download
Every parsed row appears in a table showing the coordinate in all three notations, so a misidentified column is obvious at a glance rather than after the file lands in Google Earth. Rows that could not be read are listed separately with the reason.
For a flat text file, the CSV to KML converter is the better door. To pull coordinates out of an existing KML into a spreadsheet, use KML to CSV.
How to use the Excel to KML Converter
Takes about a minute. No signup, no download, your data stays in your browser.
- 1Open the tool. Scroll up to the Excel to KML Converter above — it loads instantly in your browser, no install needed.
- 2Enter your values. The fields come pre-filled with realistic defaults so you can see how it works — replace them with your own numbers.
- 3Read the result. The output updates instantly. Copy or share it — nothing is uploaded to a server, everything stays on your device.
Frequently asked questions
Common questions about the Excel to KML Converter.
Does it read .xls as well as .xlsx?
Yes, both the modern XML-based .xlsx format and the older binary .xls format are supported. Only the first worksheet is read.
My coordinates show fewer decimals in Excel than in the output. Why?
Excel display formatting rounds what you see without changing what is stored. This tool reads the stored value, so the output is more precise than the cell appeared — that is correct behaviour, not an error.
Can I include altitude and place names?
Yes. Map an altitude column and a label column using the dropdowns. Altitudes are treated as metres, and the label becomes each placemark name in Google Earth.
Community rating
Discussion (0)
No comments yet. Start the discussion.
Keep exploring
Related tools across 7BusyBoss — all free, all instant.
More in Geo & Coordinate Converters
- KML to CSV Converter
- Coordinates to KML Converter
- Coordinate Converter
- DMS to Decimal Degrees Converter
- CSV to KML Converter