You may also realize that you have duplicate contacts in your address book that you can merge. Or maybe you realized that some of your contacts have new emails or phone numbers that need to be updated. Maybe you stored someone’s contact information three years ago but haven’t had a reason to message them since. Go through your address book at least once a year to review and delete contacts. That way, you’ll never lose your contacts, and you can access and update your address book from anywhere. Store your address book in a cloud, like OneDrive. Adding a notes section to your address book is also a great place to store work information-for example, if you met an interesting person at a networking event, you could take note of the company they work for. Taking notes can also help you remember how you know them. You can write “do not call after 6 PM” in your notes to reference if you later forget when they said not to call them. Taking notes on your contacts will allow you to store additional important information on them-for example, maybe your coworker has warned you not to call them after 6 PM. If the address book template you select doesn’t have a notes column, add one in. Or you can a new spreadsheet within the document for each contact category, for example, a tab for family members, a tab for college friends, and so on. When you use an address book template in Excel, you may want to consider color-coding your contacts based on how you know each-for example, you can make rows pink for friends and orange for coworkers. There are plenty of free address book templates out there that can quickly be customized. With a template, you won’t have to spend time manually making a list of your contacts in Excel. Use a templateĬonsider using an address book template to easily store your contacts.

It’s easy to view and insert information into each row and column. The easiest way to keep your contacts organized digitally is with Excel. Plus, a physical address book is easier to lose. Having a digital address book is easiest because you can quickly search for your contacts within your device or document. Nowadays, not many people have physical address books. But to keep your address book organized, you may want to store the contact information of those whom you know you’ll need to contact regularly.

You can store anyone’s contact info in your address book, whether it’s your favorite takeout restaurant’s phone number or your mother-in-law’s. Make better decisions backed by data and insights Learn More

Address book app for pc