Convert KML to CSV

Turn KML files into CSV. A CSV with one row for each feature: its shape as WKT in a first column named WKT, then every attribute as a column.

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

A table with one row per feature.Each placemark, path or polygon becomes a row, with its shape as text.

  1. What you get

    A single CSV file with one row for each feature in the KML. The first column is named WKT and holds the feature's shape as WKT. Every attribute of the feature follows as its own column.

    Coordinates are written in WGS 84 longitude and latitude.

  2. How features are handled

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

    Lists and nested values do not fit in a single cell as they are, so they become JSON text.

  3. Several layers

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

    If the file cannot be parsed, the conversion stops with input_corrupted. To go the other way, use CSV to KML.

KML and CSV.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 · CSV

CSV

Rows of comma-separated values. The plainest way to move a table between programs.

Extensions
.csv
MIME type
text/csv
Kind
Text and data

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

terminal
$ cv convert report.kml report.csv
$ cv convert report.kml report.csv

Questions.What people ask about KML to CSV.

01OF 04

It goes in the first column, named WKT, as WKT text. Features without a geometry have an empty cell there.

Coordinates are written in WGS 84 longitude and latitude.

The layers are joined into one CSV. The layer column tells you which layer each row came from.

The file could not be parsed. The conversion stops with input_corrupted when that happens.

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