Convert KML to Excel and audit placemark data, names, descriptions and coordinates, in a familiar spreadsheet grid. Reading and rewriting both happen inside your browser session, upload-free.
Drop a file here, or click to browse
KML, KMZ, SHP (.zip), GeoJSON, GPKG, GML, GPX, DXF, CSV, Excel, and more
No KML file to hand? Download a sample KML file (100 points) and drop it above to see the conversion.
Every format stores different things, so a conversion is never perfectly loss-free. Here is exactly what carries over when you convert KML to Excel, and what to watch for.
| What | KML → Excel | |
|---|---|---|
| Geometry | Changes | Point features become X and Y columns; lines and polygons are written to a WKT geometry column, so no shape is lost in the table. |
| Attributes | Kept | Every column and full field name moves from KML into Excel untouched. |
| Styling & labels | Dropped | KML colours, icons and description balloons are presentation, not data. Excel stores the underlying features, so styling is dropped (the geometry and attributes remain). |
| Coordinate system | Changes | Excel stores raw coordinates without a CRS tag, so note the coordinate system separately for whoever opens the file. |
| Elevation (Z) | Changes | Z values, if present, appear as an extra column rather than 3D geometry. |
| File structure | Kept | A single, self-contained .xlsx file you can move around on its own. |
People build KML in Google Earth by dropping placemarks and tracing paths over satellite imagery. That is great for viewing, but hard to analyze. So they convert KML to Excel to get a real table. Each placemark becomes a row, with its name, description and coordinates in typed columns. Then colleagues who never touch GIS can sort, filter and total the data in Excel. For example, a field team collects survey points in Google Earth. Converting to XLSX lets the office team add notes, run formulas and keep several sheets in one workbook.
KML is already defined in WGS84 longitude/latitude (EPSG:4326), so no guessing is needed on the way in.
Excel stores raw coordinates without a CRS tag, so make a note of the coordinate system for whoever opens the file next. A quick CRS check before you download saves the classic "my KML data is in the wrong place" surprise; the guide on coordinate systems and EPSG codes goes deeper.
KML stores coordinates as longitude then latitude, so check the column order after conversion. Excel just holds the values, it does not know they are geography. Also KML styling, icons and folder structure do not survive. Only the placemark attributes and coordinates become cells. Line and polygon geometry flattens into text or coordinate pairs, so a path in Google Earth will not stay a shape once it lands in your workbook.
KML files typically come out of Google Earth, Google Maps, QGIS, ArcGIS. Once you convert to Excel, the file opens in Microsoft Excel, Google Sheets and LibreOffice Calc, ready to sort and filter. The Excel output follows the standard specification exactly, so those programs read it without any special import settings.
A KML file from Google Earth carries placemarks, their coordinates and any description text wrapped in XML. Excel wants that same information as a flat grid of rows and typed columns. This conversion lifts each placemark out of the markup and lays it on a worksheet, so name, latitude and longitude land in separate cells. In practice you reach for it when a colleague needs the point list inside a workbook, not a map viewer.
Yes. Each placemark becomes a row, and its name and description fields become typed columns in the XLSX sheet. Styling, icons and folders are dropped though.
They appear as longitude and latitude columns in WGS84, matching how KML writes them. You can then open the workbook in Microsoft Excel, LibreOffice or Google Sheets.
Each ExtendedData field becomes its own column, and the description text drops into a cell on the same row. Because Google Earth often stores descriptions as HTML, those cells can hold raw markup, so you may want to clean them up once the workbook opens.
A single point maps cleanly, since one row holds one latitude and longitude pair. For a path or polygon the vertices cannot each become their own column, so the geometry is written as WKT text or reduced to a representative point. Microsoft Excel then shows that as an ordinary cell value.
A Excel file opens in Microsoft Excel, Google Sheets and LibreOffice Calc. Because the output follows the standard specification, any tool that supports Excel will read it without special settings.
No conversion is perfectly loss-free because each format stores different things, but Google Earth styling (colours and icons) is dropped because Excel stores the underlying data, not its presentation; the placemarks and their information are kept.
Similar jobs: convert KMZ to Excel, drop the data into a CSV file, or reverse the trip and make KML from a spreadsheet. They are all on the KML & KMZ converter hub.
