Keeping track of who gets a card, whose address changed and who sent one back is easier in a spreadsheet than on the back of an envelope. This template is a ready made Christmas card list: one row for each person or household, with columns for the address, whether you sent a card and whether you got one.
Download the template
- Christmas card list template (.xlsx): opens in Excel, and you can import it into Google Sheets™. Free download, no sign up.
- Christmas card list template (.csv): the same list as plain text, for any spreadsheet program.
- Prefer paper? A blank printable list with the same columns, two pages: US Letter (.pdf) or A4 (.pdf).
The .xlsx file has three tabs. "Read me" holds short instructions, "Cards" holds the list and "Several years" tracks cards over time (see below). The three example rows are made up: delete them before you start.
What each column is for
| Name line | The name as it should print on the envelope or label, such as "The Hart Family" or "Grandma Ruth". |
|---|---|
| Address line 1, Address line 2 | Street and number, and an apartment or suite if there is one. |
| City, State, ZIP | The rest of the address. Use Town and Postcode if that is how you write it. The ZIP column is plain text, so codes like 02134 keep their leading zero. |
| Country | Only for cards going abroad. Leave it empty for domestic addresses. |
| Household | A short word that groups the rows of one home, such as "Hart". Sort by it to see everyone from the same address together, and use the same Name line on those rows if you want one card for that home. |
| Card sent | Choose Yes when the card is in the post. |
| Card received | Choose Yes when theirs arrives, so you can see who to expect next year. |
| Notes | Anything else: a new address, a baby's name, "send a photo card". |
Keep track over several years
The "Several years" tab copies the name lines from the "Cards" tab, so you type each name only once. Next to them it has a Sent and a Received column for 2026, 2027 and 2028. Choose Yes in the column for the year, and you can see at a glance who sent you a card each year and who to ask for a new address.
Import it into Google Sheets™
- Download the .xlsx file.
- Open Google Sheets™ and choose File, Import, Upload, then pick the downloaded file.
- Choose Create new spreadsheet and then Import data.
- Open the "Cards" tab and delete the three example rows.
Using the .csv file instead? In the import window, switch off "Convert text to numbers, dates, and formulas", so a ZIP code such as 02134 keeps its leading zero.
Open it in Excel
Double click the .xlsx file. The Yes lists for "Card sent" and "Card received" work in Excel too.
Use it year after year
Keep one list and update it in November: fix the addresses that changed, add new friends, clear the two Yes columns and start again.
When the list is ready, print it as address labels or envelopes
Once your addresses are in, you do not have to write them out by hand. Peelstack Label Maker, an add-on for Google Sheets™, prints a list like this one on label sheets such as Avery® 5160 or on envelopes, with one label for each household. The steps are in Christmas card address labels from a Google Sheet™, and you can find the add-on on the Peelstack Label Maker page.
Avery® is a trademark of Avery Products Corporation. Taskivator is not affiliated with Avery.