Free address book template for Google Sheets
Keep everyone's phone, email and mailing address on one tidy sheet you can sort, search and share. It also counts down to each birthday, tells you how old someone is turning, and keeps your holiday card list with a tick for every card that's gone out.
Pro Want labels, envelopes and a birthday calendar that fill in from one list? See Address Book Pro →| First name | Last name | Group | Phone | Street | City | State | ZIP | Birthday | Next birthday | Days away | Turns | Name on envelope | Holiday card | Card sent | Mailing address | Notes | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Linda | Morales | Family | (312) 555-0142 | linda.morales@email.com | 2218 W Belden Ave | Chicago | IL | 60647 | Mar 14, 1958 | Mar 14, 2027 | 130 | 69 | Mom and Dad | Mom and Dad, 2218 W Belden Ave, Chicago, IL 60647 | |||
| Daniel | Morales | Family | (773) 555-0198 | dan.morales@email.com | 415 Maple St | Evanston | IL | 60201 | Nov 19, 1986 | Nov 19, 2026 | 15 | 40 | The Morales family | The Morales family, 415 Maple St, Evanston, IL 60201 | Kids: Mia (8), Leo (5) | ||
| Rosa | Alvarez | Family | (708) 555-0117 | rosa.alvarez@email.com | 90 Oak Park Ave | Oak Park | IL | 60302 | Jul 2, 1949 | Jul 2, 2027 | 240 | 78 | Aunt Rosa | Aunt Rosa, 90 Oak Park Ave, Oak Park, IL 60302 | Likes handwritten cards | ||
| Priya | Shah | Friends | (312) 555-0163 | priya.shah@email.com | 1840 N Halsted St, Apt 3B | Chicago | IL | 60614 | Nov 27, 1990 | Nov 27, 2026 | 23 | 36 | Priya and Sam | Priya and Sam, 1840 N Halsted St, Apt 3B, Chicago, IL 60614 | |||
| Marcus | Bell | Friends | (617) 555-0131 | marcus.bell@email.com | 22 Elm St | Somerville | MA | 02144 | Jan 9, 1988 | Jan 9, 2027 | 66 | 39 | Marcus Bell, 22 Elm St, Somerville, MA 02144 | College roommate | |||
| Hannah | Kim | Friends | (206) 555-0185 | hannah.kim@email.com | 5120 Ballard Ave NW | Seattle | WA | 98107 | Dec 3, 1991 | Dec 3, 2026 | 29 | 35 | The Kim family | The Kim family, 5120 Ballard Ave NW, Seattle, WA 98107 | |||
| Tom | Becker | Neighbors | (312) 555-0109 | tbecker@email.com | 2216 W Belden Ave | Chicago | IL | 60647 | May 21, 1962 | May 21, 2027 | 198 | 65 | Tom and Ellen | Tom and Ellen, 2216 W Belden Ave, Chicago, IL 60647 | Has our spare key | ||
| Ellen | Becker | Neighbors | (312) 555-0110 | ellen.becker@email.com | 2216 W Belden Ave | Chicago | IL | 60647 | Nov 8, 1964 | Nov 8, 2026 | 4 | 62 | Ellen Becker, 2216 W Belden Ave, Chicago, IL 60647 | Same card as Tom | |||
| Grace | Okafor | Work | (312) 555-0176 | grace.okafor@work.com | 300 N LaSalle St | Chicago | IL | 60654 | Sep 30, 1983 | Sep 30, 2027 | 330 | 44 | Grace Okafor, 300 N LaSalle St, Chicago, IL 60654 | Manager | |||
| Jason | Wu | Work | (312) 555-0127 | jason.wu@work.com | Dec 12, 1993 | Dec 12, 2026 | 38 | 33 | |||||||||
| Carol | Jensen | Friends | (414) 555-0152 | carol.jensen@email.com | 781 E Lake Dr | Milwaukee | WI | 53202 | Feb 18, 1955 | Feb 18, 2027 | 106 | 72 | Carol and Pete | Carol and Pete, 781 E Lake Dr, Milwaukee, WI 53202 | |||
| Dr. Anita | Rao | Services | (312) 555-0190 | frontdesk@raodental.com | 1100 N State St | Chicago | IL | 60610 | Dr. Anita Rao, 1100 N State St, Chicago, IL 60610 | Dentist | |||||||
| Mike | Duran | Services | (773) 555-0144 | Plumber, Duran Plumbing | |||||||||||||
| Sofia | Morales | Family | (872) 555-0168 | sofia.m@email.com | 66 Lincoln Ave, Apt 2 | Brooklyn | NY | 11225 | Nov 10, 1997 | Nov 10, 2026 | 6 | 29 | Sofia Morales, 66 Lincoln Ave, Apt 2, Brooklyn, NY 11225 | Sister | |||
| Ben | Carter | Friends | (512) 555-0121 | ben.carter@email.com | 4308 Avenue F | Austin | TX | 78751 | Jun 25, 1989 | Jun 25, 2027 | 233 | 38 | Ben and Jess | Ben and Jess, 4308 Avenue F, Austin, TX 78751 | |||
| Joyce | Hill | Neighbors | (312) 555-0139 | 2220 W Belden Ave | Chicago | IL | 60647 | Dec 24, 1946 | Dec 24, 2026 | 50 | 80 | Joyce Hill, 2220 W Belden Ave, Chicago, IL 60647 | Bring cookies at Christmas | ||||
| Item | Value |
|---|---|
| Today's date | Nov 4, 2026 |
| Contacts | 16 |
| Birthdays in the next 30 days | 5 |
| Days to the next birthday | 4 |
| On the holiday card list | 11 |
| Cards sent | 4 |
| Cards still to send | 7 |
| Contacts by group | |
| Family | 4 |
| Friends | 5 |
| Neighbors | 3 |
| Work | 2 |
| Services | 2 |
| Birthdays by month | |
| January | 1 |
| February | 1 |
| March | 1 |
| April | 0 |
| May | 1 |
| June | 1 |
| July | 1 |
| August | 0 |
| September | 1 |
| October | 0 |
| November | 4 |
| December | 3 |
What's inside
- Name, group, phone, email and full mailing address for every contact
- Birthdays with the next date, days to go and the age they're turning
- A holiday card list with a Name on envelope column, like The Kim family, and a tick for each card sent
- A ready-to-copy mailing address on one line for envelopes and labels
- A summary with birthdays in the next 30 days, cards left to send, contacts by group and birthdays by month
- Works in Google Sheets and Excel, and you can share it with your household
How to use it
Download your copy
Click "Free download" to save the .xlsx file. It opens in Excel, or in Google Sheets: open a blank sheet (sheets.new) and choose File, then Import, then Upload.
Clear the samples
Delete the sample contacts but keep the formula columns: Next birthday, Days away, Turns and Mailing address fill in by themselves.
Add your people
Type one person or household per row. Put ZIP codes in as text so leading zeros stay, and use the groups Family, Friends, Neighbors, Work and Services, or your own.
Keep the date current
On the Summary tab, replace Today's date with =TODAY() so Days away always counts from today.
Build your card list
Tick Holiday card for everyone you send to and fill in Name on envelope. As cards go out, tick Card sent. The Summary shows how many are left.
Sort and filter
Click Data, then Create a filter. Sort by Days away to see the next birthdays, or filter Group to just Family.
Tips
Print envelope labels
Copy the Mailing address column into a label tool, or use a label add-on for Google Sheets, such as Avery Label Merge, with the Street, City, State and ZIP columns.
Get your phone contacts in
Export contacts from Google Contacts as a CSV, open it, and paste the columns you need into this sheet. It's quicker than typing them.
Reset the card ticks each year
After the holidays, select the Card sent column and untick it, so next year starts clean while your list stays.
Share it with the family
Click Share and add your partner as an editor. You'll both see new addresses as soon as one of you adds them.
Questions
How do I make an address book in Google Sheets?
Download this template, delete the sample rows and add your contacts, one per row. The birthday and mailing address columns work themselves out.
Can I print my address book?
Yes. Click File, then Print, choose Landscape and Fit to width. To print fewer columns, hide the ones you don't need first (right-click the column letter, then Hide column).
What if I don't know someone's birth year?
Type the birthday with any year. Next birthday and Days away still work, but ignore the Turns column for that person.
Why do ZIP codes lose their first zero?
Spreadsheets treat 02144 as a number and drop the zero. The ZIP column in this template is plain text. If a zero still disappears, type an apostrophe first, like '02144.
Can I use it as a contact spreadsheet for work?
Yes. Rename the groups to things like Clients and Suppliers. For tracking deals and follow-ups, a CRM template fits better.
Is this address book template free?
Yes. Download the .xlsx file and open it in Excel or Google Sheets. No sign-up.
Pro version
Address Book Pro
Every address, birthday and holiday card in one place, with labels and envelopes that print straight from the sheet.
Type each address once
Add a household once and pick it for everyone who lives there. Phone lists, labels, envelopes and the card list all use the same address, so one change updates them all.
Never miss a birthday
See the birthdays and anniversaries coming up in the next few weeks, how old someone is turning, and the big ones like 40, 50 or 25 years married.
A birthday calendar for the fridge
All twelve months on one printable page, with birthdays, ages and anniversaries in date order.
Holiday cards without the guesswork
Tick who you sent to and who sent you one. The card list shows who's left, who sent one you haven't answered, and what happened last year.
Print labels and envelopes
Labels print 30 to a page for your card list, everyone, or one group. Envelope prints one #10 envelope with your return address. No mail merge or add-ons.
Keep it current
Each address gets a 'checked on' date and a flag when it's time to confirm it again, so cards stop going to old addresses.
| Free | Pro |
|---|---|
| One row per person | Households and people, so each address is typed once |
| Days until each birthday | Upcoming birthdays and anniversaries, soonest first |
| Holiday card tick boxes | Card list with sent, received and last year |
| · | Printable birthday calendar for the whole year |
| · | Mailing labels, 30 per page |
| · | Printable envelope with your return address |
| · | A to Z directory you can print by group |
| · | Dashboard with charts and an address-check flag |
$19 one-time
11 tabs: Start Here, Dashboard, Upcoming, Birthday Calendar, Card List, Labels, Envelope, Directory, Households, People and Setup. You get two copies: one filled in with a sample family so you can see it working, and a blank one ready for your own contacts.
Get Address Book Pro for $19- Instant download after checkout
- Works in Google Sheets and Excel
- Yours to keep and reuse every year