KMZ to Excel Converter
Convert KMZ and KML files to an Excel spreadsheet for free. Files stay on your device, every attribute is kept, and each placemark becomes one row.
Accepted: .kmz, .kml. Up to 20.0 MB, converted on your device.
Your file never leaves your device. Nothing is stored on any server.
Placemarks collected in Google Earth or a field app are easy to look at on a map but hard to count, sort, filter or hand to a colleague who lives in spreadsheets. This KMZ to Excel converter turns every placemark into one row of a real .xlsx workbook, with its name, description, coordinates and every attribute in its own column, ready for pivot tables, mail merges or a quick check of the numbers. It runs entirely in your browser, so the file is never uploaded.
How to convert KMZ to Excel
Select or drag a .kmz or .kml file. The map preview and layer list show every placemark so you can check that the file was read correctly.
Choose how the coordinates are written (Longitude and Latitude columns, or one WKT column) and whether each top-level folder becomes its own worksheet.
Click Convert and download the .xlsx workbook. Open it in Excel, Numbers, Google Sheets or LibreOffice.
What is a KMZ file?
A KMZ file is a KML document compressed into a ZIP archive, the default way Google Earth saves and shares map data. Inside is a doc.kml with the placemarks themselves, the folder hierarchy they are organised in and the ExtendedData attributes attached to each placemark, sometimes together with icons or photos. Because it is zipped, you cannot open it in a spreadsheet directly; it has to be unpacked and flattened into rows first.
What is an Excel file?
An Excel .xlsx file is an Office Open XML workbook: a zipped package of one or more worksheets, each a grid of columns under a header row. Unlike plain text formats, cells keep their type, so numbers and dates stay numbers and dates. It opens in Microsoft Excel, Apple Numbers, Google Sheets and LibreOffice Calc. For geographic data the usual layout is one row per location, with longitude and latitude coordinate columns next to the attribute columns.
What ends up in the spreadsheet?
Each placemark becomes one row. The first columns are Folder (the full folder path, for example "Survey / Block A"), Name and Description, followed by Longitude and Latitude as numbers. If you prefer, the coordinates can be written as a single WKT column instead, such as POINT (116.397 39.909).
After that comes one column for every ExtendedData attribute found in the file, with the original field name kept exactly as it is. Lines and polygons cannot be described by a single coordinate pair, so their geometry is written to a WKT column. Placemarks without coordinates are not dropped: they still get a row, with the coordinate cells left empty.
Why use this converter
One row per placemark
Every placemark is written as exactly one spreadsheet row, so the row count matches what you see in Google Earth and you can sort, filter, count and total the data straight away.
Attributes become columns
Names, descriptions, ExtendedData and SchemaData fields, and the key/value tables that Google Earth hides inside HTML descriptions are all written as separate columns with their original names.
Folders become sheets or a Folder column
By default each top-level folder gets its own worksheet, and a Folder column always records the full folder path. Prefer one long list? Switch to a single sheet before converting.
Nothing is uploaded
Everything runs in your browser. Your files are never uploaded, so confidential survey, cadastral or forestry data stays on your computer.
Excel (.xlsx) or CSV?
An .xlsx workbook keeps non-ASCII field names and values, such as Chinese, Thai or Indonesian text, intact without any encoding settings. It can hold several worksheets in one file, stores column widths so the sheet is readable when it opens, and keeps numbers as real numeric cells instead of text.
CSV is the more universal format: every database, GIS tool and scripting language can import it, which makes it the better choice when the spreadsheet is only a step on the way to another system. This page writes .xlsx only; for CSV use the KMZ to CSV converter.
Frequently asked questions
Is the output a real .xlsx file or a renamed CSV?
It is a real Office Open XML workbook (.xlsx), not a CSV with a different extension. It opens directly in Microsoft Excel, Apple Numbers, Google Sheets and LibreOffice Calc, with typed cells, column widths and one or more worksheets.
What is the difference between KMZ to Excel and KMZ to CSV?
An .xlsx file keeps non-ASCII column headers, stores numbers as numeric cells and can split folders into several worksheets. CSV is plain text that every database and GIS tool can import, so it is more universal. If you need CSV, use the KMZ to CSV converter.
Will my attribute names be preserved?
Yes. Every ExtendedData field becomes a column headed with its original name, including names in Chinese, Indonesian and any other language with non-ASCII characters. Excel stores text as Unicode, so there is no mojibake and nothing to fix with import settings.
Can I keep longitude and latitude in one column?
Yes. Choose "WKT" under Coordinate columns before converting, and every geometry is written to a single WKT column, for example POINT (116.397 39.909) for a point. The default is two separate Longitude and Latitude columns.
How are nested folders handled?
By default the workbook gets one worksheet per top-level folder, and the Folder column holds the full path of nested folders, such as "Survey / Block A / Wells". If you would rather have everything in one list, choose the single sheet option; the Folder column is written there as well.
What about placemarks without coordinates?
They are kept. A placemark that has a name or attributes but no readable geometry is still written as a row, with empty Longitude and Latitude cells, so nothing from the file is lost. A note under the tool tells you how many such placemarks were found.
Is there a file size limit?
Files up to 20 MB are supported today. Everything is processed in your browser, so the speed depends on your device rather than on an upload, and a typical KMZ with a few thousand placemarks converts in a second or two.
Can I convert Excel back to KMZ?
Yes. Use the Excel to KML converter: pick the longitude and latitude columns of your spreadsheet and choose KMZ as the output format there.