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 files

Opened on your device - never uploaded · up to 50MB

Choose files

Supports .kml, .kmz · or paste a file from your clipboard

No file handy? · download it

How to Convert KML to Excel

  1. 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.
  2. Add the file - Drop the .kml or .kmz file onto the page. It is read locally in your browser.
  3. Placemarks become rows - Name, folder, description, latitude, longitude, geometry and every data field get a column; paths and shapes also get a Vertices sheet.
  4. 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

Related Tools