Back to all posts

Convert Google My Maps to CSV or Excel

You export your Google My Maps as KML, then convert it to a spreadsheet here. The result opens straight in Excel and Google Sheets, with a row for every place.

Google My Maps has no single button that gives you the whole map as a spreadsheet. The dependable way to get a clean CSV is to export your map as KML first, then convert that KML below. It runs in your browser, so your data stays on your device.

How to convert My Maps to CSV (3 steps)

  1. Open your map: go to mymaps.google.com and open the map you want.
  2. Export to KML: click the three dots next to the map title, choose Export to KML/KMZ, tick “Export to a .KML file”, then Download.
  3. Convert it here: drop the KML into the converter below and download your CSV.

What you get in the spreadsheet

Each place becomes one row. You get columns for name, description, latitude, longitude and elevation where it is present, plus any extended data fields you added in My Maps. Lines and shapes produce a row per coordinate, so a drawn route spreads across several rows. Custom icons, colours and styling are visual only and are not carried into a CSV.

If your map is public

For a public or link-shared map you can skip the menu and download the KML directly. Take the mid value from your map’s URL and open:

https://www.google.com/maps/d/kml?mid=YOUR_MAP_ID&forcekml=1

The forcekml=1 part returns plain KML rather than a zipped KMZ, so you can drop it straight into the converter. This only works for maps that are public or shared by link.

What My Maps cannot do

It helps to know the limits before you build a large map. Google My Maps allows up to 10 layers per map and 2,000 features per layer, to a total of 10,000 features across a map. There is no bulk export across several maps and no single table export for the whole map, which is why the KML route above is the practical one.

Need a different format?

The same KML export converts to other formats too. For GPS devices and hiking apps use Google My Maps to GPX. For web mapping and GIS use Google My Maps to GeoJSON. For the full walkthrough of the export step, read the KML export guide.

Frequently Asked Questions

Does Google My Maps export to CSV directly?

Only per layer. In My Maps you can open a single layer's menu and choose Export data, then CSV, but there is no one-click CSV for a whole map. The reliable route for the full map is to export it as KML, then convert the KML to CSV here.

Will the CSV open in Excel?

Yes. A CSV is a plain spreadsheet file that opens in Excel, Google Sheets, Numbers and any data tool. There is no separate .xlsx step needed for most work.

What columns do I get?

Each place becomes a row with columns for name, description, latitude, longitude and elevation where present. Any extended data fields on a placemark become extra columns. Lines and shapes produce a row per coordinate.

Is my map uploaded anywhere?

No. The conversion runs entirely in your browser, so your KML file never leaves your device.

My map is public. Is there a shortcut?

Yes. For a public or link-shared map you can download the KML straight from https://www.google.com/maps/d/kml?mid=YOUR_MAP_ID&forcekml=1, replacing YOUR_MAP_ID with the mid value from your map's URL. Then drop that KML into the converter above.

Learn more

Convert Google My Maps to CSV or Excel - Free Online | Takeout Tools