5 Free☝️ Google Sheets Address Book Templates

Do you ever find yourself frantically looking for an important phone number or address? Many of us have experienced this, and it can be quite a hassle searching for the information over numerous possible locations.

It can be easy to lose such information amongst our various notes and contact lists. Is it written down? Is it on the phone? Is it on the computer? You search each place you can possibly think of, growing more frustrated the longer you can’t find it.

Not to worry! There is a solution!

In this article, we will introduce you to the five most popular address book templates you can use on Google Sheets—and also show you how to make a personalized template yourself.

What Is a Google Sheets Address Book Template?

Address Book Template

A Google Sheets address book template is an easy-to-use spreadsheet that you can use to keep important information about addresses, contact details, and the like, all in one place. It usually consists of a table with various fields that you can fill in or delete as needed, allowing you to create your own address list. 

This template will ensure that all the contact information and addresses in your list are in the right order so you can locate them quickly when needed.

Why Use an Address Book Template for Google Sheets?

Let’s take a look at some valuable uses of address book templates:

  • Personal needs: Keep track of important contact details for the people you know, such as relatives, friends, and acquaintances.
  • Work needs: Maintain a list of the addresses and contact details of your colleagues and employers/employees so you can contact them easily.

What Are the Benefits of Using a Google Sheets Address Book Template?

In this section, we will take a closer look at the benefits of using an address book template:

  • Save time: By entering important contact information into one template, you don’t have to search through numerous sources for information. 
  • Organize personal data: Manage all your contacts in one spreadsheet. When needed, you can always edit or change the information to keep it up to date.
  • Protect personal data: Use a password-protected template to ensure the confidentiality of personal information such as emails and phone numbers.

What Should a Google Sheets Address Book Template Include?

Let’s explore the type of information a great address book template will include:

  • Name: Start with the name of the individual or company.
  • Work/cell/home number: Include the phone number(s) for your contact.
  • Address: Provide the street address.
  • City/State/Zip: Complete the address with these details.
  • Email: Don’t forget to include an email address as well.
  • Birthday: If desired, you may insert special information like a birthday.
  • Note: Whatever other notes you find pertinent, you can add them here.

5 of the Best Google Sheets Address Book Templates

Below you will find five address book templates available in Google Sheets. Take a look at each and see which one would work best for you.

Printable Address Book Template

Printable address book template

The Printable Address Book Template is a classic, convenient style of address book design.

The template itself is rather extensive and contains a variety of fields that can be filled in according to your needs. It includes details such as name, street address, city, state, zip code, home phone, work phone, cell phone, and email address.

If you would like to give this template a try, check out the link below. You can either fill it in on the computer or print it out and manually fill in each piece of information.

Note: To print the Printable Address Book Template, go to the File menu, select Print, click Next, and again select Print.

Contact List Template

Contact List Template

The Contact List Template is designed to help you keep all of your contact information together and manage it easily in one place. 

In this template, you will find nine different fields: last name, first name, home phone, work phone, cell phone, fax, birthday, URL, and notes. While the document is quite extensive, the format of the table is simple and easy to use. 

Simply enter the contact information for each individual in the appropriate columns, and you’re ready to go. You can customize the template by selecting a different font, style, color, etc.

Phone Directory Template

Phone Directory template

The Phone Directory Template is created to make it easy for the user to store contact information. It’s a great template to use in the office to consolidate business contacts.

The table is structured in a clear and concise manner, with two columns: the name and the number. There is no limit to how many contacts you can add here.

Download the template by clicking on the link below. Add as much data as you need, and if you want to customize the template, you can modify it by changing the color scheme and/or adding additional columns and rows.

Business Address Book Template

Business address book template

The Business Address Book Template is a great tool for people who want to organize and keep track of their contacts at work.

As you can see from the screenshot above, the template has multiple sections that will serve to store information about each company and your contact person for that company. There are five fields here: the name of the company, contact name, address, phone number, and email address.

Fill in the information as needed, and feel free to update the template to include extra details, such as company website. As with any template, you can customize the fonts and colors to fit your preferences. Google Sheets offers a number of tools to make this easy.

Address Book Template

Address Book Template

The Address Book Template provides another simple, easy-to-use method of organizing your contacts through Google Sheets.

This document is split into eleven different fields, including name, work, cell, home, email, birthday, address, city, state, zip, and note. With this template, you will be able to provide complete details about an individual.

We recommend the Address Book Template because of its comprehensive style. You can easily change the format of the spreadsheet, remove unnecessary columns and add new fields to the spreadsheet.

How to Make a Google Sheets Address Book Template

If you want to learn how to create your own template from scratch, follow the step-by-step guide below:

Step 1. Start by entering the header for your template. Simply select a blank cell and type the title.

Step 2. If the header extends over several cells, merge them together. To do this, select the cells, click the Merge icon, and choose the Merge all option.

The Merge all option

Step 3. Add content to your template by entering text into blank cells, labeling each item you want to include in your address book (such as name, address, phone number, email).

The data

Step 4. Now let’s customize the content. In order to format the text, select the text and use the toolbar menu to change the type of font, size, color, and alignment as you like.

The toolbar menu

Step 5. To add borders to the sections of your template, select the group of cells that you want to add a border to, press the Border icon, and choose the color, style, and type of border you want to add.

The Border icon

Step 6. To change the color scheme of your template, select the content, go to the Format menu, click on the Alternating colors option, and choose the style you like.  

Alternating colors

Step 7. Finally, go to the View tab, click Show, and select the Gridlines option to turn off gridlines (they are on by default).


Your result should look something like this:

Address Book Template

Address Book Templates in Google Sheets: FAQ

This section covers some frequently asked questions regarding this topic that you may find useful. Check them out to learn more!

How do I create an address book in Google Sheets?

To create an address book in Google Sheets, start by making a header and adding fields you need to fill out with contact information. Once you’ve done that, modify the font type, size, color, and alignment to personalize the template. You can also add borders and change the color scheme of the template. Finally, remove gridlines if desired.  

Does Google Sheets have an address book?

There is actually no built-in template for address books in Google Sheets at this time. We recommend using the ones suggested in this article.

How do I create a contact sheet in Google Sheets?

To create a contact sheet in Google Sheets, start by creating two columns. Use the first column for contact name and the second column for contact number. Customize your content by changing fonts, styles, colors, borders, and headings.

Can you make a mailing list from Google Sheets?

To make a mailing list from Google Sheets, open a Google Sheets document, go to the Extension tab, select Add-ons, and click the Get add-ons option.

The Get add-ons option

Next, enter Mail Merge in the Search box, click on your preferred app, and select Install.

Mail Merge

Click Continue and choose an account to pull address information from.

The Continue tab

Finally, click Allow and select Add emails myself.

Add emails myself

More Google Sheets Tutorials
More Microsoft Excel Tutorials
Share This Post
Daniel Smith
Daniel Smith
Daniel Smith is automation consultant with a passion for technology, data, AI, and machine learning.