Free template
Holiday card list template
A holiday card list gets searched for in exactly two seasons: late November, in mild panic, and early January, in quiet resolve to be organized next year. Both are good moments to start. The job is more specific than an address book — you're running a small annual mailing operation, and the questions that trip people up are operational: who actually got a card last year, which envelope came back undeliverable, and who signs when cards go out from the whole family. This template answers all three with per-year sent columns and a returned-mail flag, because memory across a twelve-month gap is exactly what spreadsheets are for. The honest limit: the sheet manages the December logistics, not the relationships behind them. If a card is the only touch someone gets all year, that's worth noticing — the addresses here import straight into Endearist if you want the other eleven months covered too.
Opens in Excel, Google Sheets, Numbers — or imports straight into Endearist.
What each column means
| Column | How to use it | Example |
|---|---|---|
| Name | One row per household, keyed to the person you actually know — everyone else appears on the envelope line. | Gloria Patterson |
| Street address | The complete first address line including unit or c/o details — holiday mail often fails on a missing apartment number. | 1174 Maple Crest Drive |
| ZIP / postal code | Format as text so leading zeros (like 04401 in Maine) don't get swallowed by the spreadsheet. | 04401 |
| City | Its own column, separate from the ZIP — the split pays off the moment you print labels or sort by place. | Bangor, ME |
| Country | Only relevant for international mail — then in capitals as the last line, and mind the earlier overseas mailing deadlines. | UNITED KINGDOM |
| Signed by | Who signs this household's card — "just me", "both of us", or "whole family". Settles the annual kitchen-table debate in advance. | Whole family incl. kids |
| Sent 2025 | "Yes", "No", or the mailing date. Last year's column is your single most useful reference next December. | 2025-12-12 |
| Sent 2026 | This season's column — tick it as each card goes in the mailbox. Add a fresh column every year; never delete the old ones. | Yes |
| Returned mail | Flag it when a card bounced back as undeliverable — that address is dead and needs updating before the next mailing. | Bounced in 2024 — need new address |
| Notes | Card-specific details: always sends one back, recent loss in the household, prefers a neutral "Season's Greetings" card. | Always sends hers first — get ours out early |
How to use this template
- Build the list in January, not December
Right after the holidays you still know exactly who sent a card this year, which envelope bounced, and whom you forgot. Enter all of it while the envelopes are still on the dresser — by November that knowledge is gone. Twenty minutes in January saves you the December detective work.
- Add a fresh sent column every year
Each fall, copy the sent-2026 column and rename it for the new year instead of overwriting old values. The multi-year history reveals patterns: someone who hasn't reciprocated in three years can graciously come off the list — and someone who writes every year has earned an especially personal line.
- Tick the column at the mailbox, not at the desk
A written card is not a sent card — the notorious gap between the stack and the mailbox swallows a few envelopes every year. Only tick the sent column once the card is physically in the mail. Then filter for empty cells: those are your stragglers.
- Color flagged addresses with conditional formatting
Set up a rule that colors any row red when the returned-mail column has an entry. In October you can then work through the dead addresses at a glance — quick message, ask for the new address, clear the flag — before crunch time starts and more cards vanish into the void.
Mistakes to avoid
- Ignoring bounced cards and mailing the same address again
Without a returned-mail column, the same thing happens every year: the card to the old address bounces (or simply vanishes), and twelve months later the next one goes to the same dead address. Flag every bounce immediately and resolve it in the spring — not when next year's card is already in its envelope.
- The list only ever grows
Out of politeness, every household ever added stays on the list forever — until 30 cards have become 80 and the personal line in each one dies. It's fine to quietly drop people you've had no other contact with for years. Fewer cards with a real sentence beat many with only a printed greeting.
- Starting at the end of November
Buying cards, writing them, checking addresses, getting stamps — that's several evenings, not one heroic night. Start in late November and you'll also miss international mailing deadlines. Plan backwards: overseas cards in the mail by early December, domestic by mid-December, so writing starts the last week of November at the latest.
- A shared file with no clear owner
When both partners work in the same file "sort of", households get two cards or none — and nobody notices until January. Designate one person who owns the list and does the ticking; the other writes cards. And since the file holds private addresses with family details: share it between the two of you only, never "anyone with the link".
Frequently asked questions
- How do I organize sending holiday cards?
- With one row per household rather than per person, a sent column per year, and a fixed rhythm: log bounces and received cards in January, fix dead addresses in October, write in late November, mail by early-to-mid December. The per-year columns answer the hardest question for you — who actually received a card last year.
- When should holiday cards be mailed by?
- Domestic cards should be in the mail by mid-December; official postal deadlines usually fall around December 18–20, but the closer to the limit, the more clogged the sorting centers. International mail needs two to four weeks more depending on the destination — for overseas, that means late November. After two seasons, the dates in your sent columns show your own realistic lead time.
- Who should be on my holiday card list?
- A workable rule of thumb: people you'd message outside of December anyway, plus the generation of your parents and grandparents, for whom physical mail genuinely matters. Anyone who's on the list purely out of habit and hasn't responded or sent one in three years can quietly drop off. The quality of each card beats the length of the list.
- What should I write in a holiday card besides "Happy Holidays"?
- A single personal line is enough — but it has to be specific: a reference to something from the person's year ("How's the new place in Bangor?") or a shared memory. That's exactly what the notes column is for: what you collect there over the year becomes December's personal line. Cards with no handwritten sentence at all are, honestly, not worth sending.
Last updated: 2026-06-10
When the spreadsheet gets too small.
Endearist imports this CSV directly — and reminds you before contacts go quiet. Free up to 25 contacts.
Start free