Back to all posts

Convert Google My Maps to CSV or Excel

You paste your My Maps link into the app for a one-step import, or export the map as KML and convert it to a spreadsheet here. Either way 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 quickest route is to paste your My Maps link into the app, which imports the map for you when it is public or shared by link. If your map is private, or you would rather work from a file, export it as KML and convert that KML below. The converter runs in your browser, so your data stays on your device.

Faster: paste your My Maps link

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 the quickest option is to paste the map link into the app, as above. If you want the KML file itself you can skip the menu and download it 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. The quickest route is to paste your My Maps link into the app, which imports the map for you and lets you export CSV or Excel. This works for maps that are public or shared by link. If you would rather work from a file, 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. Private maps have no public link, so use the Export to KML steps for those.

Learn more

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