Converting JSON to CSV to plan a friend’s honeymoon

A few weeks ago my colleague said during a Product “Show and Tell” that a handy use for data.world is converting JSON to CSV. Little did I know that this tip would prove useful to me and to friends planning their honeymoon…

Short of looking at every square inch of map, I’ve explored every pixel of the Google Maps Product and am a huge fanboy. I’m part of the Google Maps community and a couple highlights are IDing a new street in Austin — the West Street Extension connecting Cesar Chavez and Second Street adjacent to the recently opened Austin Central Library — and correcting a bizarre issue that incorrectly placed the geolocation pin for the data.world office 1.2 miles North (Corner of Mopac and Steck) of the location of our office address (Mopac and Far West). While I’m proud of the first accomplishment as a good citizen in the Google Maps community, the second accomplishment resolved a major business challenge where visitors to our office would routinely arrive late due to this geo error. But I digress…

Last night I was having dinner with a friend who will be visiting Peru for her honeymoon. She asked me for recommendations since I’ve been traveling there to visit family throughout my life and since I recently visited so that my wife could meet my grandmother. One of my favorite features of Google Maps is Starred Locations. Since I was just there I had up-to-date Starred Locations to help them plan celebratory dinners, perk up with great coffee, find tasty ice cream parlors, shop unique boutiques, etc. I definitely didn’t want to spend my Sunday morning typing out notes for something I’d already organized in a map, which I think is the best way to organize this data.

Unfortunately, I learned that Google Maps Starred Locations cannot be shared but another Google product called My Maps allows sharing. Sounds great, but My Maps is distinct from Google Maps and Starred Locations are only available in Google Maps. Searching the web showed that others had unsuccessfully grappled with this problem. What follows is a step-by-step guide of how I got my Starred Locations from Google Maps into Google’s My Maps by using data.world to convert a JSON file (how my data is accessible from Google Maps) into a CSV (that Google’s My Maps can ingest).

• Download Starred Locations data from Google Maps using Google Takeout. Downloaded data will be in GeoJSON format.
• Go to data.world (create a free account if you’re new to the site) and create a Private Dataset to upload the GeoJSON file you downloaded from Google Maps.
• Scroll down to see a preview of the file you just uploaded as well as some metadata and then click the Explore button on the file card to go to the Workspace where in addition to previewing the data and metadata you can bring the data into tools including Python, Tableau, Excel (hint), and other tools as well as query the data with SQL (hint).

• Click the < > Query hyperlink at the top right of the screen to enter the query tool. You’ll be presented a pre-populated SQL query that will Select all data in the GeoJSON file that you just added to the private dataset. You do not need to change this query.
• Click the Run Query button in the top right of the screen to reproduce the contents of the Google Maps data, which when you click the the Download button can be downloaded as a CSV, which My Maps can handle

• Open the CSV you just downloaded from data.world and Find and Replace over column A (location) to replace “POINT (“ and “)” with nothing (effectively deleting the text) and re-save your file. You can also delete any locations that you do not need to share.
• Go to Google’s My Maps and Add a Layer. Below the newly added Layer will appear an Import hyperlink which you should you click. Find and add the CSV you downloaded from data.world and further modified in Excel or Google Sheets.
• The last two steps are to choose the columns My Maps needs to position your Placemarks. The first of these is location and the second is title.

And with that, my friends have the map I recently used on my trip to Peru and I got away with a cheap wedding gift. Just kidding, we got them a nice wedding gift as well.

I hope this helps you better use and share your Google Maps with friends!

Want to make your data projects easier/faster/better? Streamline your data teamwork with our Modern Data Project Checklist!