How to Track Wedding RSVPs and Your Head Count in a Spreadsheet

Your guest list is the heart of wedding planning. It drives your venue size, your catering order, your seating chart and a big part of your budget. A simple spreadsheet keeps all of it in one place.

Start with one row per invitation

Give each invitation its own row, with the number of people it covers (the party size): a couple is 2, a family of four is 4. Counting people per invitation keeps your head count accurate, including plus-ones and children.

Useful columns:

• Invitation (who it's addressed to)
• Party size
• RSVP (pending, yes, no)
• Meal choice or dietary needs
• Notes (address, side of the family, anything else)

Use a dropdown for RSVPs

Typing "yes", "Yes" and "Y" in different rows makes counting messy. A dropdown with three choices (pending, yes, no) keeps the list clean, and your confirmed count stays correct automatically.

Count what matters

Three numbers answer most questions:

1. Expected: how many people you're planning for.
2. Confirmed: the people on invitations that replied yes.
3. Pending: the invitations that haven't replied yet.

When your caterer asks for a final number, you'll have it in seconds.

Follow up on pending replies

A week or two before your RSVP deadline, filter the list to "pending" and send friendly reminders. It's much easier than chasing replies the week before the wedding.

Connect it to your budget

Divide your total committed spending by the number of guests you expect to see your cost per guest. It's a helpful number when you're deciding whether to add one more table, and you can update the expected count as replies come in.

Keep it after the wedding

Add a column for gifts and thank-you cards, and tick them off as you go. Your guest list becomes your thank-you list.

The Wedding Budget Planner includes a guest list with party sizes, an RSVP dropdown and a confirmed head count, plus your cost per guest based on the number of guests you expect.