Thanksgiving Dinner Planner Spreadsheet: How to Plan for 20 Guests Without Oven Chaos
You said yes to hosting, the count is somewhere around twenty, and you have already noticed that the turkey wants 325°F, the rolls want 375°F, and everything has to be on the table at the same time.
That is the real problem with hosting Thanksgiving. The cooking is not hard. The coordination is: who is coming, who is bringing what, what it costs, how much to buy, and what is in the oven at 3:10 pm.
A spreadsheet is the right tool for it, because every one of those questions is arithmetic. This guide sets out what a Thanksgiving dinner planner spreadsheet actually needs, works one full example for 23 guests with real numbers, and gives you a countdown checklist you can copy today.
The Five Jobs a Thanksgiving Planner Has to Do
Most free printable checklists cover the first two jobs and stop. A working planner does all five, and the last three are where the stress comes from.
- Count the people who are actually coming. Not the people who might.
- Track the menu. Every dish, who is making it, and whether it is confirmed.
- Calculate the real cost per guest. The number you keep asking yourself.
- Scale the shopping list. Recipes are written for six or eight. You are feeding twenty-three.
- Schedule the oven. Work backwards from the serving time and catch conflicts before the day.
Each gets its own section below, with the exact logic.
Job 1: Count Only the Yeses
The single most useful rule in a hosting spreadsheet: only a “Yes” counts toward headcount.
A “Maybe” that gets counted inflates your budget and your shopping list. A “No Response” that gets ignored leaves you short. So the guest list needs an RSVP column with a small fixed set of values (Yes, Maybe, No, No Response), and a confirmed heads column that reads:
=IF(RSVP="Yes", adults + kids, 0)
Track adults and kids in separate columns from the start, because they cost different amounts and eat different amounts. Add a dietary column and an allergy-severity column while you are there. Severe allergies deserve their own flag, because they change what you can serve, not just how much.
Worked example. In our example dinner, RSVPs come back with 23 people confirmed: 16 adults and 7 kids. One household is still a “Maybe” and correctly contributes zero. That confirmed number, 23, drives everything below.
Job 2: Build the Menu With Owners and Coverage
A menu tab needs more than a list of dishes. Give every dish these fields:
| Field | Why it matters |
|---|---|
| Dish and course | Lets you check each course covers the room |
| Serves | Servings the dish actually makes |
| Made by | Host or a named guest |
| Confirmed? | A promised dish is not a delivered dish |
| Method and oven temp | Feeds the timeline (Job 5) |
| Cook and rest minutes | Feeds the timeline |
| Rough cost | Feeds the budget (Job 3) |
Then add two checks. Course coverage: total servings for each course divided by headcount. If appetizers cover 0.4 servings per guest, you know before the day. Duplicate detection: two sweet potato casseroles is a classic potluck outcome, and a spreadsheet can flag it the moment the second one is typed in. The potluck sign-up guide in this series goes deeper on how to assign dishes so it never happens.
Job 3: Solve Cost Per Guest
Everyone has a number in their head for what Thanksgiving costs per person, and it is almost always the food-only number. The all-in number is higher, and it is the one your bank account experiences.
Here is a cost breakdown for the 23-guest dinner. These are illustrative estimates, not price benchmarks — swap in your own:
| Category | Estimate | Per guest (23) |
|---|---|---|
| Food | $312 | $13.57 |
| Drink | $118 | $5.13 |
| Decor | $64 | $2.78 |
| Rentals (tables, chairs, linens) | $88 | $3.83 |
| Serveware | $52 | $2.26 |
| Supplies (foil, napkins, containers) | $41 | $1.78 |
| Other | $20 | $0.87 |
| Total | $695 | $30.22 |
Food alone is $13.57 per guest. The full evening is $30.22. That gap is the entire reason a planner tracks more than groceries.
Two refinements make the number honest:
- Weight kids. If a child eats about half an adult portion, the sheet uses 16 + (7 × 0.5) = 19.5 adult-equivalent guests, which makes the cost per adult-equivalent $35.64. Set the weighting yourself.
- Solve it backwards. Forward: “what does this cost per person?” Reverse: “I can spend $700. How many people can I feed?” Split costs into fixed (decor, rentals, serveware, other: $224 here) and per-head (food, drink, supplies: $471, or about $20.48 per guest). Then guests you can afford = ($700 − $224) ÷ $20.48 = about 23 guests.
The full cost-per-person breakdown, including what changes at 12 guests versus 28, is in its own article, because fixed costs make small dinners far more expensive per head than people expect.
Job 4: Scale the Shopping List
A recipe written for eight is a problem at twenty-three. The formula is simple:
Scaled quantity = recipe quantity × (guests ÷ recipe serves), rounded up to something you can actually buy.
If the mashed potato recipe uses 3 lb of potatoes and serves 8, then for 23 guests: 3 × (23 ÷ 8) = 8.6 lb, so buy a 10 lb bag. Do the same on every line, and group the list by store section (produce, dairy, meat, pantry) so you shop once instead of three times.
Two cautions: seasoning, salt and leavening do not always scale in a straight line, so treat those lines as a starting point and taste as you go; and bake times change with pan size. The quantity guide for feeding 20 covers turkey weight, sides and desserts with the rules of thumb spelled out.
Job 5: Schedule the Oven (the Part Nobody Plans)
This is what turns a calm dinner into a crisis. Every oven dish has a temperature, a cook time and often a rest time. If you never line them up, you find out at 3:10 pm that the sweet potatoes and the rolls want different heat, and the oven is full.
A planner solves it by working backwards from the serving time. For each dish it calculates:
- Ready at = serving time
- Into the oven = ready at − cook time − rest time
- Load = how many dishes are in the oven during each window
- Temp clash = two dishes overlapping at different temperatures
- Over capacity = load greater than the dishes your oven physically holds
Worked example. Serving time 4:00 pm, oven holds 3 dishes at once. The turkey (325°F, 3.5 hours, 45-minute rest) goes in at 11:30 am and comes out at 3:00 pm. That rest period is the trick: the oven is free from 3:00 to 3:45, while the bird stays hot under foil. The casseroles and rolls all fit in that window if their temperatures are aligned. The one-oven schedule walkthrough shows the full eight-dish timeline, with the clash caught and fixed.
The Countdown Checklist (Copy This)
This is the sequence that keeps a 20-plus-person dinner from becoming a last-week scramble. Paste it into a sheet and add a Do by date and a Done? column.
| When | Task |
|---|---|
| 4 weeks out | Set the guest list, send invitations, ask about dietary needs |
| 3 weeks out | Book rentals (tables, chairs, linens, chafing dishes); order or reserve the turkey |
| 2 weeks out | Confirm final headcount; finalize the menu and assign potluck dishes |
| 1 week out | Big shop: dry goods, drinks, canned goods, serveware; freeze what can freeze |
| 5–6 days out | Start thawing a frozen ~22 lb turkey in the refrigerator (roughly 24 hours per 4–5 lb) |
| 2 days out | Fresh shop: produce, dairy, bread; make cranberry sauce |
| Day before | Bake pies; assemble casseroles and stuffing; set the table; chill drinks |
| Event day | Follow the oven timeline backwards from the serving time |
| Day after | Fill in what ran out and what nobody touched, for next year |
That last row is the one hosts skip and later regret. A post-event notes tab, where you record “20 lb was right for 23; double the stuffing,” is what makes next year easier.
Common Mistakes When Planning a Large Thanksgiving
- Counting Maybes as Yeses. Your budget and shopping list quietly balloon.
- Budgeting only the food. The all-in cost is often more than double the grocery bill per guest.
- No plan for the oven. The cooking is fine. The schedule is what fails.
- Assigning categories loosely. “Bring a side” gets you four green bean casseroles.
- Forgetting the thaw. A frozen 22 lb bird can need five to six days in the refrigerator.
- Skipping the notes. You will not remember next November that the ham barely got touched.
Build It Yourself or Start From a Finished File?
You can absolutely build this from scratch. Every formula in the five jobs above is standard: SUMIF, division, ROUNDUP, and time subtraction. Budget an evening or two, mostly for the oven timeline, which is the fiddliest.
If you would rather open a file where it is already done, the Thanksgiving & Holiday Hosting Planner has all five jobs wired together across 11 tabs with a full sample dinner loaded. It flags temperature clashes and over-capacity moments on the timeline, solves cost per head in both directions, and rescales the shopping list to confirmed guests. It also reuses for Christmas dinner, New Year’s Eve and Easter.
Either way, the principle is the same: a Thanksgiving is a small logistics project, and logistics projects go better in a spreadsheet than in your head.
Read Next in This Series
- How to schedule Thanksgiving dinner with one oven: the full worked timeline
- How much does Thanksgiving dinner cost per person?: fixed versus per-head costs, at 12 to 32 guests
- Thanksgiving potluck sign-up spreadsheet: assign dishes so nothing doubles
- How much Thanksgiving food for 20 people: turkey, sides and dessert quantities
Featured on ReadySheetGo
Thanksgiving & Holiday Hosting Planner Spreadsheet — $14.99
11 tabs and 1,531 live formulas, with a full sample Thanksgiving for 23 guests already loaded so you can see it working before you type anything. A Cooking Timeline that works backwards from your serving time and flags every TEMP CLASH and every moment the oven holds more than it fits. A Cost Per Head tab that solves both directions: cost per guest, and how many guests your budget can feed. A Shopping List that rescales to the guests who said Yes. Plus a Guest List with dietary and allergy flags, Menu Builder, Seating Plan, Rentals & Decor, Other Events and Post-Event Notes.
Works in Excel and Google Sheets. No macros, no add-ons.
Get the Thanksgiving Hosting Planner →
Frequently Asked Questions
What should a Thanksgiving planner spreadsheet include?
At minimum: a guest list that counts only confirmed Yes RSVPs, a menu with who is making each dish, a cost-per-person calculation, a shopping list scaled to your real headcount, and a cooking timeline that shows when each dish uses the oven. The last one is the piece most planners skip, and it is the piece that prevents the 3:10 pm panic when two dishes need different temperatures at once.
How far ahead should you start planning Thanksgiving dinner?
Four weeks out is a comfortable start for a group of 15 to 25: set the guest list and send invitations, then book any rentals and order or reserve the turkey around three weeks out. Confirm headcount and finalize the menu two weeks out, do the non-perishable shop one week out, and start thawing a frozen turkey five to six days out for a bird around 22 pounds (allow roughly 24 hours per 4 to 5 pounds in the refrigerator).
How do you plan Thanksgiving dinner when you only have one oven?
Work backwards from the serving time, and use the turkey's rest period. A large turkey rests 30 to 45 minutes after it comes out, which frees the oven for casseroles and rolls. Move anything that can be served warm or reheated to the day before, bake pies on Wednesday, and move any dish that needs a very different temperature to the stovetop or slow cooker. Then check your plan for moments when more dishes are in the oven than physically fit.
Can you use Google Sheets for a Thanksgiving planner?
Yes. Everything in a planner like this is ordinary spreadsheet arithmetic: SUMIF for confirmed headcount, division for cost per guest, and time subtraction for the oven timeline. It works in Excel and Google Sheets. If you buy a ready-made one as an Excel file, uploading it to Google Drive and opening it with Google Sheets keeps the formulas.