How to track RSVPs (without a spreadsheet)

Tracking RSVPs by hand falls apart somewhere around twenty guests. Here is what to track, what to automate, and how to chase the people who never replied.

What you actually need to track

A headline number is not enough. Caterers, venues, and seating plans all need slightly different figures, and the gap between them is where mistakes happen.

  • Confirmed attending — the number you cater and seat for
  • Total headcount, not replies: one RSVP may cover four people
  • Adults and children separately, if your catering or pricing splits them
  • Maybes, so you know your realistic upper bound
  • Declines, which are how you know a silent guest actually saw the invitation
  • Non-responders, the group that needs a reminder
  • Dietary needs and any custom answers, collected at reply time rather than chased later

Why spreadsheets break down

A spreadsheet is fine right up until replies start arriving through four different channels. Someone answers in the group chat, someone else texts you directly, a third person tells you in the school car park, and your aunt replies to the email. Every one of those is a manual entry, and every manual entry is a chance to double-count or miss somebody.

The harder problem is change. Guests revise their plans constantly in the last fortnight, and each revision means finding a row and editing it. By the time you send numbers to the caterer, the sheet is usually a few days stale.

Let the replies count themselves

When guests reply through a link, the counting is done for you. Every response updates the totals immediately, and a guest who changes their mind updates their own row — no message to you, no edit by you.

That also gives you a single list rather than four. Everyone who replied is in one place, with what they answered, how many people they are bringing, and anything they told you about allergies or song requests.

Chasing the people who never replied

Non-responders are the real work in RSVP tracking, and they are usually not refusals — they are people who meant to reply and forgot. Two well-timed nudges recover most of them.

Send one reminder about a week before, when people can still check their calendar, and a final one two or three days out. Reminders that go only to people who have not answered are far more effective than a message to everyone, which the people who already replied find annoying and everyone else ignores.

When you run out of room

If your venue has a hard limit, set it on the event and let the page enforce it rather than watching the number yourself. Once the limit is reached, later guests can join a waitlist instead of hitting a closed door, and you promote them one at a time as cancellations come in.

You can also set a reply-by date so the form closes on its own. It stops the trickle of late replies arriving after you have already confirmed numbers.

Getting the list back out

Whatever you track in, you eventually need the list somewhere else — at a check-in table, in a seating plan, or in an email to the venue. Export the guest list when you need it, and use the seating tools if you are assigning tables rather than just counting heads.

Frequently asked questions

What is the best way to track RSVPs?
Collect replies through a single event link so responses count themselves. You get a live headcount, one guest list instead of several, and guests can update their own answer when plans change — which is where hand-kept lists usually go wrong.
Is there a free RSVP tracker?
Yes. RSVPlinks tracks RSVPs free for up to 20 replies per event across up to 5 active events, including live counts, the full guest list, and host notifications. Larger events are priced per event from $7 rather than by subscription.
How do I track RSVPs that come in by text or in person?
Add them to the guest list yourself from your dashboard. Manually added guests sit alongside the ones who replied through the link and count towards the same totals, so you keep a single accurate number.
How do I remind guests who have not replied?
Send a reminder to non-responders only, about a week before the event and again two or three days out. Targeting just the people who have not answered performs much better than messaging the whole list.
Can I see how many people each guest is bringing?
Yes. When you enable a headcount field, each RSVP records how many people it covers, with an adults-and-children split if you need one. Your totals show the real headcount rather than the number of replies.

Ready to make yours?

Build your event page, share one link, and watch the replies land. Free for small events, no credit card.

Set one up for your event

More guides

  • How to create an RSVP link (free, in about 3 minutes)

    Step-by-step: how to create a free RSVP link for any event, share it by text or QR code, and see who is coming in real time. No app, no sign-up to start.

  • What is an RSVP link?

    An RSVP link is a single web address that shows your event details and lets guests reply in one tap. Here is what it contains, how it works, and when to use one.

  • How to set up a free RSVP website

    What a free RSVP website should include, what the limits usually are, and how to set one up for a wedding, shower, birthday, or reunion in a few minutes.