KML to CSV Converter
Convert KML placemarks to CSV
Convert a KML file from Google Earth or Google My Maps into a CSV table. Each placemark becomes a row with its name, latitude, longitude, and description, so you can sort, filter, and analyse locations in a spreadsheet.
KML is XML underneath, which makes it awkward to read directly — a file with a few hundred placemarks is thousands of lines of nested tags. Converting to CSV is the fastest way to see what a map layer actually contains.
It is also the first step in editing a map: convert to CSV, fix names and attributes in a spreadsheet, then convert back to KML.
Extracted Fields:
How to Convert
- Export or download your .kml file from Google Earth or My Maps
- Upload the KML file here
- Review the extracted placemarks in the preview
- Download the CSV file
Features
- One row per placemark with name, latitude, and longitude
- Extracts description text into its own column
- Reads ExtendedData and SchemaData custom fields into their own columns
- Reads placemarks nested inside folders
- Preview the extracted table before downloading
- Proper CSV quoting for descriptions containing commas or newlines
- Runs entirely in your browser — no upload
Use Cases
- Analyse a set of Google Earth locations in a spreadsheet
- Audit what a shared map layer actually contains
- Edit placemark names and attributes before rebuilding the map
- Share location data with people who do not use Google Earth
- Move locations from Google Earth into another mapping tool
Frequently Asked Questions
What does each row contain?
One placemark: its name, its latitude and longitude, its description text, and any custom ExtendedData or SchemaData fields attached to it — so attributes added in Google Earth or exported from GIS software come through as real columns instead of being discarded.
Does it work with KMZ files?
KMZ is a zipped KML. Unzip it first and upload the .kml file inside.
Are placemarks inside folders included?
Yes. Google Earth files commonly group placemarks into folders, and those are read as well as top-level ones.
What happens to lines and polygons?
Placemark points convert cleanly. Paths and shapes carry full vertex lists that a single row cannot represent, so use GIS software when you need the complete geometry.
Can I convert the CSV back to KML?
Yes — edit the table in a spreadsheet and use the CSV to KML converter to rebuild the file.
Is my file uploaded?
No. The KML is parsed in your browser and its contents are not sent to the app server.