Exporting Google Saved Places

I've made use of Google Saved Places for a while now. I have the standard ⭐ “Starred”, 🚩 “Want to go”, and ❤ “Favorites” lists as well as some specific to cities. Saved places is really convenient when you're deciding where to go. My want to go list helps me remember the places I want to try and the favorites list often helps me find a place if I can't quite remember the name of it.

It's not all rosy though&mldr;when searching for anything in Google Maps it inexplicably doesn't show you if the places returned are in any of your lists. They also recently made the interface better for adding places to multiple lists, but you can't search your places by city let alone type (say coffee shops I love). This could be accomplished by having many lists, however I'm not looking to manually manage a growing list of lists.

What to do about it

What I really want is a list of places with their name, address, and general categories such as restaurant or coffee shop. Then I can tag those places with things like starred, favorite, want to go, etc.

Once I have that, I will be able to search my places by location, tag, and/or category. I'll want to be able to see them on a map similarly to how you can navigate around a city in Google Maps and see your saved places.

I'm going to start with all of my data from Google Saved Places and then add the info I want. Since I don't plan to stop using the Google Saved Places just yet, I'll need to be able to run the import multiple times. I'll make a cli to help with importing the data.

Getting the data

There doesn't seem to be an API to access your saved places. I had to resort to using Google Takeout, which if you haven't used before is quite interesting to see everything Google knows about you.

Getting the data I wanted out of Takeout was a bit of trial and error. There are two options for Maps data as seen below, Maps and Maps (your places). Maps (your places) includes lists that aren't the starred list. Apparently, Google treats starred separately. I'm guessing this is because historically starred was the only option and was called saved. Another fun fact is that those starred places also show up at Google Bookmarks.

If you only want your starred places from Maps you'll want to select “All Maps data included” and select only “My labeled places”. Running the export with the two maps options will get you a link to download a .zip file. Once extracted, you'll have a variety of folders. The important files are Saved Places.json and *.csv.

The Saved Places file will have your starred list in GeoJSON format. This format provides a fair amount of info like place name, location, and general categories. The csv files are a lot less useful by themselves. For me, it was just place name and a URL. However, the URL didn't seem to be parsable so this data wasn't super useful. Still, I was able to get all of the place names that I had saved.

Enhance!

I want the name, address, and categories of my places. The geojson file has everything, but the csv files only provide a name. Enter the Google Places API 💥. This API let's you lookup place data from Google, including all of the fields I want (besides user defined tags).

Unfortunately, neither of the formats I exported from Google gave me the Place ID, which would make it easy to find a specific place. The json file gave me a place name and address though so it's fairly simple to do a Place Search using the name and address as the input. The csv files providing only the place name and obscure URL is a little more difficult.

I ended up scraping the URL that was included for a string that looked like a Place ID. This definitely isn't perfect&mldr;especially since I only look for one of at least two possible formats, but it seemed to work for my data.

Next steps

So, I was able to get my saved places out of Google and tag them with the list they were on. I'm pretty much at the exact point I was at with Google Places minus the Google Maps integration. 😒

I want to build up an interface to add more tags easily. I also need to build the search and visualization aspects for discovering my places.

I'd also like to set up the ability to post this info to my site using micropub, but that presumes I have micropub set up here at all.

The code I used to parse and save my data is on GitHub. It's a cli called neptune. At this time, it let's you import and tag places and it will export each place to a json file in a folder.