Skip to content

Convert CSV to KMZ

One placemark per row, compressed for Google Earth and phones. Free, and the file never leaves your browser.

or drop CSV here

How the conversion works

  1. 1

    Choose a .csv file, drop it on the page, or paste the table. Comma, semicolon and tab delimiters are all recognised.

  2. 2

    The page finds the coordinate columns by their name: latitude, lat or y for one, longitude, lon, lng or x for the other. A wkt column works too, for lines and polygons. A name column becomes the placemark name. The KML is then zipped as doc.kml.

  3. 3

    Download the .kmz. Open it in Google Earth, on a phone, or in QGIS through Add Vector Layer.

How each column is used

The names are matched after lowercasing and stripping spaces and underscores, so Latitude, LAT and lat_dd all work.

Column names recognisedWhere it goes in the KMZ
latitude, lat, y, northingThe second number of the Point coordinates. Decimal degrees, WGS 84. A decimal comma is accepted.
longitude, lon, lng, long, x, eastingThe first number of the Point coordinates.
name, title, label, idThe placemark name. Rows without one are named by their row number.
description, desc, notes, commentThe placemark description.
wkt, geometry, geom, the_geomWell-known text. POINT, LINESTRING, POLYGON and the MULTI types become the matching KML geometry when there is no latitude and longitude pair.
Everything elseOne ExtendedData field per column, shown in the Google Earth balloon.

What it does not do

  • Coordinates must be latitude and longitude in degrees. A CSV in UTM or Lambert metres has to be converted first; the coordinate converter on this site does that.
  • No icons or colours. Set them in Google Earth.
  • When most values in the latitude column are beyond 90 degrees, the two columns are swapped and a notice says so.
  • Files up to 50 MB. Every row with a readable coordinate pair becomes a placemark; the rows without one are counted and skipped.

Questions people ask

Does my CSV get uploaded?
No. The KMZ is built in your browser tab. Nothing is sent.
KMZ or KML, which should I choose?
KMZ is the same KML zipped: smaller, and Google Earth on a phone opens it more reliably. Choose KML when you want to read or edit the text.
Which column names does it recognise?
latitude, lat, y or northing for the latitude; longitude, lon, lng, long, x or easting for the longitude; name, title, label or id for the name; description, desc, notes or comment for the description. Case and underscores do not matter.
My coordinates are in UTM. Will it work?
No, KML only carries degrees. Convert the table with the coordinate converter on this site first, then come back.
Can it make lines or polygons from a CSV?
Yes, from a wkt column holding LINESTRING or POLYGON text. A CSV where each row is a vertex of one line is not supported: group it into WKT first, or load it in QGIS and use Points to Path.

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.