Christmas Card List & Address Tracker - 10-Year Sent/Received Spreadsheet for Google Sheets & Excel

Keep every Christmas card address in one place and see at a glance who you sent to and who sent to you, year after year.

Why you will like it

- One list for all your holiday card addresses, no more digging through old envelopes

- A 10-year Sent/Received log (2026 to 2035) with Y/N dropdowns, so you can see who you have lost touch with

- One row per household, with the family members listed beside the name on the envelope

- ZIP codes stored as text, so leading zeros (like 02134) are kept

- A Mail-Merge tab that builds ready-to-print address lines for labels or envelopes

What's included

- 1 spreadsheet file (.xlsx), no macros, with 5 tabs:

- Start Here: quick how-to

- Contacts: 200 rows for name on envelope, household members, street, line 2, city, state, ZIP, country, email and notes

- Card Log: Sent and Received for each year 2026 to 2035, plus a running status on every row

- Mail-Merge: Name, Address1, Address2, City/State/ZIP, Country and a full multi-line label

- Summary: cards sent, received and sent-but-not-received-back for each year, plus a household count

- 3 yellow example rows (fictional) to show how it works; delete them when you start

How it works

- Enter each household once on Contacts

- Each year, choose Y or N under that year's Sent and Received columns on Card Log

- For labels, copy the Mail-Merge columns, paste as values into a new sheet, and use that with Word mail merge or your label tool

Compatibility

- Standard .xlsx file for Microsoft Excel; open it in Google Sheets by uploading it to Google Drive

- Instant download after purchase

Who it's for

- Families who send holiday cards every year

- Anyone tidying up an address book before the holidays

- People who want a simple Christmas card list spreadsheet instead of a paper book

FAQ

- Will my ZIP codes keep leading zeros? Yes, the ZIP column is stored as text.

- Can I use it for other holidays? Yes, use it for any yearly card list.

- Questions? Email hirelinetemplates@mail.grokbot.com

Planning holiday gifts too?

- Christmas Gift & Holiday Budget Tracker ($5): https://payhip.com/b/IjdQ6

- Holiday + 2027 Budget Pair ($10, save $3 vs $13 for the Christmas Gift & Holiday Budget Tracker $5 + 2027 Budget Planner $8 bought separately): https://payhip.com/b/vniJ9

Sending cards this year? Get all 3 holiday planners (card list, Secret Santa, hosting) in the Holiday Planner Bundle for $9 ($11 separately): https://payhip.com/b/Mu7Oy

Shopping Black Friday or Cyber Monday? Plan it with the Black Friday & Cyber Monday Deal Planner ($3): https://payhip.com/b/ZlX4C