20 Printable Address Book Templates [100% FREE & Easy to Edit]

Many people are no longer keeping address books. Well, this is attributed to the emergence and growth of smartphones that allow people to store contacts seamlessly. However, there is a risk of relying solely on smartphones as they can be lost and all the information in them disappears.

Therefore, an old-fashioned address book is still practical and can act as an amazing backup plan for all your contacts. Just one address book is enough to back up all your important information.

Address Book Templates

Types of Address Books

The types of address books depend on the purpose. Here are some examples of address books:

• Business address book. Here is where you store important business contacts that you have. They can be of your business associates or important people in the line of your business. For example, if you attend a business expo, you can add important contact information to a business address book.
• Class contact list. This carries the list of people with whom you have attended the same school. Again, you can categorize depending on the school that you shared with your contact information because it is likely that you have had friends from different schools e.g. friends from high school, college, university, etc.
• Personal address book. A personal address book has the contact info of your close list of friends and family. These are the people that you can reach when in need.
• Personal & business address book This is an address book that includes the contact information of close friends, family, and business associates.
• Phone & address book this a type of address book that has the phone numbers and addresses of the people in it.

The types of address books are flexible and you can create a type depending on your needs.

Why Use an Address Book Template?

Address books are very useful in many scenarios. Whether you are using an address book for personal or business needs, you need to find an easy-to-use template. If you find the right one, then you will enjoy many benefits such as:

• You can easily search for information on an address book on your computer. All that you have to do is to press the search feature and input the name of the person that you are looking for and the address will pop up. It saves you time and reduces the effort used.
• Address book templates allow you to save multiple contacts on the same book. This means that you don’t have to open different pages for your contact lists. You can just have different templates compiled into one file.
• Address books ensure that technical failures don’t cause you to lose contact information. For example, if you just have your contact information kept in your phone, you can lose them in case the phone is destroyed. However, if you had backed up the contact on an address book, you won’t lose.
• It is convenient to keep address book files. You can reach your wanted contact information and paste their details when you want to call or send emails. 
• Address book templates allow you to make your contact information list fun. You can be creative with them and use different graphics, fonts, and color-coding to improve the appearance.

How to Create an Address Book in MS Excel?

You can create an address book using Microsoft Excel. Here is a step-by-step guide for creating an address book in Excel:

• Select cells that you want for your template
• Click on the “Insert” tab
• Open a dialog box by clicking on “Table”
• Tick the “My Table Has Headers”
• You can now create and sort columns using the arrow buttons on the table
• Type the category headers i.e. name, address, email, phone number, etc.
• Go to the “Design” tab and click on “Table Styles”
• Choose your desired style and color scheme for your table
• Preview your selection by moving the cursor over the table
• Start filling contact information on your table
• When you are done, save your file
• You can also print your contact information if you want a hard copy.

There is also an option of using templates from Microsoft Excel. You just have to click on the “File” tab and choose the templates that you can use.

Keeping an address book may seem old-fashioned but it has many benefits. Furthermore, it doesn’t cost anything yet it can save you from losing important contact information. Therefore, you should have an address book if you want to stay organized.