How to convert Excel to KMZ for Google Earth
A spreadsheet of points is quick to build and hard to picture. This guide shows how to convert Excel to KMZ, so those rows become placemarks you can fly to, click and read. Google Earth cannot open an .xlsx file, so the sheet has to be converted first.
Key facts
- A KMZ is a zipped KML, typically about 16 times smaller (5.2 MB of KML → 0.33 MB).
- Each spreadsheet row with a latitude and a longitude becomes one Google Earth placemark.
- Coordinates must be decimal degrees; south and west values are negative.
Before you start: check the sheet
The payoff is immediate, because every row that has a latitude and a longitude becomes a placemark you can fly to, click and read. Three things decide whether the conversion works on the first try:
- Two coordinate columns, one for latitude and one for longitude. Names such as lat and lon, latitude and longitude, or y and x are detected automatically.
- Decimal degrees, such as 33.6844 and 73.0479, with south and west written as negative numbers.
- A name or title column, so each placemark shows a clear label instead of a plain marker.
Coordinates in degrees, minutes and seconds? Run them through the coordinate converter first; the differences between the notations are covered in latitude and longitude formats.
The 4 steps
The steps are short, and nothing leaves your computer at any point.
- Open the Excel to KMZ converter and drop in your .xlsx file.
- Check the column pickers; the tool guesses the latitude and longitude columns, and a guess can be wrong.
- Choose KMZ as the output format and click Convert.
- Download the file and double-click it, and your points open in Google Earth.
No desktop Google Earth? Google Earth for web opens a KMZ straight from the browser, and the whole conversion runs locally, so the spreadsheet is never uploaded.
KMZ or KML?
Both open in Google Earth, so the choice comes down to size and editing. A KMZ is a zipped KML, about 16 times smaller in the site's benchmark and neater to email, which is why Google Earth exports KMZ by default. A KML is plain text you can edit by hand, so pick Excel to KML when you expect to tweak the file later. Choose KMZ to share and KML to edit; KML vs KMZ has the fuller comparison.
3 problems and their fixes
Most issues trace back to the coordinates, and each has a quick fix.
| Symptom | Cause | Fix |
|---|---|---|
| Points land in the wrong place | Latitude and longitude are swapped | Correct the column pickers and convert again |
| Nothing appears in Google Earth | No real coordinates, or values stored as text | Clean the sheet and reconvert |
| No labels on the markers | No name column | Add one before converting |
The trip also works in reverse: KMZ to Excel pulls placemark data back into a spreadsheet.
“Excel to KMZ is the office-worker path into Google Earth: a sheet of coordinates in, a single double-click file out, and nothing uploaded on the way.”
Frequently asked questions
Do extra columns come along?
Yes. Any extra column, such as a name or a note, becomes part of the placemark's description, so you can read it when you click the point in Google Earth.
Can I get the data back out?
Yes. The KMZ to Excel converter pulls placemark data back into a spreadsheet, one row per placemark, with the coordinates restored as columns.
Will a large sheet be slow?
Rarely. The work happens in your browser with no round trip to a server, so even sheets with thousands of rows convert in seconds.
Can Google Earth open an Excel file directly?
No. Google Earth reads KML and KMZ, not .xlsx. Convert the spreadsheet first, and each row of coordinates becomes a placemark you can open on the globe.
Why are my Excel points in the wrong place in Google Earth?
Almost always the latitude and longitude columns are swapped, or the coordinates are not in decimal degrees. Check the column pickers before converting, and run degrees-minutes-seconds values through the coordinate converter first.