Wedding Guest List Template with RSVP Tracking

A wedding guest list starts as names scribbled in a notes app, then grows into addresses texted by a mother-in-law, RSVPs arriving by text and email, a caterer asking for meal counts, and a seating chart that depends on all of it. A wedding guest list template keeps all of that in one sheet, one row per household, so every later question (who still hasn't replied, how many vegetarian meals, who sits at table 6) has an answer in a single place.

Direct answer. A good wedding guest list template has one row per household and columns for envelope name, guest names, side, tier (must, should, nice to have), party size, plus-one, address, contact, save-the-date sent, invite sent, RSVP status, meal choice, dietary notes, table number, gift received and thank-you sent.

The wedding guest list template: every column and its format

Here is the full column set. The format column matters: dropdowns keep RSVP and meal values consistent so you can filter and count them later, and checkboxes make the "did we send it?" columns quick to scan.

Column	What goes in it	Format
Household	The envelope name, e.g. "Mr. and Mrs. Daniel Rossi"	Text
Guest names	Every person invited in this household	Text
Side	Whose guest this is	Dropdown: Couple A / Couple B / Shared
Tier	How essential the invitation is	Dropdown: A - Must / B - Should / C - Nice to have
Party size	Number of people invited in this row	Number
Plus-one	Whether a named or unnamed guest is allowed	Checkbox
Mailing address	Full street address for paper invitations	Text
Email / phone	Best contact for reminders and RSVP chasing	Text
Save-the-date sent	Mailed or emailed	Checkbox
Invite sent	Formal invitation sent	Checkbox
RSVP	Current reply	Dropdown: Pending / Attending / Declined
Attending count	How many from this household are coming	Number
Meal choice	Entree for each attending guest	Dropdown: Beef / Fish / Vegetarian / Kids
Dietary notes	Allergies and restrictions	Text
Table	Table number for the seating chart	Number
Gift received	Gift logged, with what it was in the notes	Checkbox
Thank-you sent	Card mailed	Checkbox

Two columns are easy to skip and painful to add later. "Attending count" is separate from "Party size" because a family of four often replies with three. "Gift received" lives in the same sheet as the guest names, so the thank-you list builds itself as gifts arrive.

Copy the guest list template as CSV

Paste this into Google Sheets (Edit, Paste), or save it as a .csv file and open it in Excel or Numbers. The four sample rows show how a couple, a family, a single guest with a plus-one and a B-list name look once filled in.

Household,Guest names,Side,Tier,Party size,Plus-one,Mailing address,Email / phone,Save-the-date sent,Invite sent,RSVP,Attending count,Meal choice,Dietary notes,Table,Gift received,Thank-you sent
"Mr. and Mrs. Daniel Rossi","Daniel Rossi; Maria Rossi",Couple A,A - Must,2,FALSE,"14 Elm Street, Portland, OR 97205",[email protected],TRUE,TRUE,Attending,2,"Beef; Fish",,3,TRUE,FALSE
"The Okafor Family","Chidi Okafor; Ngozi Okafor; Ada Okafor; Tobi Okafor",Couple B,A - Must,4,FALSE,"88 Harbor Road, Oakland, CA 94607",(510) 555-0142,TRUE,TRUE,Attending,3,"Fish; Vegetarian; Kids",Ada: nut allergy,5,FALSE,FALSE
"Ms. Priya Nair and Guest","Priya Nair",Shared,B - Should,2,TRUE,"301 Lake Ave Apt 4B, Chicago, IL 60601",[email protected],TRUE,TRUE,Pending,,,,,FALSE,FALSE
"Mr. Tom Becker","Tom Becker",Couple A,C - Nice to have,1,FALSE,"9 Cedar Lane, Boise, ID 83702",[email protected],FALSE,FALSE,Pending,,,,,FALSE,FALSE

After pasting, turn the RSVP, Side, Tier and Meal columns into dropdowns (Data validation in Excel and Google Sheets) so nobody types "attending" in one row and "yes" in the next. Two formulas cover most of the counting: =SUMIF(K:K,"Attending",L:L) gives the confirmed headcount, and =COUNTIF(K:K,"Pending") shows how many households still owe you a reply.

Build the formatted version with one prompt

If you'd rather start from a finished, styled sheet, paste this prompt into Playyy's AI spreadsheet generator:

Create a wedding guest list sheet with one row per household. Columns: Household (text), Guest names (text), Side (dropdown: Couple A, Couple B, Shared, each a different soft color), Tier (dropdown: A - Must in green, B - Should in yellow, C - Nice to have in gray), Party size (number), Plus-one (checkbox), Mailing address (text, wide column), Email / phone (text), Save-the-date sent (checkbox), Invite sent (checkbox), RSVP (dropdown: Pending in gray, Attending in green, Declined in red), Attending count (number), Meal choice (dropdown: Beef, Fish, Vegetarian, Kids), Dietary notes (text), Table (number), Gift received (checkbox), Thank-you sent (checkbox). Bold header row, columns sized to fit, and 6 realistic sample households. Add a second tab called "Tables" with Table number, Guests seated and Notes.

The agent builds both tabs with the dropdown colors, checkboxes and column widths in place. From there you edit by chat ("add a column for hotel block", "move Table next to Meal choice") or ask questions about the data, such as which households are still pending on the Couple B side. When the list is final, export it as Excel (.xlsx) or CSV for the caterer or planner. Each sheet holds up to 1,000 rows, which covers even very large weddings, and the Playyy agent can work out totals such as confirmed guests per meal from the data and write them in as values.

How to structure a wedding guest list (and cut it down)

Most couples build the list in the wrong order: names first, then a number, then a painful cut. Start from the number instead.

1. Set the ceiling. Your venue capacity and catering budget set the maximum headcount. Zola's planning guide says planners expect 25 to 40 percent of invited guests to decline, so 200 invitations typically turns into 120 to 150 people in the room. Work backwards from your ceiling to an invitation count.

2. Brain-dump everyone, one row per household. Both of you, plus each set of parents, add names without filtering. Fill in the Side column as you go so the split stays visible.

3. Tier every row. This is the A/B/C list method. A is people the day would feel wrong without: immediate family, closest friends, the wedding party. B is people you'd genuinely like there: extended family, close colleagues, friends you see regularly. C is everyone else you feel you should invite.

4. Cut by tier, not by person. If the A and B lists already exceed your invitation count, C goes entirely, and then you apply one rule across the whole B list (no coworkers, no plus-ones for guests who aren't in a relationship, no children except family). A blanket rule is easier to explain than individual cuts, and it applies to both sides equally.

5. Keep the B list as a second wave. Send A invitations first. As declines come in, filter by Tier = B and send replacements in the order you ranked them, early enough that they don't feel like an afterthought.

The Side column is useful during cuts too. Filter by side and count rows: if one side has 90 households and the other 40, that's a conversation to have before invitations go out, not after.

Tracking RSVPs, meals and seating in the same sheet

Once invitations are out, the guest list becomes an RSVP tracker. A weekly routine keeps it accurate:

• Log every reply the day it arrives, whatever the channel. Set RSVP, then fill Attending count and Meal choice in the same pass.
• Filter RSVP = Pending a week before the deadline and send a short reminder to each household. The Email / phone column exists for exactly this.
• Read the dietary notes before you send the caterer your counts. A nut allergy belongs in the caterer's notes, not only in your sheet.
• Assign tables only to Attending rows. Sort by Side, then by Tier, and the natural groupings (college friends, cousins, work) usually fall out of the list.
• Check off gifts on the day you open them, and add a two-word description of the gift in a notes column so the thank-you card can name it.

A common mistake is tracking RSVPs in a second file, or in the replies of a group chat. The moment counts live in two places, they drift, and the caterer gets a number that's off by four.

Collecting RSVPs online with a wedding website

Paper reply cards still work, and an online RSVP on a simple wedding website saves chasing replies by text. In Playyy, describe the page you want (welcome message, date and venue, travel notes, and an RSVP form with name, email, attending, number of guests, meal choice and a dietary notes field) and the AI builds the page and the form together. Form fields can be text, email, number, long text, single choice, multiple choice or dropdown, which covers every RSVP question above. Publish the site to a shareable link and, if you like, protect it with a password so only invited guests see it.

Replies collect in the form's Responses panel, where you can download them as CSV. One click copies them into a linked guest list sheet in the same file, and pressing Refresh pulls in RSVPs that arrived since. The invitations can come from the same place: make a matching crest with the monogram maker and use it across the website, the invitation suite and the table numbers.

A general guest list template for parties and events

Not every guest list needs seventeen columns. Trim the wedding guest list template to fit the event:

Event type	Keep	Add
Birthday or dinner	Name, party size, contact, RSVP	Notes (allergies, bringing a dish)
Engagement or shower	Name, side, party size, contact, invite sent, RSVP	Gift received, thank-you sent
Corporate event	Name, contact, RSVP	Company, role, dietary notes, checked in
Fundraiser or gala	Name, party size, contact, RSVP, table	Ticket type, amount paid, sponsor

For corporate events, a "Checked in" checkbox turns the guest list into the door list on the day. Sort it alphabetically by last name before printing or loading it on a tablet at the entrance, and whoever is greeting can find each guest in seconds.

Guest list mistakes that cost money or feelings

• Counting invitations instead of people. "80 invites" can mean 150 guests once families and plus-ones are added. The Party size column is what you compare against venue capacity.
• Leaving plus-ones undecided. Decide the rule (partners only, or everyone) before you build the list, then record it per row with the checkbox.
• Forgetting the two of you, and vendors who need a meal. Couples and the photographer, planner and band all count toward the caterer's number.
• One list per side in two files. Merge them on day one. A shared sheet with a Side column is fairer and faster to cut.
• Addresses collected last. Save-the-dates go out well before invitations, so addresses need to be complete before anything else ships.

The guest list that runs the whole wedding

The best wedding guest list template is the one you keep updating: one row per household, a tier for every name, and RSVP, meal and table columns that turn the list into the caterer's count and the seating chart. Copy the CSV above, or generate the styled version and collect replies online. When you're ready for the RSVP page itself, build it with the AI website builder and copy the replies into the same file as your guest list.

Keep Reading

• What Is a Monogram? — How wedding monograms are built, from single initials to three-letter crests.
• Event Proposal Template — The structure planners use to pitch an event, useful for working with a venue or planner.
• How to Make a Flyer — Layout rules for printed event announcements, from save-the-date cards to party flyers.
• How to Make a Collage on iPhone for Events — Turn wedding and party photos into shareable collages.