Convert KML or KMZ to Excel with Coordinates
Last updated 26 September 2026
Get the placemarks out of a Google Earth file into a table of names, latitude, longitude and height, and onto your own grid.
When you need it
- Someone marked points in Google Earth and you need their coordinates in a table.
- A client sent a KMZ of proposed locations to set out.
- You want an old KML back in Excel on your own grid.
Step by step
- In the web app or the Windows app, press Open and choose the .kml or .kmz file, or drag it onto the window.
- Every placemark point becomes a row: STATION (the placemark's name), LATITUDE, LONGITUDE and ELEVATION when the file has heights. The coordinate system is set to latitude and longitude for you.
- Save Excel or CSV.
On your own grid
To get eastings and northings as well, type the grid in Grid for exported coordinates under Quality checks — an EPSG code such as 32640, or part of its name — before saving. If you had already chosen a grid before opening the file, it is filled in for you. The saved sheet then has the grid's easting and northing beside the latitude and longitude, and a DXF is drawn on that grid. See latitude and longitude to UTM for more.
What comes across
- Points only. Lines and shapes (paths and polygons) are skipped; only placemark points become rows.
- Names and coordinates. Descriptions, balloon text and styles are not read.
- Heights are whatever the file holds. Placemarks drawn in Google Earth are usually “clamped to ground” with a height of 0, which is not a surveyed level.
- KMZ files are unzipped and the KML inside is read. If one can't be read, rename it to .zip, take out doc.kml and open that.
And back again
Once the points are in the table, every save works as usual — back to KML or KMZ with your own markers, or to DXF, Shapefile or GPX. See KML vs KMZ.
Try it with your own sheet