Office and Data, free, by Pivotal Labs
Get your saved places out of Google Maps
Drop in your Google Takeout files and get your saved places and want to go lists as CSV, Excel or GeoJSON. It runs in your browser, so a map of everywhere you have been stays with you.
Loading Google Maps List Exporter...
What Google Maps List Exporter does
Turn your saved places and Want-to-go lists into a clean spreadsheet. Drop your Google Takeout files and get CSV, Excel or GeoJSON, nothing is uploaded anywhere.
Doing this job well
Saved places accumulate for years and then turn out to be difficult to get at. The lists are easy to add to, easy to browse on a phone, and awkward to do anything else with: you cannot sort them, filter them, share them as a table or plot them anywhere other than where they already are.
Google Takeout is the way out, and it is worth knowing about for more than this. It is the export mechanism that exists because of data protection law, specifically the right to data portability, which requires that data you provided is available in a structured, commonly used, machine readable format. Takeout is Google's implementation of that right, and most large services have an equivalent whether or not it is advertised.
What comes out is not friendly. Takeout produces a large archive of files in formats chosen for completeness rather than for use, and saved places in particular arrive in a shape that is technically correct and practically unreadable. Turning it into a spreadsheet is the step between having your data and being able to use it.
The formats are worth choosing between rather than defaulting. CSV or Excel for anything you want to sort, filter or annotate, which covers most planning. GeoJSON if the destination is a map, because it keeps the coordinates as coordinates rather than as two columns of numbers that something later has to interpret.
The thing to be aware of before this leaves your machine is what a list of saved places actually is. It is a record of where you have been and where you intend to go, often including home, work, and the places you visit regularly. That is among the more sensitive things a person holds about themselves, which is precisely why an export tool for it should not be a website that receives the file.
So this one does not. The archive is read in the page, the conversion happens locally, and nothing is transmitted. Which for a file whose contents are a map of your life is the only arrangement that makes sense.
Common questions
Are my saved places uploaded?
No. A list of saved places is a record of where you live, work and go regularly, which is exactly why an export tool for it should not receive the file. It runs locally.
Where do I get the file?
Google Takeout, which is Google's implementation of the right to data portability. Select Maps and download the archive.
Which format should I choose?
CSV or Excel to sort, filter and annotate. GeoJSON if it is going onto a map, because it keeps coordinates as coordinates.
Why is the Takeout file so hard to read?
It is built for completeness rather than for use. Converting it is the step between having your data and being able to do anything with it.
Does this work for other Google data?
This one handles saved places and want to go lists. Takeout itself covers far more, and is worth knowing about generally.
Related applets
Built by Pivotal Labs
We build software, and this is a small piece of it.
Pivotal Labs is a software development and product management team. The applets on this site are the offcuts, the small things we build for ourselves and give away. The work we are paid for looks rather different.
See what Labs buildsFurther reading

Scaled CS: what it actually means and when you need it

Defining Success Before the Sale: The CS Conversation That Usually Starts Too Late

Expansion revenue is a Customer Success responsibility. Here's why most teams aren't ready for it.

The CS Leader's First 90 Days: Why Fixing Things Too Fast Is the Fastest Way to Get Things Wrong

The CS Tech Stack: What to Buy, and in What Order

