Spreadsheet template · digital download
A Christmas card list that prints its own envelope labels
Type each household once. Mark cards as they go out and come in. When it's time to address envelopes, print labels straight from the list, with no mail merge to set up.
Buy on Etsy, $5.50 Instant download through Etsy. Made for Microsoft Excel on a computer.
Who it's for
Households that mail about 30 to 150 cards a year and either address envelopes by hand or fight with a mail merge each December. If that's you, the labels are the reason to buy it.
What you get
- Addresses: room for 200 households, with a name for the envelope, a group, the address, and Sent and Got one columns for 4 years. A "Send a card?" choice skips someone for a year without deleting them.
- Labels: one label per household on standard 30-per-sheet, 1 x 2-5/8 inch US Letter sheets. Print this year's list, or only the people who sent you a card and haven't had one back.
- Summary: pick the card year to see sent so far, still to send, skipped, received, and progress by group.
- Example: a tab of made-up households, so you can see how it works. Your own tabs start empty, and nothing is locked.
Pictures are from the actual file, with example data typed in.
What works where
| App | Status |
|---|---|
| Microsoft Excel on a computer | What it's made for. Formulas and print layout are checked by automated tests; it hasn't been opened in every Excel version. |
| Google Sheets | Not tested yet, so we don't claim it works there. |
| Apple Numbers, phones and tablets | Not tested. |
Print your first sheet on plain paper and hold it against a label sheet before loading labels, since printers can shift slightly. Print at 100% (Actual size).
When a different product suits you better
If you mainly want gift budgeting, a combined gift and card tracker will fit better. If you plan in Google Sheets, this one isn't ready for you yet.
Sold through our Etsy shop, so Etsy handles the purchase, download and order help. It's a digital file; nothing is shipped. For personal or small-business use. Designed by Mister Marbi. Layouts are generated with AI-assisted software and checked on screen and with automated layout and formula tests before listing.