Convert KMZ to XLSX

Turn KMZ files into XLSX. A workbook with one sheet named after the file, cut to 31 characters, and one row for each feature: its shape as WKT in a first column named WKT, then every attribute as a column, with numbers, dates and true and false as typed cells.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop KMZ files on the dialor turn it to pick what to do

A spreadsheet with one row per map feature.Each feature's shape goes in a WKT column, and its attributes follow as columns.

  1. What you get

    A workbook with one sheet, named after the file and cut to 31 characters. Each feature in the KMZ becomes one row.

    The first column is named WKT and holds the feature's shape as WKT. Every attribute then gets its own column. Numbers, dates and true and false values are written as typed cells. Coordinates are in WGS 84 longitude and latitude.

  2. What changes

    Lists and nested values become JSON text. Times with a time zone are written in UTC.

    A feature with no geometry keeps its row, and its WKT cell is empty. If the file already has a column named WKT, that column is renamed WKT_1 so the shape column keeps the name WKT.

    A KMZ with several layers is joined into one sheet. A layer column names the layer each feature came from.

  3. Limits

    A cell holds at most 32,767 characters. If a shape is longer than that, its cell is left empty and a warning is given.

    A map of more than 1,048,575 features fails with resource_limit. To work with other workbooks after the conversion, see merge XLSX.

KMZ and XLSX.What each format is.

The formats

From · KMZ

KMZ

A zipped KML with its icons and overlays.

Extensions
.kmz
MIME type
application/vnd.google-earth.kmz
Kind
Text and data
To · XLSX

Excel Workbook

Excel's workbook format since 2007. Sheets, formulas, formats and charts in zipped XML.

Extensions
.xlsx
MIME type
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Kind
Documents

In your code.The same KMZ to XLSX conversion through the API, for your app or your agent.

terminal
$ cv convert report.kmz report.xlsx
$ cv convert report.kmz report.xlsx

Questions.What people ask about KMZ to XLSX.

01OF 04

It holds each feature's shape as WKT, in WGS 84 longitude and latitude. It is always the first column.

They keep their row in the sheet. Their WKT cell is empty.

The map has more than 1,048,575 features. The conversion stops with resource_limit at that size.

Yes. The layers are joined into one sheet, and a layer column shows which layer each feature came from.

More conversions.Other ways in and out of KMZ and XLSX.