Wedding Guest List Spreadsheet: Track RSVPs Without Losing Your Mind
Looking for a tool?
Every other wedding decision hangs off the guest list: the venue needs a headcount, the caterer needs meal counts, the budget needs both. Which is why the guest list can't live in your head, a notes app, and three text threads at once. Here's the spreadsheet that keeps it straight.
The columns that matter
- Name — one row per person, not per household (meal counts depend on it)
- Party / household — for invitations and addressing
- Side — helpful for balancing and thank-you duty later
- Invite sent? · RSVP status — Pending / Yes / No
- Meal choice — dropdown: beef / fish / veg / kids
- Plus-one? — and the plus-one gets their own row once named
- Notes — allergies, seating constraints, "traveling from overseas"
The two numbers you'll be asked for constantly
Confirmed headcount — =COUNTIF(RSVP,"Yes") — and meal
counts — =COUNTIFS(RSVP,"Yes",Meal,"Fish"). With those live, the venue call and
the caterer email become read-offs instead of recounts.
Working the pending list
Around 2–3 weeks before the RSVP deadline, filter to Pending and start friendly nudges. Expect 10–20% of guests to need one — it's normal, plan the time for it. A tracker that surfaces "Pending" as its own count turns chasing RSVPs from a guilt spiral into a checklist.
A realistic attrition note
Planners commonly see roughly 10–20% declines, higher for travel-heavy lists. Don't invite 150 assuming 150 — but don't over-invite banking on declines you can't afford either. Watch your live "Yes" count against your venue cap as responses come in.
One list, one owner
Decide who owns the spreadsheet (you, partner, planner) and let everyone else suggest changes. Duplicate half-updated copies are how cousins end up without a chair.
Got the guest count? The other half is the money — see how to make a wedding budget spreadsheet that tracks every deposit and balance. Planning a shower too? There's a Baby & Bridal Shower Planner with budget and checklist built in.
Quick FAQ
How do I make a wedding guest list spreadsheet?
Use one row per person (not per household, so meal counts stay accurate) with columns for party, side, invite sent, RSVP status, meal choice, plus-one, and notes. Then two formulas — =COUNTIF(RSVP,"Yes") for headcount and =COUNTIFS(RSVP,"Yes",Meal,"Fish") for meal counts — turn the venue and caterer questions into instant read-offs.
How do I track RSVPs without losing track?
Keep a single RSVP status column (Pending / Yes / No) and, about 2–3 weeks before your deadline, filter to Pending and send friendly nudges. Expect 10–20% of guests to need one — a tracker that surfaces "Pending" as its own count makes chasing them a checklist instead of a guilt spiral.
How many guests will decline?
Planners commonly see roughly 10–20% declines, higher for travel-heavy lists. Don't invite 150 assuming 150 will come — but don't over-invite banking on declines you can't afford either. Watch your live "Yes" count against your venue cap as responses arrive.