Why convert KMZ to CSV?
A spreadsheet of placemark coordinates is easier to bulk-edit, import into a CRM or mapping API, or use in calculations than raw KMZ XML. Common reasons include editing location names in Google Sheets or feeding latitude and longitude data to a web service that expects a .csv file.
How to convert KMZ to CSV
QGIS OPEN-SOURCE
Add the .kmz, right-click the point layer, and choose Export > Save Features As with format set to Comma Separated Value (CSV) and geometry as AS_XY.
ogr2ogr (GDAL) OPEN-SOURCE
Run ogr2ogr -f CSV out.csv in.kmz -lco GEOMETRY=AS_XY to write one CSV per layer with longitude and latitude as separate columns.
About these formats
.KMZ
Keyhole Markup Language Zipped (Google Earth)
A KMZ file is a ZIP-compressed Google Earth map - it holds placemarks, routes, polygons, image overlays and sometimes 3D models in one portable package. Open it with the free Google Earth…
Open .KMZ details →
.CSV
Comma-Separated Values
A CSV file stores tabular data as plain text - one row per line, values separated by commas (or semicolons in European locales). Any spreadsheet opens it: Excel, Google Sheets, LibreOffice…
Open .CSV details →Quality & what to watch
- Only point features (placemarks) convert cleanly; a line or polygon has many vertices that do not map to a single row without losing shape.
- GPS Visualizer outputs columns including
name,longitude,latitude, and sometimesdescription. - For boundary polygons or route lines, export to GeoJSON or Shapefile instead of CSV.
Frequently asked questions
What columns does the CSV contain?
name, longitude, latitude, and description. QGIS lets you choose which attribute fields to include before exporting.
