Back to all posts

How to Export Google My Maps to Excel or CSV

You export your Google My Maps as KML, then convert it to CSV for Excel or Google Sheets. Step-by-step guide covering the columns you get, the public-map shortcut, and the limits to know.

July 5, 2026

•

6 min read

You have a Google My Maps full of places, and you want it in a spreadsheet. Google My Maps has no single button that hands you the whole map as an Excel file, but there is a dependable route: export the map as KML, then convert that KML to CSV. A CSV opens straight in Excel and Google Sheets, so this covers both. This guide walks each step and is honest about the few things My Maps will not do.

Why there is no direct Excel export

Google My Maps is built for making maps, not for spreadsheets. It can export a single layer to CSV from that layer's own menu, but it has no one-click export for the whole map as a table. Its full-map export formats are KML and KMZ, the geographic formats used across Google Earth and the wider mapping world. So the practical path to a spreadsheet is KML first, then a quick conversion to CSV.

If you are exporting starred places or a saved list from the regular Google Maps app rather than a custom My Map, that is a different process. See the Google Maps saved places to Excel guide instead.

Step-by-step: My Maps to a spreadsheet

1. Open your map

Go to mymaps.google.com and open the map you want. Sign in if you are prompted.

2. Open the export menu

Click the three vertical dots next to the map title in the left panel. This sits near the top of the layer list, beside the map name.

3. Export to KML

Choose Export to KML/KMZ. In the dialog, tick Export to a .KML file instead of .KMZ file, then click Download. You now have a plain KML file named after your map.

You can also export one layer at a time. Click the three dots next to a specific layer, choose Export data, and you can pick KML or CSV there. That per-layer CSV is fine for a single layer, but for the whole map the KML route below is cleaner.

4. Convert the KML to CSV

Open the Google My Maps to CSV converter, drop in your KML file, and download the CSV. It runs entirely in your browser, so your map data never leaves your device. Open the file in Excel, Google Sheets or Numbers and you have your places as rows.

What columns you get

Each place in your map becomes one row in the spreadsheet. You get:

  • Name of the place
  • Description or notes you added
  • Latitude and longitude
  • Elevation, where it is present
  • Extended data columns for any custom fields you added in My Maps

Lines and shapes work a little differently. A drawn route or polygon produces a row for each coordinate along it, so a single route can spread across many rows. Custom icons, colours and styling are visual only and do not appear in a CSV, since a spreadsheet holds data rather than appearance.

Shortcut for public maps

If your map is public or shared by link, you can skip the menu and download the KML straight from a URL. Take the mid value from your map's web address 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 feed it directly into the converter. This only works for maps that are public or link-shared, not for private maps.

The limits worth knowing

Before you build a large map, it helps to know where My Maps stops:

  • 10 layers per map. Split larger projects across separate maps.
  • 2,000 features per layer, to a total of 10,000 features per map. Very large datasets need to be broken up.
  • No bulk export. You export one map at a time. There is no way to pull several maps at once.
  • No whole-map table export. The full map exports as KML or KMZ, not as a single spreadsheet, which is the reason for the KML then CSV route.

These are Google's own documented limits, not tool limits, so they apply however you export.

Frequently Asked Questions

Free Tools

Already have your KML file? Use our free browser-based tools:

See Other Guides

How to Export Google My Maps to Excel or CSV | Takeout Tools