Skip to content
TerraLab

Convert KMZ to CSV

One row per placemark, every field as a column, straight from the archive. Free, and the file never leaves your browser.

or drop KMZ here

How the conversion works

  1. 1

    Choose a .kmz file or drop it on the page. Files up to 50 MB.

  2. 2

    The page unzips the archive in memory and reads every Placemark of the doc.kml. A Point becomes longitude and latitude columns. A LineString, Polygon or MultiGeometry becomes a WKT column, which QGIS reads as geometry.

  3. 3

    Download the CSV. It opens in Excel, Google Sheets, and in QGIS through Layer, Add Layer, Add Delimited Text Layer.

What the CSV contains

Columns that nothing filled are left out, so a plain point file comes out as four columns rather than ten.

ColumnWhat it holds
nameThe Placemark name.
descriptionThe Placemark description, HTML tags included, as one cell.
longitude, latitude, altitudeDecimal degrees, WGS 84, for a Point; altitude in metres when the KML carries one.
geometry_typePoint, LineString, Polygon, MultiPolygon or GeometryCollection.
wktWell-known text for anything that is not a single point. Choose this column as the geometry field when you load the CSV in QGIS.
folder, timestampThe Folder names above the Placemark joined with a slash, and the TimeStamp.
<field name>One column per ExtendedData field, named after the field.

What it does not do

  • Icons, styles and overlay images inside the KMZ are ignored. A CSV has no place for them.
  • NetworkLink elements are not followed.
  • Coordinates stay in WGS 84 (EPSG:4326). Reproject in QGIS if you need a projected system.
  • The wkt column of a detailed polygon can exceed the 32,767 characters Excel allows in a cell. QGIS and Google Sheets read it in full.

Questions people ask

Does my KMZ get uploaded?
No. The archive is unzipped and read by JavaScript in your browser tab. Open the network panel while you convert: no request carries the file.
How do I open the CSV in QGIS?
Layer, Add Layer, Add Delimited Text Layer. Pick the file, set the geometry definition to Point coordinates with longitude as X and latitude as Y, or to Well known text with the wkt column for lines and polygons. Geometry CRS is EPSG:4326.
Why are longitude and latitude empty on some rows?
Those placemarks are lines or polygons. Their geometry is in the wkt column. Only a Point has a single coordinate pair to put in two columns.
I only want the placemark names and coordinates.
Convert, open the CSV and delete the other columns. The name, longitude and latitude columns come first.
Does it read a Google My Maps export?
Yes. Export the map as KMZ, drop it here. Each My Maps layer is a folder, kept in the folder column.

Other free tools

Next, open it in QGIS

Every one of these files loads in QGIS in one dialog. Once the points or polygons sit on your imagery, the two TerraLab plugins take over: AI Segmentation detects the objects the file is missing, AI Edit renders a project on the map.

See AI SegmentationSee AI Edit