Christmas Planner Spreadsheet, Gift Tracker, Holiday Budget, To Do Countdown (Google Sheets, Excel)

Every gift, every dollar, every task, in one file that adds it up. Days until Christmas, gift budget per person, what is still to buy, what is due this week.
Christmas Planner Spreadsheet for Google Sheets and Excel: gift tracker, holiday budget, to do countdown.

Add the people you buy for and a budget each. Add gifts as you think of them, type the price when you buy one and mark it Bought, then Wrapped. Spent, over or under budget and the status of every gift are counted for you, and the Dashboard lists what is still to buy, by person. Tasks get a due date and a days-left countdown with Overdue / Today / This week flags. The holiday budget shows planned vs actual for gifts, food, decor, travel, cards, charity and other.

▶ WATCH THE DEMO
Full 2-minute walkthrough on YouTube: https://youtu.be/MPkAub0Y7S4 (what you type, what gets calculated, how to open it). Short preview: the listing video above.

✅ FEATURES
✓ Countdown: days until Christmas
✓ Gifts: 150 rows with idea, store or link, budget, actual price
✓ Bought / Wrapped / Shipped ticks, hide from
✓ People: 40 with budget, gifts planned, bought, spent, a budget bar per person
✓ Secret Santa block
✓ Budget: planned vs actual for 7 categories, a one-line verdict
✓ Expenses: 200 rows, totals by category and by payer
✓ To-Do Countdown: 100 tasks with days left and a flag
✓ Cards: 100 names and addresses with Sent and Received, keep it for next year
✓ Menu and Shopping: who brings what, a 60-item list with cost
✓ Events: 30 with RSVP and days away
✓ Dashboard, Phone tab, Traditions and Memories, How-to-use tab

✨ WHAT'S INSIDE
14 TABS + step-by-step guide
✓ Dashboard: days until Christmas, budget left, gift budget, spent, gifts to buy, gifts wrapped, to-dos done %, cards sent, events in 7 days, gifts by person, budget by category, spending chart
✓ Phone tab: the countdown, money and the next gifts and tasks on one narrow screen for the Sheets / Excel app
✓ Gifts: 150 rows. Person from a dropdown, idea, store or link, budget, actual price, Bought / Wrapped / Shipped, hide from. Spent and status are calculated
✓ People: 40 people with relationship and budget, gifts planned, bought, spent, left and a budget bar per person. Secret Santa block
✓ Budget: total holiday budget, planned vs actual for 7 categories, remaining, a one-line verdict
✓ Expenses: 200 rows with date, category, item, amount, paid by. Totals by category and by payer
✓ To-Do Countdown: 100 tasks with due date, category and Done. Days left and a flag
✓ Cards: 100 names and addresses with Sent and Received. Keep it for next year
✓ Menu and Shopping: dishes per meal with who brings what, and a 60-item shopping list with Got it and cost
✓ Events: 30 events with date, place, time, RSVP, days away
✓ Traditions and Memories, Next Year: simple note lists
✓ How-to-use tab inside the file, plus a blank copy

📦 YOU WILL RECEIVE
✓ Christmas_Planner_v1.xlsx (sample data inside)
✓ Christmas_Planner_blank.xlsx (blank copy)
✓ How to open in Google Sheets (PDF)
Sample data inside: see how it works, then clear it or use the blank copy
Reuse year after year: pay once, free updates

⚙️ HOW IT WORKS
1. Add the people you buy for and a budget each, type your total holiday budget
2. Add gifts, expenses and tasks, fill only the yellow cells
3. Mark gifts Bought and Wrapped and tasks Done. The lists shrink, the countdown runs, the budget stays in view

👤 WHO IT'S FOR
Families with a long gift list, couples splitting the costs, anyone hosting Christmas dinner, Secret Santa organisers, people who shop early and want to stop overspending. Any currency, any Christmas date (set it once).

📱 WORKS IN
✓ Google Sheets (free Google account)
✓ Microsoft Excel 2016+ (Windows and Mac)
✓ Phone tab for the Sheets / Excel mobile app
✓ No macros, no add-ons, no LET or XLOOKUP, so it opens everywhere

📂 HOW TO OPEN IN GOOGLE SHEETS
Upload the file to Google Drive, right-click → Open with → Google Sheets, then File → Save as Google Sheets. All formulas and charts work (Google Sheets may drop some dropdown arrows after conversion: the PDF shows how to restore them in 10 seconds).

🛍️ ALSO IN THE SHOP
✓ Meal Planner Spreadsheet: https://www.etsy.com/listing/4576694906/meal-planner-spreadsheet-weekly-menu
✓ Annual Budget Spreadsheet: https://www.etsy.com/listing/4573820292/annual-budget-spreadsheet-for-google
✓ Simple Monthly Budget Spreadsheet: https://www.etsy.com/listing/4573801413/simple-monthly-budget-spreadsheet-for

⬇️ INSTANT DOWNLOAD
This is a digital product. Nothing will be shipped. After purchase, download the .xlsx files from your Etsy purchases page or the email Etsy sends you. The file comes with sample data (12 people, 28 gifts, 15 expenses, 40 to-dos from 1 Nov to 25 Dec, 20 cards, 2 menus, 18 shopping items, 6 events) so you can see how it works, plus a blank copy to start from.

⚠️ PLEASE NOTE
Built and tested in Excel 365 desktop and Google Sheets. Excel Online and the free mobile apps open the file for viewing and light editing, but protected sheets and charts render best on desktop. Colours may look slightly different between apps.

Instant download, so no refunds for change of mind. If something doesn't work as described, message me and I'll fix it or refund. For personal use only, please do not resell or share the file.

💬 QUESTIONS?
Message me any time, I reply within 24 hours. If something doesn't work on your setup, I'll fix it for you.

HeyPlanly: spreadsheets that actually calculate.