All converters
HomeKML & KMZ converter › KMZ to Excel

Convert KMZ to Excel

By , GIS & remote-sensing practitioner · Reviewed

Convert KMZ to Excel to read the attribute side of a zipped Google Earth file as spreadsheet rows. The decompression and table-building are done by the page itself, with the archive never leaving your computer.

Drop a file here, or click to browse

KML, KMZ, SHP (.zip), GeoJSON, GPKG, GML, GPX, DXF, CSV, Excel, and more

No uploadNo trackingOpen standards (GDAL/OGR)Works offline once loaded

No KMZ file to hand? Download a sample KMZ file (100 points) and drop it above to see the conversion.

How to convert KMZ to Excel

  1. Drop the .kmz file into the drop zone above.
  2. Placemark names, descriptions and coordinates are pulled out of the embedded KML.
  3. Choose Excel and convert, then open the .xlsx to sort and filter the placemark data.

What changes when you convert KMZ to Excel

Every format stores different things, so a conversion is never perfectly loss-free. Here is exactly what carries over when you convert KMZ to Excel, and what to watch for.

WhatKMZ → Excel
GeometryChangesPoint features become X and Y columns; lines and polygons are written to a WKT geometry column, so no shape is lost in the table.
AttributesKeptEvery column and full field name moves from KMZ into Excel untouched.
Styling & labelsDroppedKMZ colours, icons and description balloons are presentation, not data. Excel stores the underlying features, so styling is dropped (the geometry and attributes remain).
Coordinate systemChangesExcel stores raw coordinates without a CRS tag, so note the coordinate system separately for whoever opens the file.
Elevation (Z)ChangesZ values, if present, appear as an extra column rather than 3D geometry.
File structureKeptA single, self-contained .xlsx file you can move around on its own.

Why convert KMZ to Excel?

A KMZ file is a zipped KML map, usually exported from Google Earth with placemarks, paths, and styling bundled inside. Sometimes you do not want the map. You want the underlying table. Converting KMZ to Excel pulls each placemark out as a row, so names, descriptions, and coordinates land in tidy columns. This helps you hand field data to colleagues who do not use GIS. For example, you can sort sites in a workbook, filter by attribute, or build a summary sheet. Excel also gives you typed cells and multiple sheets, which plain KML never offered.

Coordinate system handling

KMZ 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 KMZ data is in the wrong place" surprise; the guide on coordinate systems and EPSG codes goes deeper.

What to check when converting KMZ to Excel

KMZ is a ZIP wrapper, so this tool unzips it and reads the KML inside first. Any bundled icons, ground overlays, or images do not become spreadsheet data. Only placemark attributes and their WGS84 lon/lat coordinates carry over. Also, KML styling and nested folders flatten into rows, so check that longitude and latitude land in separate Excel columns before you map the workbook again.

Which software opens the result

KMZ 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.

Troubleshooting KMZ to Excel

About the formats

A KMZ is a zipped Google Earth map, usually a set of placemarks with names, descriptions and coordinates tucked inside the KML. Excel wants that same information as rows and columns you can sort, filter and total. This conversion opens the archive, reads each placemark, and lays its attributes out as a worksheet. In practice you turn a shareable Earth map into a spreadsheet your team can edit without any mapping software.

Frequently asked questions

Does KMZ to Excel keep the placemark coordinates?

Yes. Each placemark becomes a row, and its WGS84 longitude and latitude are written into columns so you can read or re-map them later.

Can I open the resulting file in LibreOffice or Google Sheets?

Yes. The output is a standard XLSX workbook, so Microsoft Excel, LibreOffice, and Google Sheets all open it directly.

What happens to the icons and image overlays in my KMZ?

Those extras are dropped. A KMZ can bundle custom icons, ground overlays and photos, but a worksheet only holds text and numbers. Each placemark becomes a row, with its name, description and coordinates in columns, while the artwork inside the archive is ignored.

How are lines and polygons written into the Excel sheet?

Point placemarks map cleanly to a latitude and longitude cell. Lines and polygons have many vertices, so their full path is written as a WKT geometry string in one cell instead. The resulting workbook opens the same in Microsoft Excel, LibreOffice or Google Sheets.

What can open a Excel file after converting?

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.

Does converting KMZ to Excel lose any data?

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.

Related converters

You can also pull a KML into Excel, export the placemarks to a CSV table, or go the other way and build a KMZ from a spreadsheet. Everything KMZ-related sits on the KML & KMZ converter hub.

Related reading