Thanksgiving Potluck Sign-Up Spreadsheet: Assign Dishes So Nothing Doubles
Twelve people said they would bring something, and you already know how this ends: four green bean casseroles, no rolls, and nobody remembers who promised the pie.
A potluck does not fail because people are careless. It fails because the sign-up lives in a group chat, where claims scroll away and nobody can see the whole menu at once. The fix is one shared sheet with four rules built in. Here is the layout, the rules and a worked example.
The Sign-Up Sheet Layout (Copy This)
| # | Column | Example |
|---|---|---|
| 1 | Dish | Mac and cheese |
| 2 | Course | Side |
| 3 | Brought by | Danielle |
| 4 | Serves | 15 |
| 5 | Confirmed? | Yes |
| 6 | Needs | Oven, 30 min at 350°F |
| 7 | Dietary note | Vegetarian |
| 8 | Duplicate? | formula |
The two columns people leave out are Confirmed? and Needs. Confirmed separates a real dish from a good intention. Needs is what connects the potluck to your oven timeline: a guest bringing a casserole that needs 30 minutes at 350°F is a dish competing for your oven at 3:15, not just a dish on a table.
Rule 1: Claim a Category Before a Dish
“What are you bringing?” gets you four green bean casseroles. “Which slot do you want?” does not.
Publish the slots first, then let guests fill them:
- Appetizers (2 to 3 slots)
- Vegetable sides (3 slots)
- Starch or casserole sides (2 slots)
- Bread (1 slot)
- Desserts (3 slots)
- Drinks (1 to 2 slots)
The host holds the turkey, gravy and stuffing, because those are tied to the oven and the schedule. A guest picks “vegetable side” and then names the dish. Duplicates almost disappear, because the slot is taken before the recipe is decided.
Rule 2: Only Confirmed Dishes Count Toward Coverage
Add a coverage check per course:
Coverage = total servings of confirmed dishes in the course ÷ confirmed guests
Then apply rule-of-thumb targets. These are planning guides, not laws, so adjust for your crowd:
| Course | Target servings per guest |
|---|---|
| Appetizer | about 1 |
| Main | about 1 or more (higher for leftovers) |
| Sides (all together) | 3 or more |
| Dessert | about 1 |
| Bread | 1 to 2 rolls |
The Worked Example: 20 Guests
Twenty confirmed guests. The host is doing the turkey (serves 16) and gravy. Here is the sign-up after two days of claims:
| Dish | Course | Brought by | Serves | Confirmed? |
|---|---|---|---|---|
| Roast turkey | Main | Host | 16 | Yes |
| Honey-glazed ham | Main | Sarah | 12 | Yes |
| Green bean casserole | Side | Judy | 12 | Yes |
| Green bean casserole | Side | Ben | 10 | Yes |
| Sweet potato casserole | Side | Rob | 14 | Yes |
| Mac and cheese | Side | Danielle | 15 | Pending |
| Dinner rolls | Bread | Danielle | 24 | Pending |
| Charcuterie board | Appetizer | Kevin | 20 | Yes |
| Pumpkin pie | Dessert | Carol | 16 | Yes |
| Pecan pie | Dessert | Ben | 12 | Pending |
Run the checks on confirmed dishes only:
- Mains: 16 + 12 = 28 servings ÷ 20 = 1.40 per guest. Fine.
- Sides: 12 + 10 + 14 = 36 ÷ 20 = 1.80 per guest. Below the 3-plus target, so it needs more sides. Mac and cheese is still pending, and it would only bring it to 2.55.
- Bread: 0 confirmed servings. Rolls are still pending, so bread is uncovered.
- Appetizers: 20 ÷ 20 = 1.00. Fine.
- Desserts: 16 confirmed ÷ 20 = 0.80. Pecan pie is pending; it would lift it to 1.40.
- Duplicate: two green bean casseroles from Judy and Ben.
That is one glance at the sheet and four specific actions: nudge Danielle to confirm the mac and cheese and rolls, confirm Ben’s pecan pie, add two more vegetable or starch sides, and ask Ben to swap his green bean casserole for something else (or accept the doubling on purpose). Group-chat sign-ups cannot do that.
Rule 3: Ask What Each Dish Needs
Before you finalize, ask every guest three questions, and write the answers in the Needs column:
- Does it need the oven when it arrives (reheating or baking)? At what temperature?
- Does it need fridge space before serving?
- Does it need a plug (slow cooker, warming tray)?
If three guests each arrive with a dish that needs the oven at a different temperature, you have created the oven conflict yourself. The one-oven Thanksgiving timeline shows how to fit reheating dishes into the window while the turkey rests. Ask guests to bring dishes ready to serve at room temperature, or in a slow cooker, whenever they can.
Rule 4: Set a Deadline and a Change Rule
Announce a “final dishes” date, two weeks out, and one rule: changes go in the sheet, not the chat. If someone drops out, they clear their row, and a red “uncovered course” flag appears again for you to fill.
Add dietary notes here as well. If a guest has a severe allergy, ask everyone to label ingredients, especially nuts, dairy and gluten, and mark the safe dishes in the sheet.
What to Do With the Sheet on the Day
Print it. Put the printout on the counter with the serving order. Cross off dishes as they arrive. On the day after, note what ran out and what nobody touched. The 20 servings of mashed potatoes may have been plenty; the pecan pie may not have been. Next year’s sign-up should learn from it.
DIY Sheet or a Ready-Made One?
The layout above is easy to build in an evening in Excel or Google Sheets: a table, a SUMIF per course and a COUNTIF for duplicates. If you would rather start from a finished version, the Menu Builder tab in the Thanksgiving & Holiday Hosting Planner tracks every dish, who provides it (host or guest), whether it is confirmed, whether each course covers the room, and flags duplicates. It also shows what share of the meal the host is paying for versus what guests are bringing.
To see how the sign-up fits with the guest list, budget and oven plan, read the full Thanksgiving dinner planner guide.
Featured on ReadySheetGo
Thanksgiving & Holiday Hosting Planner Spreadsheet — $14.99
A Menu Builder tracking every dish, who is bringing it and whether it is confirmed, with per-course coverage and a duplicate flag, plus a Guest List with dietary needs and allergy severity, a Cooking Timeline that fits your potluck dishes into the oven, and a Cost Per Head tab showing how much of the meal guests cover.
11 tabs, 1,531 live formulas, and a full sample Thanksgiving for 23 guests already loaded. Works in Excel and Google Sheets. No macros, no add-ons.
Get the Thanksgiving Hosting Planner →
Frequently Asked Questions
How do you organize a Thanksgiving potluck so nobody brings the same dish?
Assign by category before dish. Ask each guest to claim a slot such as 'a vegetable side' or 'a dessert' and then name the dish, and put the whole list in one shared sheet where everyone can see the claims as they are made. Add a duplicate check so a second sweet potato casserole is flagged the moment it is typed.
What columns should a potluck sign-up sheet have?
Dish, course, who is bringing it, servings it makes, confirmed or pending, whether it needs oven or fridge space or reheating on site, and dietary notes such as gluten-free or contains nuts. The confirmed column matters most: a promised dish is not a delivered dish, and unconfirmed dishes should not count toward coverage.
How many dishes do you need per guest for a Thanksgiving potluck?
There is no fixed rule, but a workable planning check is servings per guest by course: aim for about one serving of a main per guest (more if you want leftovers), three or more servings of sides in total, and about one serving of dessert per guest. Treat those as rules of thumb and adjust to your crowd.
Should the host cook the turkey at a Thanksgiving potluck?
Most hosts do, because the turkey ties up the oven and the schedule and is easiest to control in one kitchen. Guests are then assigned sides, desserts, drinks, rolls and appetizers. Ask guests what needs the oven or reheating so you can fit it into the timeline.