How to Export Google Maps Saved Places and Lists to CSV
To export Google Maps saved places, open Google Takeout, click Deselect all, tick Saved and start the export: each of your lists arrives as its own CSV, usually within minutes. There is no export button in the Maps app itself, and the CSV has names, notes and links but no coordinates, which is the part that breaks most imports.
This page covers the export step by step, what the file actually contains, why the coordinates are absent, and how to get the result into something that can do more than store a pin.
How do you export Google Maps saved places to CSV?
- Go to Google Takeout while signed in to the account holding the lists.
- Click Deselect all. The default is every Google product you have ever touched, and that export takes days to arrive.
- Scroll to Saved and tick it. This is the section that holds your Saved Places lists, and it is easy to miss because the name does not say Maps.
- If you also want the reviews you have left, tick Maps (your places) as well. That is a separate section and a different format.
- Choose a one-off export, pick a file type and size, and start it.
- Wait for the email. A Saved-only export is small and usually arrives in minutes rather than the days a full Takeout takes.
Inside the archive, each of your lists is a separate CSV, named after the list. Want to see one before committing to anything, open it in Excel, Numbers or Google Sheets, which all read it directly. If a spreadsheet is where you want the list to live, our Google Sheets restaurant tracker template gives it columns worth having.
What is in the Google Maps saved places CSV?
A Saved Places CSV has three columns: Title, Note and URL. That is the whole export.
| Column | What it holds | Useful? |
|---|---|---|
| Title | The place name as Google stored it | Yes |
| Note | Whatever you typed on the pin, usually empty | Yes, when you used it |
| URL | A Google Maps link to the place | Yes, and it is doing more work than it looks |
| Latitude / longitude | Not included | This is the problem |
| Address | Not included | Reconstructable from the URL, sometimes |
The missing coordinates are the reason most imports of this file fail or arrive half empty. A name and a note are not a location: "Bar Central" exists in forty cities. Anything that wants to put your list on a map has to work out where each place actually is.
How do you get coordinates for the exported places?
There are only two honest options, and they have very different failure modes.
| Method | How it works | When it fails |
|---|---|---|
| Recover from the URL | Reads the latitude and longitude already inside the Google Maps link | Cleanly: rows whose URL has no coordinates are flagged |
| Geocode the names | Asks a geocoding service where each place name is | Silently: some pins land in the wrong city, and bulk lookups can get rate-limited |
Recover coordinates from the URL. Google Maps links often carry the latitude and longitude inside them, so a parser can pull them straight out with no lookup and no guessing. When it works it is exact. When a particular URL does not carry them, it fails cleanly and you know which rows are affected.
Geocode the names. Take "Bar Central" and ask a geocoder where it is. This fills every row, and some of those rows will be wrong, in another city, silently. It also means firing hundreds of lookups at a geocoding service for one import, which is exactly the kind of thing that gets an app rate-limited or blocked.
We do the first and refuse the second. In Crumble, a row whose coordinates cannot be recovered from its URL is skipped and counted, and the preview tells you how many before you commit anything. A short accurate list beats a long list with pins in the wrong country.
Importing the file into Crumble
Once you have the CSV, the import is three screens: upload, preview, commit. Nothing is written until you press the last one.
- Open Import in Crumble and upload the CSV straight out of the Takeout archive. No renaming, no cleanup, no adding columns.
- The format is detected automatically. A Saved list becomes wishlist entries. A Google review, which carries a star rating, becomes a review with that rating.
- Read the preview. It shows what was found and, importantly, how many rows were skipped for want of coordinates.
- Commit. Places land on your map, and your wishlist behaves normally from there: an entry clears itself once you actually go and log the visit.
The limits, so nothing surprises you: 4 MB per file, 2000 rows parsed, 500 written per commit. Large libraries import in batches rather than failing. Accepted file types are CSV, JSON and GeoJSON, which covers both halves of Takeout.
What happens to your Google star ratings
If you import reviews rather than saves, the star rating comes with them, and we coarsen it to the nearest half star on the way in. That is deliberate and worth explaining, because it looks like a downgrade.
Crumble rates in tenth-of-a-star steps. A Google star is an integer out of five, chosen in a different context for a different purpose. Importing a 4 as a 4.0 would make it look like a considered 4.0 rather than a rounded one, and it would sit in your history indistinguishable from ratings you actually thought about. Half-star granularity keeps the imported history usable without letting it pretend to a precision it never had.
Reviews as well as saves
The Maps (your places) section of Takeout holds the reviews you have written, as GeoJSON rather than CSV. GeoJSON carries real geometry, so this export does not have the coordinate problem at all and imports cleanly.
Worth doing if you have been leaving Google reviews for years: it is the only copy of that writing you control, and Google can remove a review from public view without warning.
Why bother moving them at all
A Google list is a set of pins with no state. It cannot tell you whether you went, what you ordered, or whether it was any good, and it does not distinguish "somewhere I want to try" from "somewhere I go every month". After a few years it is a wall of markers you scroll past.
The upgrade is a record that separates the two: a wishlist that empties as you actually go, and a rating on the dish rather than on the restaurant. Our comparison of Google Maps lists alternatives covers the options, and how to keep track of restaurants covers the method whichever one you pick.
Coming from other apps as well, we have the same walkthrough for exporting Untappd check-ins and exporting your Vivino wine list.
Give your saved places somewhere to go
Crumble is free and imports the Takeout CSV as it comes. Your saved places land on a map as a restaurant wishlist that clears itself as you go, and every visit gets a rating on the dish, not just a pin.
Frequently asked questions
How do I export my Google Maps saved places?
Use Google Takeout. Sign in, click Deselect all, then tick the section called Saved, which is where Saved Places lists live. Start the export and wait for the email. Each list arrives as its own CSV with Title, Note and URL columns. If you also want the reviews you have written, tick Maps (your places) as well, which exports as GeoJSON.
Can I export Google Maps saved places to Excel or Google Sheets?
Yes. The Saved section of Takeout already gives you one CSV per list, and Excel, Numbers and Google Sheets all open CSV files directly. You get the Title, Note and URL columns. What you do not get is latitude and longitude, so the sheet cannot draw a map on its own.
Can I export Google Maps saved places from my phone?
Not from the Maps app, which has no export button. Google Takeout is a web page, so you can run it from a phone browser while signed in, then download the archive when the email arrives. Opening and importing the CSVs is easier on a computer, but it is not required.
Why does the Google Maps export have no coordinates?
Google does not include latitude and longitude in the Saved Places CSV. You get the place name, your note and a Maps URL. The coordinates are often recoverable from inside that URL, which is how a good importer places them without guessing. The alternative, geocoding each name, quietly puts some places in the wrong city.
Can you import Google Maps lists into another app?
Yes, if the app can read the CSV and recover coordinates from the Maps URL. In Crumble you upload the file from the Takeout archive as-is, and it detects the format: saved places become wishlist entries and Google reviews become reviews carrying their star rating. Rows with no recoverable coordinates are skipped and counted rather than guessed at.
How many places can I import at once?
In Crumble, files up to 4 MB, 2000 rows parsed per file and 500 written per commit, so a large library imports in a few passes instead of failing. Accepted formats are CSV, JSON and GeoJSON, which covers both the Saved lists and the Maps reviews halves of Takeout.
What happens to my Google star ratings when I import them?
They are coarsened to the nearest half star. Crumble rates in tenth-of-a-star steps, and an imported integer Google star is not a tenth-of-a-star judgement, so importing it at full precision would let it masquerade as one. Half stars keep the history usable without overstating what it is.
Is there a faster way than Takeout?
Third-party tools exist that read a shared list link or your logged-in Maps session and convert it to CSV, KML or GPX. They are quicker, and they involve handing your list data or your session to someone else. Takeout is slower, official, and the only route that does not require trusting a third party with access.