A live RSVP dashboard for your list

The spreadsheet is not what breaks. What breaks is that your replies arrive from four different places and only some of them ever reach the sheet. Any RSVP view worth having has to hold all four, count people rather than rows, and let you type in the answers that came by voice. Here is how to read one without misleading yourself.

Where the replies actually come from

You send a personal link and expect the answers back through it. Most come. The rest arrive like this.

• Through the invitation. The guest taps yes, sets how many are coming, and there is nothing for you to do.
• In the WhatsApp chat. “We are coming, all four of us”, typed underneath your message, never touching the form.
• By phone. Your mother rings on a Tuesday evening with her brother’s household, six of them, and a correction to the spelling of his wife’s name.
• In person. Somebody tells you at another wedding in March and assumes you will remember in June.

The last three are the difficulty. They land somewhere that is not your list, and while you are doing something else. A spreadsheet does not lose them. You do, in the twenty minutes between hearing and reaching a laptop.

Then there is the quieter failure. Two people maintain the list. One of you adds a column, the other is working from a copy downloaded on Sunday, and by Thursday there are two versions of the truth and one caterer who wants a single number.

Head count and guest count are not the same number

This is where most spreadsheets go wrong, and the mistake survives a move to any tool that ignores it. A row is usually a household, not a person. “Chandima and family” is one row and five people. So “eighty replies” means nothing to a caterer, and neither does “six invited, one declined” when the one who declined was a family of six.

Your list needs both numbers, kept apart and both visible. The tiles on the dashboard count heads rather than rows, declines included, so a household of six pulling out reads as six places freed rather than one. The line under the page title carries the other number: how many guest entries you hold, beside the head count for the list as you have filtered it.

A household’s allowance can also differ from one ceremony to the next. Give a party of five only three places at the morning ceremony and that ceremony’s totals treat them as three invited, not five. It is what stops a forty-seat room from quietly inheriting the reception’s numbers.

How to read the three numbers at the top

Attending, with the number invited beside it. Declined. Pending, with a response rate. All three count only the guests you have approved, which starts to matter the moment somebody you never entered can reply. Read them together. Attending on its own is flattering in the first fortnight; attending set against pending tells you how much of your list is still unknown, and that is the figure that decides whether you can commit to anything.

Underneath, one row per guest: name and number, party size, group and side, which events they are on, their reply, and whether their invitation has been sent and opened. Narrow the list by invitation, group, side, reply, or whether the invitation has gone out yet. The tiles at the top follow the invitation you are looking at; the head count on the line above the table follows every filter you have set.

Getting the phone calls into the same list

A reply that arrives by voice has to end up where the tapped ones are, or you are back to two lists. Any guest’s answer can be set from your side: yes, no or still pending, how many are coming, and a note. Once in, the two are indistinguishable in the counts.

Guests can change their minds without asking you. Their link stays live, so they answer again and the new answer replaces the old. If you set a reply deadline, the form closes after it and late changes come to you instead.

Set that date by counting backwards from whichever supplier needs a figure first, and leave a week or two in front of it. Nobody can tell you how much margin is enough, because it depends on how quickly your own family answers a message. What the list changes is the chasing: filter to pending and the missing names are in front of you rather than buried in eighty rows.

Which events they are coming to, and what they can eat

Per-event replies are opt-in per invitation. Left alone, a guest gives one answer for the whole wedding. Switch it on and every guest answers each ceremony separately with their own number for each, and the single overall answer becomes a summary of those: a yes to any ceremony reads as attending. Filter the dashboard to one ceremony and the tiles describe that day alone.

Custom questions are opt-in too, and capped at ten per invitation. Dietary preference, food allergies, transport, a song request. They are asked once per guest, not once per ceremony, because an allergy does not change between morning and evening. A required question is only enforced on guests who are attending, so nobody declining is held up by a question about food. Answers show two ways: a summary per question, the version to hand your caterer, and guest by guest, for when one person’s answer matters.

When a spreadsheet is genuinely the right tool

Some weddings need none of this. Thirty guests you could name from memory, one sitting, nobody outside the family waiting on a figure: a spreadsheet is fine for that, and so is the family group chat the whole thing is being planned in.

It stops being fine at specific points. Several ceremonies with different lists. A caterer with a contracted number and a date attached to it. More than one person maintaining the list. Or the night you are holding a message that says “yes, and there are three of us” from a number you do not recognise, with no row to attach it to.

And if you like your spreadsheet, you need not give it up. The list exports as a CSV exactly as you have filtered it, with names, numbers, groups, sides, head counts, replies and attending counts. The online RSVP page covers what guests see when they reply, and the guest list covers the sides, groups and per-event invitations the replies land on.

Related: Online wedding RSVP · Wedding guest list manager