This christmas card list tracker keeps every address, every sent card and every reply in one tidy place, so no favourite aunt ever gets forgotten again. The spreadsheet holds each contact’s name, street address, city, state or region, postcode and country, with simple Yes/No dropdowns for Card Sent and Card Received. A summary block at the top counts your sent and received cards automatically with COUNTIF formulas, and six sample rows show the system working before you add your own list. Because the tracker is built once and reused every year, next December starts with last year’s addresses already checked and ready. The printable PDF companion adds a traditional address book — three pages with four generous contact blocks per page for name, phone, address, card history and notes — perfect for a binder by the phone or for grandparents who prefer pen and paper. Best of all, two mailing label pages are laid out in true Avery 5160 geometry: 30 labels per US Letter sheet, each exactly 2.625 by 1 inches with the correct margins and spacing, ready to print from your spreadsheet or fill in by hand, with light cut guides to keep everything neat. Download instantly, print at 100% scale, run one test sheet on plain paper, and send every card on time this Christmas.
What’s Inside:
- Excel / Google Sheets tracker (XLSX) with Name, address, city, region, postcode, country columns
- Card Sent and Card Received Yes/No dropdowns
- Automatic summary counts powered by COUNTIF formulas
- Printable PDF address book: 3 pages, 4 contact blocks per page
- 2 Avery 5160 mailing label pages: 30 labels per Letter sheet, exact 2.625″ x 1″ geometry
- Printing and alignment tips page
Who It’s For: Christmas card senders, grandparents, family organisers, and anyone rebuilding an address list after one too many lost envelopes.
How It Works: 1. Download instantly after checkout. 2. Type or paste your contacts into the tracker and mark cards sent/received with the dropdowns. 3. Print the address book pages for your binder and the label sheets onto Avery 5160 stock.
FAQ
Which labels does the template fit? Avery 5160 (and compatible 30-per-sheet US Letter label stock): 3 columns x 10 rows, each label 2.625″ x 1″.
Does it work in Google Sheets? Yes — upload the XLSX and the dropdowns and COUNTIF summary counts work in Sheets too.
Can I write on the labels by hand instead? Yes. The label pages are blank with light guides, so you can print them on plain paper or label stock and hand-write addresses.
































































































