Christmas Dinner & Holiday Party Planner Spreadsheet - Guest List, Menu, Cooking Timeline, Budget

Host Christmas dinner or a holiday party without the scramble: guest RSVPs, diets and allergies, the menu, a cooking timeline worked back from serving time, the shopping list and the budget in one spreadsheet.

Why you will like it

- Know your real headcount: only RSVP Yes parties count, with a separate Maybe headcount

- See dietary needs and allergies among confirmed guests, and how many dishes fit each diet

- Enter your serving time once and get "Start prep at" and "Into oven / on heat at" times for every dish

- Shopping list with estimated and actual costs, rolled up by category

- Budget tab flags OVER or OK and shows cost per confirmed guest

What's included

- 1 spreadsheet file (.xlsx), no macros, with 6 tabs:

- Start Here: quick how-to

- Guest List: 60 rows for guest / household, RSVP dropdown (Yes, No, Maybe, No reply), number in party, dietary needs dropdown, allergies, bringing a dish (Y/N), dish and notes

- Menu: 40 rows for dish, course dropdown, who is making it, Y/N tags for vegetarian, vegan, gluten-free, dairy-free and nut-free, plus a "Dishes that fit" count for each

- Cooking Timeline: serving date and time, then 30 rows for prep, cook and rest minutes, oven temp, start times and total minutes

- Shopping List: 100 rows for item, category dropdown, qty, est. unit price, est. total, actual paid and bought (Y/N)

- Budget: budget limit, estimated and actual totals, remaining, OVER/OK, confirmed and Maybe headcount, cost per confirmed guest, guests bringing a dish, spending by category and dietary counts

- Yellow example rows (fictional) to show how it works; delete them when you start

How it works

- Add each invitation on Guest List and update RSVPs as they come in

- Plan dishes on Menu and check the diet counts

- Enter your serving time and each dish's minutes on Cooking Timeline

- Build the Shopping List, then enter what you actually paid

- Set your limit on Budget and watch the OVER/OK flag

Compatibility

- Standard .xlsx for Microsoft Excel; open it in Google Sheets by uploading it to Google Drive

- Instant download after purchase

Who it's for

- Anyone hosting Christmas dinner, Thanksgiving, Friendsgiving or a New Year's party

- Potluck hosts tracking who brings what

- Hosts cooking for guests with diets or allergies

FAQ

- Is there a dashboard? The Budget tab is the summary; there is no separate dashboard tab.

- Can I use it for other gatherings? Yes, any dinner or party with RSVPs and a menu.

- Questions? Email hirelinetemplates@mail.grokbot.com

Planning holiday gifts too?

- Christmas Gift & Holiday Budget Tracker ($5): https://payhip.com/b/IjdQ6

- Holiday + 2027 Budget Pair ($10, save $3 vs $13 for the Christmas Gift & Holiday Budget Tracker $5 + 2027 Budget Planner $8 bought separately): https://payhip.com/b/vniJ9

Hosting the holidays? Get all 3 holiday planners (hosting, card list, Secret Santa) in the Holiday Planner Bundle for $9 ($11 separately): https://payhip.com/b/Mu7Oy

Shopping Black Friday or Cyber Monday? Plan it with the Black Friday & Cyber Monday Deal Planner ($3): https://payhip.com/b/ZlX4C

Traveling for the holidays? Split shared trip costs and see who owes who with the Holiday Travel Budget & Trip Cost Splitter ($4): https://payhip.com/b/ZhatP