View All Of Your Google Contacts On A Map

View All Of Your Google Contacts On A Map

If you keep all of your contacts in Google, you might be interested in seeing a map showing their locations. Tech weblog Digital Inspiration provides a script to connect to your Google account and display a map of your contacts in Google Maps or Google Earth.

You’ll need to copy this spreadsheet to your Google Drive account. Inside the spreadsheet will be a custom menu labelled as Google Contacts. Click on that, choose Initialize, and authorise the script to run. When that is done click again on the Google Contacts menu and choose Generate KML file. The file will be generated and automatically emailed to your Gmail address.

If you have Google Earth installed you can open the file on your computer to view the map. If you’d prefer to use online Google Maps you’ll need to upload the file and then copy the link into Google Maps. (I used Dropbox to store the file.)

You’ll see a standard Google map with all of your contacts that have an address listed on their contact entry. It’s a little gimmicky for most of us, but if you have a list of customers you need to visit having such a list already in Google Maps may cut down on your travel preparations.

See All Your Google Contacts on a Google Map [Digital Inspiration]


  • I keep getting frustrated with such Google add-ins with the “Our systems have detected unusual traffic from your computer network.” whenever it’s run. I suspect it’s another side-effect of Google’s international domain redirection mess

  • Did it, dropped the .kml file into my public dropbox folder, copied that link and… “Could not be displayed because it is not a valid KML or KMZ file”. Well that fell down flat. Not sure what I’m doing wrong there…

Show more comments

Log in to comment on this story!