Convert KML to XLSX

Turn KML 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 KML files on the dialor turn it to pick what to do

Every placemark as a row in a sheet.One sheet, one row per feature, with the shape as text and each attribute in its own column.

  1. What you get

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

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

  2. What changes on the way

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

    A feature without a geometry keeps its row, and its WKT cell is empty. A shape longer than the 32,767 characters a cell holds also leaves its WKT cell empty, and the conversion gives a warning.

    If the file already has a column named WKT, it is renamed WKT_1, so the shape column keeps its name.

  3. Several layers and big maps

    When the KML has several layers, they are joined into one sheet. A layer column names the layer each feature came from.

    A map of more than 1,048,575 features fails with resource_limit. For more on the formats, see every KML conversion or every XLSX conversion.

KML and XLSX.What each format is.

The formats

From · KML

KML

Placemarks, paths and polygons for Google Earth.

Extensions
.kml
MIME type
application/vnd.google-earth.kml+xml
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 KML to XLSX conversion through the API, for your app or your agent.

terminal
$ cv convert report.kml report.xlsx
$ cv convert report.kml report.xlsx

Questions.What people ask about KML to XLSX.

01OF 04

It goes in the first column, named WKT, as WKT text. The other columns hold the attributes.

Yes. Numbers, dates and true and false values are written as typed cells. Times with a time zone are written in UTC.

Its row is kept and its WKT cell is empty. The attributes are still written.

The map has more than 1,048,575 features. That is more rows than the sheet can take, so the conversion stops.

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