Wedding Guest List Spreadsheet: RSVPs, Meal Choices, Seating and Thank-You Notes
Set up a wedding guest list spreadsheet with one row per guest: A and B lists, plus-ones, invitations sent, RSVPs, meal choices and dietary needs, table assignments, gifts and thank-you notes, with the counts your venue and caterer need.
A wedding guest list spreadsheet works best with one row per person, not per household, plus columns for which side and group they belong to, whether the invitation went out, their RSVP, meal choice, table and, after the wedding, the gift and thank-you note. With that structure a few formulas give you the live headcount for the venue, the meal counts for the caterer, the empty seats at each table and the thank-you notes still to write. Here is how to set it up in Excel or Google Sheets.
One row per guest, one code per invitation
Writing “The Johnsons (4)” on one row is fine for addressing envelopes but useless for counting meals, kids or seats. Give each person their own row and add an Invitation ID shared by everyone on the same invitation. Filter by Invitation ID when you send invitations, count rows when you talk to the caterer.
Columns to include
| Column | Values | Used for |
|---|---|---|
| Guest name | Text | Escort cards, lists |
| Invitation ID | Shared code per invitation | Mailing and grouping households |
| Mailing address | Text (first row of each invitation) | Save-the-dates and invitations |
| Side | Partner 1, Partner 2, both | Balancing the list |
| Group | Family, college friends, work… | Seating |
| List | A or B | Second-round invitations if the A list declines |
| Guest type | Adult, child, infant, plus-one | Meal pricing and seating |
| Invitation sent | Date | Tracking mailings |
| RSVP | Pending, Yes, No | Headcount |
| Meal and dietary needs | Entrée choice, allergies | Caterer list |
| Table | Table number | Seating chart |
| Gift and thank-you sent | Description, date | After the wedding |
Turn the range into a Table and use drop-down lists for Side, List, Guest type, RSVP and Meal so counts never break on a typo.
The counts that matter
- Total invited:
=ROWS(Guests[Guest name]) - Attending adults:
=COUNTIFS(Guests[RSVP],"Yes",Guests[Guest type],"<>Child",Guests[Guest type],"<>Infant") - Attending children:
=COUNTIFS(Guests[RSVP],"Yes",Guests[Guest type],"Child") - Still pending:
=COUNTIF(Guests[RSVP],"Pending") - Meals by choice:
=COUNTIFS(Guests[RSVP],"Yes",Guests[Meal],"Chicken"), and so on for each entrée - Thank-you notes left:
=COUNTIFS(Guests[Gift],"<>",Guests[Thank-you sent],"")
Before invitations go out, compare A-list adults against the venue’s capacity. If the A list alone fills the room, trim it now rather than after people have heard about the wedding.
RSVP timeline
- Save-the-dates usually go out several months ahead, earlier for destination weddings or holiday dates.
- Invitations typically follow six to eight weeks before the date.
- Set the RSVP deadline a week or two before your caterer’s final headcount deadline, leaving time to chase late replies.
- If you use a wedding website or online form, export responses and match them to the list with XLOOKUP on the guest name or Invitation ID.
Seating chart
On a second tab, list tables with their capacity and calculate seats taken:
=COUNTIFS(Guests[Table],A2,Guests[RSVP],"Yes") and =B2-C2 for seats left.
Color negative values red. Seat each invitation together, group by friend circle, keep immediate family near the couple, and plan high chairs or a kids’ table if needed. A PivotTable with Table in rows and Guest name in values doubles as the list you hand to the venue.
Example: six weeks out
| Count | Number |
|---|---|
| Guests invited | 142 |
| Yes (adults / children) | 96 / 6 |
| No | 15 |
| Pending | 25 |
| Meals confirmed: chicken / fish / vegetarian | 44 / 31 / 21 |
| Tables of 10 full | 7 of 12 |
Twenty-five pending replies is the week’s task: a short call or message to each household. The caterer gets the meal counts straight from the summary.
Connect it to the budget
Per-person catering and rentals are the costs most tied to the list. In the wedding budget spreadsheet, multiply the confirmed adult and child counts by their per-person prices so every RSVP updates the budget. For the wider timeline of tasks and vendors, see the event planning checklist. More planners are in Event & Wedding Planning.
Privacy
Addresses, phone numbers and dietary or allergy details are personal, and allergy information is health-related. Share the sheet only with the people planning, give the caterer only what they need, and delete sensitive columns after the wedding.
Frequently asked questions
How do I handle plus-ones without names?
Add a row “Guest of [name]” with the same Invitation ID and replace it with the real name when you learn it.
Should children be counted separately?
Yes. Many venues and caterers price children’s meals differently and need separate counts for seating and high chairs.
Excel or Google Sheets?
Google Sheets is easier when both partners and family members update the list or when RSVPs come from an online form. Excel works well if one person manages it.
How do I print escort cards or place cards?
Sort by table and name, then use Word’s mail merge with the guest sheet as the data source.
