Back to all posts

How to Export Google My Maps to Excel or CSV

The quickest route is to paste your My Maps link into the app and export a spreadsheet, which works for maps that are public or shared by link. If your map is private you export it as KML, then convert that KML to CSV for Excel or Google Sheets. Guide covers both routes, the columns you get, and the limits to know.

July 5, 2026

•

7 min read

You have a Google My Maps full of places, and you want it in a spreadsheet. There are two ways to get there. The quickest is to paste your My Maps link into the app, which imports the map and lets you export a spreadsheet in one step. That route works for maps that are public or shared by link. If your map is private, you export it as KML and convert that KML to CSV, which opens straight in Excel and Google Sheets. This guide walks both routes and is honest about the few things My Maps will not do.

Quickest route: paste your My Maps link

If your map is public or shared by link, you do not need to export anything first. Paste your My Maps link into the app and it can import supported point features, ready to export as a spreadsheet in CSV or Excel. This route is for places represented as points; do not rely on it to turn drawn lines or polygons into representative places.

A private map has no public link for the app to read. If yours is private, use the export route below.

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 for a private map the practical path to a spreadsheet is KML first, then a quick conversion to CSV. For a public map, the paste route above skips even that.

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.

If your map is private: export KML, then convert

If your map is private, or you would rather work from a file, export the map as KML and convert it to CSV. Here is the full flow.

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

The browser KML converter writes one CSV row per feature. For point features, that row can include:

  • Name of the place
  • Description or notes you added
  • Latitude and longitude
  • A coordinate pair, where the feature provides one

For a drawn line or polygon, the browser converter uses its first coordinate as the representative location for that feature. It does not promise elevation, every coordinate, or every custom My Maps field. 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, the quickest option is the paste route above, which needs no file at all. If you want the KML itself, you can skip the menu and download it 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