See all your Google Contacts on a Google Map

Create a Map of your Google Contacts

If you have been using Google Contacts (or any other address book*) to store the postal addresses of your friends and colleagues, you can easily create an online Google Map with all these address or even view them inside Google Earth. Here are the steps:

1. Make a copy of this Google Sheet in your own Google Docs account.
2. From the Google Contacts menu in the sheet, choose Initialize and authorize the script  (see source code) to access your Google Contacts.
3. Next choose Generate KML under the same menu and the script will send a KML file to your email account.

Go to your mailbox and download the KML file to the desktop. You can double-click this file to directly open it inside Google Earth. You can click the pin /marker to read the full address and name of the contact.