KML to Excel Converter
Turn the placemarks in a KML or KMZ file from Google Earth, Google My Maps or a GIS export into an Excel sheet with latitude, longitude, folder and every data field. Free, no sign-in, and read entirely in your browser.
Drop your files here or choose filesTap to choose files
Opened on your device - never uploaded · up to 50MB
Supports .kml, .kmz · or paste a file from your clipboard
No file handy? · download it
How to Convert KML to Excel
- Export the map as KML or KMZ - In Google My Maps, open the menu next to the map title and choose Export to KML/KMZ. In Google Earth, right-click a folder or place and save it as KML or KMZ.
- Add the file - Drop the .kml or .kmz file onto the page. It is read locally in your browser.
- Placemarks become rows - Name, folder, description, latitude, longitude, geometry and every data field get a column; paths and shapes also get a Vertices sheet.
- Download the XLSX workbook - Sort, filter or map the points in Excel or Google Sheets.
What Ends Up in the Workbook
A Placemarks sheet with one row per placemark: its name, the folder path it sits in (so layers from Google My Maps stay apart), its description as plain text, latitude and longitude as numbers, altitude when the file has one, its geometry type, the time stamp if it has one, and a column for every data field. If the map has paths or shapes, a Vertices sheet lists each of their points with the row of the placemark it belongs to.
Why Not Open the KML in Excel?
A KML file is XML, and Excel's XML import flattens it by tag: the coordinates arrive as one text cell such as -89.6501,39.7817,0, longitude first, and a route arrives as one cell holding every point. Here each placemark is read as a whole, so its coordinates become two number columns, a route is listed point by point, and its data fields line up across the sheet.
Other XML Files
For XML that is not a map, use XML to Excel, which finds the repeating records in any XML document.
Frequently Asked Questions
Yes. A KMZ is a ZIP archive with the KML inside (usually doc.kml); it is unpacked in your browser and read the same way. Images and icons in the archive are not needed and are ignored.
KML stores coordinates longitude first (-89.65,39.78). The sheet puts them in separate Latitude and Longitude columns, latitude first, the order most people and mapping tools type them.
A path or a polygon gets one row with its geometry type, its number of points and its coordinates, and every point is listed on a second sheet, Vertices, one row each with the placemark it belongs to. A polygon's outer boundary is listed; holes are not.
Yes. Every ExtendedData field - the attribute table a GIS export or a Google My Maps layer carries - becomes a column of its own, named after the field. HTML in descriptions is reduced to its text.
No. The KML or KMZ file is read in your browser and never sent to a server.