Free RSVP Tracker Template for Google Sheets

Here it is — no email signup, no upsell:

One honest note before you scroll: this is the same sheet as our wedding guest list template. That's deliberate. Your RSVP tracker and your guest list should never be two separate documents — the moment they are, you're reconciling them by hand every week. One sheet, one source of truth.

This guide covers the RSVP side: how to set up the tracking columns, add a live headcount, and keep the sheet honest once replies start arriving.

---

The columns that do the RSVP work

Of the eight columns in the template, four carry the RSVP workload:

RSVP Status — Three options only: Pending, Attending, Not Attending. No Maybe. A maybe doesn't exist at a wedding — a non-reply stays Pending until it's a real answer, and your headcount stays truthful.

+1 — Whether the guest has a plus-one at all. The plus-one's own reply lives in their own row, so your totals never silently double-count.

Dietary Requirements — Free text, filled in as replies arrive. By the time RSVPs close, this column is the summary your caterer will ask for.

Notes — "Replied via WhatsApp, confirm formally." "Coming to ceremony only." The context you'll otherwise forget by next month.

---

Set up the status dropdown (2 minutes)

The dropdown is what turns a plain sheet into a tracker — it makes replies filterable and countable, and it stops typos like "attending ✓" breaking your formulas.

1. Select the RSVP Status column.
2. Data → Data validation → Add rule.
3. Choose Dropdown, add Pending, Attending, Not Attending.
4. Give each a colour — green for attending, grey for pending, red for not attending. At a glance, the colour balance of the column tells you how your responses are going.

The template comes with this already configured, but it's worth knowing how it works so you can adjust it — some couples add Ceremony only as a fourth status, which is a legitimate exception to the three-status rule.

---

Add a live headcount

This is the part most RSVP spreadsheets miss, and it takes three formulas. Put these anywhere above your list (the template has them in the header row):

=COUNTIF(C2:C500, "Attending")
=COUNTIF(C2:C500, "Not Attending")
=COUNTIF(C2:C500, "Pending")

(Adjust C to whichever column holds your RSVP status.)

Now the sheet answers the three questions you'll ask it every single day without you counting anything: how many are coming, how many aren't, and how many still owe you an answer.

Want the caterer numbers too? One more:

=COUNTIFS(C2:C500, "Attending", E2:E500, "*vegetarian*")

That counts confirmed guests whose dietary column mentions "vegetarian" — repeat for vegan, allergies, or children's menus.

---

Keep it truthful once replies arrive

A tracker is only as good as its update habit. Three rules that keep the sheet from drifting:

Update the same day a reply arrives. RSVPs come in through every channel — the reply card, a text, your mum relaying a phone call. Whatever the channel, it goes into the sheet that day. A two-week pile of "I think they said yes" is how weddings end up with two empty seats and one missing dinner.

Filter to Pending once a week. That filtered view is your chase list. As your RSVP deadline approaches, it tells you exactly who needs a nudge — and our reminder message examples make sending those nudges painless.

Never delete a row. Someone declines? Status → Not Attending. Deleting rows loses the history, breaks your counts, and — when someone un-declines, which happens more than you'd think — forces you to rebuild what you already had.

---

Where the spreadsheet stops helping

The tracker shows you who's pending. It doesn't chase them — you're still finding contact details, composing messages, and copying replies back in by hand. And if guests reply through a form or wedding website, nothing lands in the sheet until you paste it there.

That manual loop is the real cost, and it grows with your guest count. If you'd rather replies filed themselves, Celebrate's online RSVP collects responses straight into your guest list — statuses, meal choices, and headcount update on their own, and the collecting RSVPs online guide shows how that works end to end. Free to start, no spreadsheet migration required.

---

FAQ

Does the template work for events other than weddings?

Yes. Nothing in it is wedding-specific — the same columns and formulas track RSVPs for a baby shower, birthday, or anniversary. Rename the sheet and go.

Can I use it in Excel instead of Google Sheets?

Yes — File → Download → Microsoft Excel (.xlsx). The dropdowns and COUNTIF formulas convert cleanly. You lose real-time collaboration, which matters if you're tracking replies together with your partner.

How do I track meal choices per guest?

Add a Meal column with its own dropdown (e.g. Beef, Salmon, Vegetarian), then count confirmed choices with =COUNTIFS(C2:C500, "Attending", F2:F500, "Beef"). Keep it separate from Dietary Requirements — one is a menu selection, the other is medical.

Should couples share one tracker or keep two?

One tracker, always. Use Google Sheets' sharing for exactly this. Two documents means two versions of the truth, and you will pay for the difference at the final headcount.

What if a guest replies "maybe"?

Leave them Pending and add the context to Notes. A maybe is a pending with extra information — treating it as half-confirmed is how headcounts go wrong. Follow up as your deadline approaches.

---

An RSVP tracker doesn't need to be clever. It needs one status per guest, a count you never do by hand, and the discipline to update it the day replies arrive. The template gives you the first two; the third is yours.

And when the chasing itself becomes the job, Celebrate is free to start — guests reply online, and the tracker keeps itself.