Christmas Card List & Address Tracker Spreadsheet + Printable Address Book
Keep every holiday card address in one place, track who you've sent cards to and who sent you one, and estimate postage. The addresses are in separate columns, so you can sort them or use them for envelope labels.
★ WHAT YOU GET
• 1 spreadsheet (.xlsx) with 4 tabs: Start here, Summary, Setup, Addresses (300 households)
• Addresses: name(s) on the envelope, greeting, address in separate columns, email, group, send by Card / E-card / Hand deliver / Skip this year, Sent and Received for this year and last year
• Automatic flags: 'Received, not sent', 'Sent you one last year', 'Address missing'; international cards counted against your home country; one-cell envelope label
• Summary: cards to send, sent, still to send, received, this year vs last year, and a postage + cards estimate from the costs you enter
• 4-page printable address book in US Letter and A4: 15 households with sent/received boxes for 2026–2030, plus a card checklist
★ COMPATIBILITY
Made for Google Sheets (free Google account; upload the .xlsx to Google Drive, then open it with Google Sheets), Microsoft Excel 2010 or later, and LibreOffice Calc. Formulas were checked for Google Sheets and Excel compatibility (standard functions only, no macros, no add-ins) and tested in LibreOffice Calc. Unzip the download first (double-click on most computers). Best used on a computer or tablet. Enter dates as real dates (e.g. 3/15/2027 or 15/03/2027). Printable PDFs in US Letter (8.5 × 11 in) and A4. Print at home or at a print shop (choose 'Actual size' or 'Fit'). The PDFs are for printing and writing by hand. They are not fillable forms.
★ GOOD TO KNOW
• Postage is only an estimate from the cost per card you enter. Check current rates and last posting dates with your postal service.
• The file holds personal addresses, so keep it private.
• Example rows are included. Delete them before you start.
★ Personal use only: for you and your household. Please don't share, resell or redistribute the files.
★ Digital download: nothing physical is shipped. You get one .zip file; unzip it to get the files.
★ 14-day promise: if a file is faulty or not as described, contact me within 14 days and I'll fix it or refund you.
Made with the help of AI tools (drafting text, layouts and formulas); I chose the content and reviewed and edited every file.