Free Wedding Guest List Template for Google Sheets

Here it is — no email signup, no upsell:

If you want to know what's in it and how to get the most out of it before you start filling in names, keep reading.

---

What's in the template

The sheet has eight columns. That's intentional — every extra column you add is another thing to maintain when you're already coordinating a wedding.

Guest Name — First and last. Obvious, but worth saying: don't abbreviate. "T. Smith" becomes a problem when there are three Smiths and you're trying to sort seating.

Group / Household — This is the column most templates skip and it's the one that saves the most time. Families travel together, sit together, and often RSVP together. Grouping them means you can filter by household instantly, and you know immediately when an entire table group has confirmed.

RSVP Status — Three options only: Pending, Attending, Not Attending. Set this up as a dropdown (in Google Sheets: select the column → Data → Data Validation → List of items). Resist the urge to add Maybe — it doesn't exist at a wedding. A non-reply is Pending until it's not.

+1 — Yes or No. Whether their plus-one is confirmed attending goes in a separate row, not here. This column just tracks whether they have one at all, which matters for headcount planning.

Dietary Requirements — Free text. Whatever your caterer will need to know. Don't simplify this down to checkboxes — people's dietary needs are specific and your caterer will thank you for the detail.

Table — Leave this blank until seating planning begins. Fill it in after RSVPs are mostly confirmed and you're building your seating plan.

Invite Sent — Yes or No. Sounds trivial. Isn't. When you're sending in batches — close family first, then friends, then colleagues — this column is how you don't accidentally send someone an invitation twice or forget them entirely.

Notes — One free-text column for everything that doesn't fit elsewhere. "Needs accessible seating." "Coming from abroad, might arrive late." "Confirm with Mum before finalising." This column will save you more than once.

---

How to actually use it

Start with groups, not individuals. Before you type a single name, decide on your household groupings. A typical wedding might have: immediate family, partner's immediate family, close friends, work friends, extended family, partner's extended family. Add a "Group" value for each name as you go — retrofitting it later takes longer than doing it upfront.

Use frozen rows and filters from day one. In Google Sheets: View → Freeze → 1 row, then Data → Create a filter. This lets you immediately filter to "show me everyone who is Pending" without scrolling through 120 names. At 80+ guests, an unfiltered list is basically unreadable.

Share with your partner — but agree on a process. The main advantage of Google Sheets over Excel is real-time collaboration. The main risk is two people editing the same cell simultaneously and one of them losing data. Agree on who owns which section: one person handles family rows, the other handles friends. Or just communicate before you make bulk changes.

RSVP deadline discipline. When RSVPs start arriving, update the sheet the same day. A two-week pile-up of "I think X said yes via WhatsApp" is a guaranteed mistake. Set aside five minutes whenever you check your messages.

Do a weekly headcount. Once RSVPs are arriving, filter to Attending and note the count. Track it somewhere visible — a sticky note on your laptop is fine. Watching the number grow (or worrying when it doesn't) tells you whether you need to chase guests or whether you're comfortably on track.

---

Where the spreadsheet breaks down

A template gets you far. But there are a few places where even a well-built spreadsheet becomes genuinely painful.

Chasing non-responders. The spreadsheet shows you who hasn't replied. It doesn't do anything about it. You manually scan the Pending rows, find their contact info somewhere else, compose a message, send it, and then update the spreadsheet when they reply. At 30 guests still pending two weeks before your deadline, this is a part-time job.

Connecting RSVPs to a guest list. If you're collecting RSVPs via a form or your wedding website, those responses don't automatically appear in your spreadsheet. You're copying and pasting from a Google Form or email inbox, which introduces errors and takes longer than it should.

Dietary data for the caterer. Your caterer doesn't want a Google Sheet. They want a clean breakdown: 12 vegetarian, 3 vegan, 1 nut allergy, 89 standard. Getting from a column of free-text dietary notes to that summary requires manual counting or a formula — neither of which is fun to maintain as guests change their minds.

The seating connection. Once RSVPs are done, seating begins. Your guest list is in one file, your seating plan is in another (or on paper, or on sticky notes on the kitchen table). Every time you move someone, you're checking back and forth between two sources. It works, but it's friction you don't need during an already stressful period.

These aren't reasons to avoid the spreadsheet — it's the right starting point. They're just honest about where it hands off to something else.

If you want guest list management connected directly to RSVP collection and seating, that's what Celebrate's guest list manager is built for. You can start on the free plan, which covers up to 30 guests with no credit card required.

---

FAQ

Can I use this template in Excel instead of Google Sheets?

Yes — File → Download → Microsoft Excel (.xlsx) from Google Sheets gives you an Excel file. The dropdowns convert cleanly. The only thing you lose is real-time collaboration if you're working with your partner.

How many guests should I add before switching to a tool?

There's no hard cutoff. But if you find yourself spending more than 20 minutes a week maintaining the spreadsheet — chasing RSVPs manually, filtering and counting, cross-referencing with other documents — that's a signal the spreadsheet has become the task rather than the tool.

Should I add a column for gift tracking?

Not in this sheet. Gift tracking is a separate workflow — who gave what, whether you've sent a thank-you note — and mixing it in here makes the guest list harder to use. Keep them separate.

What's the best way to handle plus-ones who aren't named yet?

Add a placeholder row: "Guest of [Name] — TBC." Give them a Group value matching the main guest. When you find out who they are, update the name. This keeps your headcount accurate without leaving gaps.

How do I track RSVPs from my wedding website?

If you're collecting RSVPs through a wedding website, the easiest method depends on your setup. Most online RSVP tools let you export responses as a CSV — you can paste those into your spreadsheet periodically. If you're using Celebrate's RSVP feature, responses feed directly into your guest list with no manual copying.

Should I share this template with my wedding planner or venue?

Share with your wedding planner — they'll need the full picture. Don't share the full sheet with your venue or caterer. Instead, filter to Attending and share a summary of dietary requirements closer to the date. They don't need your guests' contact details or RSVP history.

---

Managing a wedding guest list is one of those tasks that looks simple and turns out to be a project. The template gives you a clean start. Use the filters, keep the columns minimal, update it whenever RSVPs arrive, and it'll serve you well.

When you're ready for something that handles RSVPs automatically and connects directly to seating, Celebrate is free to start — no spreadsheet migration required.