A wedding guest list spreadsheet template, with day and evening guests
One row per person, and the eight columns that make RSVPs, meals and seating easy.
Use one column, Invited to, set to All day or Evening. Filter it and you have both counts.
Want it ready-made? The free seating plan template includes a guest list.
One row per person
Households are useful for addressing invitations. But meals, dietary needs and seats are counted one person at a time. Keep a Household column so you can still group them.
The columns
| Column | Why |
|---|---|
| Name | As it goes on the place card |
| Side | Yours, theirs or both, to keep the list balanced |
| Invited to | All day or evening; venues usually price them differently |
| Invite sent | A tick, so nobody is missed |
| RSVP | Yes, No or Waiting, from a drop-down |
| Meal | For day guests, once the menu is set |
| Dietary or access | Allergies, step-free access, seating near the door |
| Table | A number, filled in once replies are in |
Counts to keep at the top
- Invited, coming, waiting and not coming.
- Coming all day and coming in the evening, separately.
- Meals by choice for the caterer.
- Coming all day but without a table yet.
COUNTIF and COUNTIFS do all of these in Google Sheets and Excel.
From list to seating plan
Give each guest a table number and count the Yes replies per table against its seats. Our seating plan guide covers the rest. The UK Wedding Planner Spreadsheet places names under each table for you.
Building the list
Start with everyone you would like there, without worrying about numbers. Then go through together and mark each person all day or evening. Add the Side column as you go. It makes it easy to see if the list leans heavily one way. It also helps you share out who chases which replies.
Write names exactly as they should appear on invitations and place cards. Fixing spelling once, at the start, saves doing it three times later.
Tracking replies
Use a drop-down for RSVP (Yes, No, Waiting) rather than free text. Then your counts never miss a "yes!" or a "Y". Set a reply-by date on the invitation. The week after it, filter the list to Waiting and send those people a friendly reminder.
For the counts, COUNTIFS does the work. For example, people coming all day: =COUNTIFS(C:C,"All day",E:E,"Yes"). Here C is Invited to and E is RSVP. Change the words to count evening guests, or meals by choice.
Meals and dietary needs
Keep the meal choice and any dietary or access notes on the guest's own row. When the caterer asks for numbers, count each meal with COUNTIFS. Send the list of notes with names, so the kitchen knows who each one is for.
Sharing it safely
A guest list holds names, sometimes addresses and phone numbers, and health information such as allergies. Share it only with the people who need it. Remove access once the wedding is over.
Invitations and addresses
If you are posting invitations, add an Address column. Fill it in for the first person in each household. Leave it blank for the others. Filter on it when you write envelopes. Add an Invite sent date too. When replies are slow, it tells you whether someone simply received theirs late.
After the wedding the same list becomes your thank-you list. Add a Gift column and a Thank you sent tick, and nobody gets missed.
Questions
Should a guest list be per person or per household?
Per person, with a household column. Meals, dietary needs and seats are counted one person at a time.
How do I count RSVPs in a spreadsheet?
Use COUNTIFS, for example people invited all day who replied Yes. Use a drop-down for RSVP so the counts never miss a reply.
The whole wedding in one spreadsheet
Our UK Wedding Planner Spreadsheet has the budget, payments, guests, seating and 39 dated tasks. It works in Google Sheets and Excel. Launch sale: 35% off until 1 December.
UK Wedding Planner Spreadsheet, £12.31 on EtsyPrefer Notion? Guest List & RSVP, £7.02 on Etsy