A wedding guest list spreadsheet template (and when it breaks)

The columns to include

Set these up before you enter a single name. The key idea is one row per person, grouped by party, so you can both count individuals and treat a household as one invitation.

• Full name. One row per guest — including each child and plus-one as their own row.
• Party / household. A shared label (e.g., “Sharma family”) so you can group a household into one invitation.
• Side. Which side of the family or couple the guest belongs to — useful for balancing and seating.
• Tier. Inner / close / wider circle, so you can decide who’s invited to which event consistently.
• A column per event. One column each for haldi, mehndi, sangeet, ceremony, reception — mark “yes/invited” per event.
• Phone & email. A mobile number (for texting) and email as backup — the contact you’ll actually invite through.
• RSVP status per event. Attending / declined / pending for each event — this is the column that gets painful, more below.
• Meal & dietary. Meal choice and any restrictions (veg, Jain, halal, allergies) once you collect them.
• Address. For paper invitations or thank-you notes, if you’re sending them.
• Notes. Anything else — “needs a hotel room,” “traveling from London,” “bringing a baby.”

Using it well

A couple of habits keep the sheet sane. Freeze the header row and use filters, so you can quickly pull “everyone invited to the sangeet” or “Tier 1 only.” Keep one row per person but sort and group by party, so households stay together. And decide a single source of truth early — if both families are adding names, agree on one shared copy rather than emailing versions back and forth.

For counting, a formula that sums each event column gives you a live per-event headcount as you fill in RSVPs — which is exactly the number your caterer will ask for.

• Filter by event and tier. Freeze the header and filter to pull any event’s or tier’s list in seconds.
• Group by party. One row per person, but sorted by household so families stay together.
• One shared copy. Agree on a single source of truth before both families start adding names.

When the spreadsheet stops working

A spreadsheet is great for planning and hopeless at collecting. The wheels come off at the RSVP stage, and it’s worth knowing where so you’re not surprised.

First, chasing. The sheet can hold RSVP columns, but it can’t reach out — you’re the one texting each non-responder, one at a time, and re-texting the stragglers, across however many events. Second, reminders. There’s no way to automatically nudge only the people who haven’t replied; you do it by hand, repeatedly. Third, version chaos. The moment more than one person edits — or you copy it to your phone, or a parent keeps their own list — you have conflicting versions and a headcount you no longer trust. Fourth, guest-facing entry. Guests can’t update the sheet themselves, so every reply has to be relayed to you and typed in, which is where errors creep in.

• It can’t chase. The sheet holds statuses but can’t message non-responders — that’s all on you.
• No automatic reminders. Nudging only the people who haven’t replied is manual and endless.
• Version chaos. Two editors, a phone copy, a parent’s list — and the count is no longer trustworthy.
• No guest self-service. Guests can’t update it; every reply is relayed and retyped, inviting errors.

Keeping the spreadsheet’s strengths, losing its limits

You don’t have to abandon the structure — the columns above are exactly the right way to think about a guest list. What changes when a wedding gets bigger or spans multiple events is that the collecting and chasing move off the spreadsheet and onto a tool that can actually message guests.

That’s what Duva does: you keep one master list with guests grouped by party and assigned per event (the same shape as your columns), but the RSVPs come in by text or WhatsApp, guests reply for themselves, reminders go automatically to only the non-responders, and the per-event headcount updates itself. You import your spreadsheet to start, and the tool takes over the parts a spreadsheet can’t do.