Extract data from a KML file and convert it to CSV.
About KML to CSV
Google Earth, Google My Maps and many GPS apps export places as KML, an XML format that spreadsheets cannot open. This tool reads every Placemark in the file and writes a CSV with its name, description and coordinates, plus any custom fields stored in ExtendedData, so a map of shops, routes or field observations becomes a table you can filter and share.
Paste the KML, name the output file and download the CSV. Parsing is done by your browser's XML parser, so location data is never uploaded.
How to use KML to CSV step by step
Export or open the KML file, copy its content and paste it into the text area. Compressed .kmz files must be unzipped first.
Type the name of the CSV file.
Click "Convert and download CSV". One row is written per Placemark.
100% free and online: no payments, no software or extensions to install.
Privacy-first: processing happens in your browser, your data never leaves your device.
No sign-up: paste your data and get the result in one click.
Fast and reliable: handle small or large files in seconds, ready for Excel and other tools.
Common use cases
Turn a Google My Maps layer of customers or delivery points into a spreadsheet for route planning.
Export waypoints from a hiking or cycling GPS app to CSV for a report.
Extract the points of a KML published by a city council (bike stations, pharmacies, schools) for analysis.
Move places from Google Earth into a database or a CRM that imports CSV.
Limits and tips
Coordinates are exported as the raw KML text in the order longitude,latitude,altitude, all in one quoted column. Split it in your spreadsheet if you need separate columns.
Lines and polygons have many coordinates: they are written as a single space-separated string in the coordinates column.
Custom attributes from ExtendedData (both Data/value pairs and SchemaData SimpleData) become extra columns named after their name attribute.
Placemarks inside folders and nested documents are all found; styles, icons and colours are not exported.
Frequently asked questions
What is a KML file?
KML (Keyhole Markup Language) is an XML format created for Google Earth to describe geographic features: points, lines, polygons, names, descriptions and styles. A KMZ file is the same content compressed in a ZIP archive. Google Maps, Google Earth, QGIS and many GPS tools read and write it.
Why are latitude and longitude in one column?
KML stores coordinates as a single string in the order longitude,latitude,altitude. The tool keeps that string intact so nothing is lost for lines and polygons. For points, use Text to Columns in Excel with a comma separator to split it into three columns.
Can I convert a KMZ file?
Not directly. Rename the .kmz to .zip, extract it and open the doc.kml inside; paste that content into the tool. The images and icons bundled in the KMZ are not needed for the CSV.
What is the difference between KML and GeoJSON?
Both describe geographic features. KML is XML-based, includes styling and is native to Google Earth. GeoJSON is JSON-based, has no styling and is the standard for web maps such as Leaflet and Mapbox. This site can also convert GeoJSON to CSV and CSV to both formats.
Is the KML uploaded?
No. The file is parsed with the DOMParser in your browser and the CSV is created locally.
Related tools
Other free utilities you may find useful
CSV to KML — Convert CSV coordinates into a KML file for maps.
Excel to CSV — Convert an Excel workbook (.xlsx, .xls, .ods) to UTF-8 CSV, choosing the sheet and the delimiter (comma, semicolon or tab).
Fixed-Width to CSV — Transform fixed-width text into a well-structured CSV file.