Turns the placemarks in a KML into a table. Every field you typed into Google My Maps becomes a column, because those live in ExtendedData rather than in the description — which is what most converters miss.
Getting your My Maps data back out
<Data> entries under each placemark. This conversion reads them and rebuilds the columns.
The union of every field seen across the file becomes the header, so placemarks with different fields still line up. The folder each placemark sits in becomes a column too, so you can filter by layer.
Placemark or coordinate rows
Descriptions containing HTML
Other names for this
Also searched as “kml to excel”, “google my maps to spreadsheet”.
Questions
- My spreadsheet columns are missing.
- They are in ExtendedData, which this tool reads. If they are still missing, the map was built by typing into descriptions rather than by importing data.
- Can I drop a .kmz?
- Yes — the archive is opened automatically.
- Why is there HTML in my description column?
- Google My Maps writes descriptions as HTML. It is preserved rather than stripped, because stripping would guess at what you wanted.
- Is my file uploaded?
- No. Everything runs in this tab. That matters more here than almost anywhere else on the site — a calendar is your movements, an address book is other people’s personal data, and a GPS track is where you live and where you run. None of it is sent anywhere.