Google Sheet Wedding Guest List: The Copy-Ready Build
Key takeaways
- Structure your sheet with three tabs: a Guest List master record, an RSVP Tracker, and a Meal Counts tab, all sharing a single Guest ID in column A.
- Include twelve core columns on the master tab, making sure to track Headcount separately so one invitation row accurately reflects three attendees.
- Use data validation dropdowns for RSVP status and meal choices to prevent typos that break COUNTIF and SUMIF formulas.
- Group guests by Household ID so invitations and RSVPs update as one unit instead of scattered rows.
- Switch to dedicated seating software once you exceed 150 guests or have difficult pairs, since spreadsheets cannot draw rooms or enforce seating rules.
Build your google sheet wedding guest list as three tabs: Guests (one row per invitation with household, RSVP status, meal choice, and plus-one count), Rollups (COUNTIF totals for attending, declines, and each meal), and Seating (a per-table roster you fill once RSVPs close). This article gives you the exact columns and formulas, and the honest point where 150+ guests with difficult pairs outgrow the sheet.
What columns should a wedding guest list Google Sheet include?
The 12 core columns
Your master tab needs twelve columns, and each one earns its place:
| Column | Purpose |
|---|---|
| Guest ID | Unique number per person, so "Sarah 2" never breaks a formula |
| Household | Groups invitations and RSVPs that arrive together |
| First name / Last name | Separate columns, or sorting breaks |
| Side | Partner 1, Partner 2, or Both |
| Relationship | How you know them, useful when seating politics start |
| Address | For invites and thank-yous |
| Invite sent | Date |
| RSVP status | Invited / Confirmed / Declined / No reply |
| Headcount | Actual people attending, not invited |
| Meal choice | Chicken / Beef / Veg / Kids |
| Notes | Difficult pairs, plus-ones in flux, high chairs |
The Headcount column is the one couples skip and regret. An invitation for "Mr and Mrs Alvarez plus guest" is one row in your head and three people at a table.
Columns that save you at RSVP time
Two optional columns pay for themselves: Table (assigned later, kept here so the list stays the single source of truth) and Kids meal as its own flag, since children's counts rarely match adult meal totals.
Counting formulas run off these columns directly. The syntax for counting confirmed guests, for example, is a plain =COUNTIF(H:H,"Confirmed"), documented in the Google Docs Editors Help COUNTIF guide. Get the columns right now and every later section builds on them. More tab structures and worked formulas live on the SeatingSorted blog.
How do you structure the tabs so one sheet does three jobs?
Three tabs, one file, one guest ID shared across all of them. Column A on every tab is the same Guest ID number, so a row on the RSVP Tracker always points back to the right person on the Guest List.
Tab 1: Guest List
This is the master record and the only tab you type names into. Columns: Guest ID, First Name, Last Name, Household, Side (partner 1 or 2), Known-Difficult Pairs, and Notes. The Household column is what keeps invitations and seating grouped later.
Tab 2: RSVP Tracker
One row per Guest ID, not per household, so a plus-one saying no doesn't sink the whole family. Columns: RSVP Status (Yes/No/Pending), Date Responded, Plus-One Status, and Kids Needing an Adult. Filter this tab when six people drop out and two add a plus-one.
Tab 3: Meal Counts
Columns: Guest ID, Meal Choice, Dietary Restrictions, and Kids' Meal. Never type totals here by hand; the formulas section covers counting automatically.
Keep seating out of this file entirely. A chart is a different job, and mixing it in is how the "Where did I put Sarah?" problem starts — see Do you need a wedding seating chart? An honest answer.
How do you split guests into households so invitations stay grouped?
Why household grouping matters for invitations and counts
A couple invited together is one invitation, one RSVP, and one meal count per person but one seat-adjacency decision. If you track guests as flat rows, you will invite "Mr and Mrs Patel" and then wonder why their daughter got a separate card, or count a plus-one who was never confirmed. Grouping by household fixes the "six people have dropped out, two have added a plus-one" problem, because you update one unit instead of hunting scattered rows.
How to assign household IDs without mistakes
Add a Household ID column and use a simple convention: H01, H02, sorted by host-side then partner-side, so divorced parents get separate IDs on purpose. Add a Household Type dropdown (Couple, Family, Single, Single + plus-one) built with a dropdown column in Google Sheets. Every guest row inherits its household's ID; RSVP status is set at household level, meal choices at guest level.
When households and tables start interacting, that is where a dedicated seating chart earns its keep.
How do you track RSVPs and meal choices in the same sheet?
Dropdowns that prevent typos
Select the RSVP status column, then go to Data > Data validation and add a dropdown with exactly three options: Yes, No, and Pending. Do the same for meal choice with your caterer's actual menu items, spelled the way the kitchen needs them. This is what turns a spreadsheet into an RSVP tracker: every reply is one click, and "Chicken" never becomes "chicken dinner" in a cell that your count formula then ignores.
Add a plus-one status column with its own dropdown (Confirmed, Maybe, No plus-one) so guests in flux stay visible without a second sheet.
Flagging missing RSVPs with conditional formatting
Select the RSVP column, then Format > Conditional formatting. Add a rule where the cell text is "Pending" and set the fill to red. Add a second rule where the cell is empty, filled yellow, so blank cells stand out from genuine non-replies. A third rule turning "No" green-ish grey makes declines easy to spot without reading.
After the RSVP deadline, sort by the RSVP column: every red and yellow row at the top is your chase list. Meal totals come next (see the formulas section), but they only work if every cell is a clean dropdown value, not free text. If chasing gets ugly and the seating itself starts moving people around, tools like SeatingSorted handle the chair-level work — our comparison runs the options side by side.
Which formulas count guests, declines, and meal totals automatically?
Headcount and decline formulas
Put a Status column (Confirmed / Declined / Pending) on your RSVPs tab, then count with COUNTIF:
- Total confirmed guests:
=COUNTIF(Status, "Confirmed") - Declines:
=COUNTIF(Status, "Declined") - Still waiting on:
=COUNTIF(Status, "Pending")
If your Status data lives in column F on a tab called RSVPs, write it as =COUNTIF(RSVPs!F:F, "Confirmed"). Swap the word for whatever you named the column. These three numbers are the ones you will check daily for the last six weeks, so pin them to a small Dashboard tab using those same references.
Meal count formulas
Meal totals use SUMIF against a numeric Guests column. If meals are listed in column G and headcount in column H on RSVPs:
- Chicken:
=SUMIF(RSVPs!G:G, "Chicken", RSVPs!H:H) - Fish:
=SUMIF(RSVPs!G:G, "Fish", RSVPs!H:H) - Vegetarian:
=SUMIF(RSVPs!G:G, "Vegetarian", RSVPs!H:H)
One catch worth quoting on its own: SUMIF matches text exactly, so "Veg", "Vegetarian", and "veggie" are three different meals to the formula, and your caterer's count will be quietly wrong in nine places. Pick one spelling per meal, use data validation with a dropdown list on the meal column so nobody free-types a variant, and the totals stay honest. If you inherit a messy column, clean it once with find-and-replace before trusting any SUMIF.
Plus-one and child counts
Add a Type column (Adult / Child / Plus-one) and count the same way: =COUNTIF(RSVPs!D:D, "Plus-one") and =COUNTIF(RSVPs!D:D, "Child"). Children needing an adult at a table are easier to track when they carry their own label rather than hiding inside a household total. These counts feed directly into the seat totals you will need once RSVPs close and the seating work begins; our comparison of free wedding website seating tools covers what happens next.
How do you share the sheet with a partner and wedding planner without version chaos?
Who gets edit access and who doesn't
Share with edit access only to people making changes: your partner, and a planner or day-of coordinator if you have one. Everyone else (parents offering to help, for example) gets comment-only or view-only access. A parent "tidying" your guest list while you sleep is how rows vanish. In Google Sheets, use Share > General access > Restricted, then add named people individually so you can revoke access after the wedding.
Protecting the formula cells
Select the ranges holding your formulas and counts, then right-click > Protect range. Set it to "Only you" so a stray keystroke can't wipe the meal totals the week before RSVPs close. Pair this with a "Last edited by" and "Notes" column on the Guest List tab: whoever changes an RSVP logs it there, so when six people drop out and two add plus-ones, you can see what moved and when. You can also use conditional formatting to flag unconfirmed guests automatically, following Google's Docs Editors Help documentation.
When is a Google Sheet guest list no longer enough and you need seating software?
What the sheet does well
Up to roughly 100-150 guests, the sheet is the right tool. It tracks RSVPs, meals, and household grouping cleanly, and it answers "where did I put Sarah?" with a Ctrl+F. Keep using it for the data layer even after you outgrow it for seating.
Where it breaks: the seating step
The sheet tracks guests; it cannot draw the room. Seating is a social problem wearing a logistics costume, and drag-and-drop in a spreadsheet means cutting cells and pasting them, one wrong move rippling wrong in nine places. Difficult pairs have no guardrail: nothing stops you seating the divorced parents at table 4 until you notice. Every last-minute swap, six dropouts and two added plus-ones, becomes manual surgery.
Running SeatingSorted through the same test
SeatingSorted takes the guest list you already built and builds the plan: draw the room, collect replies, set the few rules that matter, and it handles the chair-by-chair placement while you stay in control of every chair. Where it falls short: it will not replace your sheet as an RSVP and meal tracker, and for one event with 60 guests and no difficult pairs, the spreadsheet alone is honestly enough.
FAQ
How do I make a wedding guest list in Google Sheets?
Start with one master tab and twelve columns: Guest ID, Household, separate first and last name columns, Side, Relationship, Address, Invite sent, RSVP status, Headcount, Meal choice, and Notes. Give every person a unique Guest ID so lookups never break. Keep the Headcount column because one invitation row often means three attendees.
What is the best Google Sheets template for a wedding guest list?
Skip a downloaded template and build three tabs in one file: a Guest List as the master record, an RSVP Tracker with one row per Guest ID, and a Meal Counts tab driven by formulas. Share the same Guest ID in column A across all three tabs so every row points back to the right person without manual matching.
How do I count RSVPs automatically in Google Sheets?
Use COUNTIF against your status column. Confirmed guests are =COUNTIF(RSVPs!F:F, "Confirmed"), with the same pattern for Declined and Pending. Pin those three numbers to a small Dashboard tab, since you will check them daily in the final weeks. Data validation dropdowns on the status column keep the counts honest by preventing typos.
Can I track meal choices in the same sheet as my guest list?
Yes. Add a meal choice column with a dropdown matching your caterer's exact menu wording, then total each option with SUMIF against your headcount column, for example =SUMIF(RSVPs!G:G, "Chicken", RSVPs!H:H). SUMIF matches text exactly, so "Veg" and "Vegetarian" count separately. One spelling per meal, enforced by the dropdown, keeps totals correct.
How do I group families together on a wedding guest list spreadsheet?
Add a Household ID column using a simple convention like H01, H02, and a Household Type dropdown (Couple, Family, Single, Single plus one). Every guest row inherits its household's ID, so invitations and RSVPs update one unit instead of scattered rows. Give divorced parents separate IDs deliberately, and set RSVP status at household level while meals stay per guest.