Hosting Christmas is a logistics job. Grandparents arrive on the 22nd, cousins on the 24th, neighbors only for dinner. Someone is gluten-free, someone has a nut allergy, and the oven can only be at one temperature at a time. The Gathertide Christmas Hosting Planner Spreadsheet turns all of that into a plan you can see at a glance, in Excel or Google Sheets.
What this Christmas hosting planner does
You enter your guests and their dates once. Gathertide works out how many people are in the house each day, how many sleep in each room each night, and how many you are feeding at every meal. Add your menu with prep, cook and rest minutes, and it builds a cooking timeline backward from your serving time, warns you when two dishes need the oven at different temperatures, and lists every job in start order.
Who it is for
- Families hosting relatives for several days over Christmas
- Hosts cooking a large Christmas dinner with several dishes
- Potluck hosts who want to know who brings what
- Anyone with guests who have allergies or dietary needs
Main features
Guests and RSVPs
40 parties with adults, kids, RSVP (Invited, Yes, Maybe, No), arrival and departure dates, nights, room, two dietary needs, potluck dish and course, phone and notes. Allergies are highlighted.
Rooms and beds, night by night
List up to 12 rooms or spaces with beds and how many they sleep. For each of the 7 nights in your visit window, Gathertide counts the confirmed guests sleeping there and turns red when a room is over capacity. A separate row shows overnight guests who do not have a room yet.
Meal Plan with automatic headcounts
Breakfast, lunch, dinner and snacks for 7 days (28 meals). Headcounts include your household plus every confirmed guest who is there that day. Add or subtract for drop-ins. Christmas Day is highlighted.
Menu and cooking timeline
- 40 dishes with course, meal, servings, prep, cook and rest minutes, oven temperature, make-ahead and who makes it
- Start prep, cooking start and cooking end times worked back from serving time
- Day before flag for long jobs
- Oven check that flags temperature clashes
- Run sheet that lists every dish in start order
Shopping list, budget and checklist
- 150-line shopping list with dish, quantity, unit, store section and cost. Mark Have it or Bought and the line fades out.
- Hosting budget with 12 categories and a 100-line spending log
- 45-task checklist with 21 prewritten tasks. Due dates count back from Christmas Day and show Due soon or Overdue.
Dashboard
Guests confirmed, Christmas Day headcount, overnight guests, days to Christmas, dishes planned, shopping items left, budget left and checklist progress, plus RSVP and dietary tables, a main meal summary (serving time, first job, oven clashes, potluck dishes, rooms over capacity) and charts for dinner headcount by day and budget vs spent.
What is included
- Gathertide Christmas Hosting Planner (.xlsx), a clean blank copy with 11 tabs
- User guide (.docx) with setup steps, how each calculation works, troubleshooting and FAQ
How it works
- Set your currency, Christmas Day, serving time, household size and visit window in Settings.
- Add guests with dates and dietary needs, and name your rooms.
- List your dishes with their times and oven temperature.
- Check the Timeline, Meal Plan and Dashboard, then shop from the list.
File format and software
One .xlsx workbook built with Excel and Google Sheets compatible formulas (SUMIFS, COUNTIFS, INDEX, MATCH, MOD and similar). No macros. Works in Excel 2010 or newer on Windows and Mac, Excel for the web, and Google Sheets. Guide in Word .docx.
Customizing
Pick any currency symbol. Edit the lists of dietary needs, courses, store sections, budget categories and meals. Rename rooms and tasks. Formula cells are locked without a password so they stay safe while you type.
Real situations where it helps
- Your brother’s family of four is booked into a basement that sleeps three. The Rooms tab turns red for those three nights.
- You want dinner at 3 PM. The run sheet tells you the turkey prep starts at 10:20 AM.
- The stuffing needs 350 degrees while the carrots need 425. The oven check catches it.
- Three guests have dietary needs. The dashboard lists them, with allergies flagged.
Digital download
Nothing ships. Download right after checkout from your Taskdale account or order email. Personal use only.
FAQ
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets.
Does it tell me cooking times?
No. You enter the times from your recipes; Gathertide schedules them. Use a thermometer for food safety.
Can I use it for Thanksgiving?
Yes. Change the date and visit window in Settings.
How many guests can I plan for?
40 parties, 12 rooms, 40 dishes and 150 shopping items.
Is there a free version?
Yes. Gathertide Lite (10 guests, 8 dishes, timeline) is a free download on the Taskdale blog.
Can I change the currency?
Yes, in Settings. $ is the default.












Reviews
There are no reviews yet.