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.

Updated 18 October 2026 · You & Evermore

Prefer a spreadsheet? Our Guest List Spreadsheet works in Google Sheets and Excel (on Etsy).

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

ColumnWhy
NameAs it goes on the place card
SideYours, theirs or both, to keep the list balanced
Invited toAll day or evening; venues usually price them differently
Invite sentA tick, so nobody is missed
RSVPYes, No or Waiting, from a drop-down
MealFor day guests, once the menu is set
Dietary or accessAllergies, step-free access, seating near the door
TableA number, filled in once replies are in

Counts to keep at the top

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

Related guides

Planning the seatingDay and evening guests