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.

The template is yours either way. And if this list ever grows past the point where seating feels manageable on paper, import it straight into Celebrate and start dragging guests onto tables. Importing is free with no limit on guest count, and the free plan lets you seat up to 70 of them.

---

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 make a wedding guest list in Google Sheets

Start with groups, not individuals. Before you type a single name, decide on your household groupings. (Deciding who makes the list in the first place is its own project — our guide to organizing your wedding guest list walks through that part.) 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. Our RSVP tracker guide covers the dropdowns and live headcount formulas that make those five minutes enough.

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.

The seating connection. This is usually where it breaks first, not RSVP tracking. Once most guests have confirmed, seating begins. Your guest list is in one file, your seating chart is on paper, sticky notes, or a second tab you keep losing track of. Every swap means checking back and forth between two sources, and at 150+ guests, that back and forth stops being a minor annoyance and starts being how you spend your Saturday.

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.

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're weighing the two approaches properly, we've written a full spreadsheet vs online tool comparison that goes deeper.

---

Import your list and start seating

At some point, usually somewhere between 100 and 200 guests, moving names around by hand stops being realistic. This is the exact moment Celebrate's seating plan tool is built for: import this spreadsheet, and every guest shows up as a card you can drag straight onto a table.

It takes three steps:

1. Export this sheet as .xlsx. In Google Sheets: File → Download → Microsoft Excel (.xlsx). The import only reads the first sheet in the file, so make sure your guest list tab is first.
2. Upload it in Celebrate. Your guest list manager will match the columns automatically, Full Name, Group, Attending, and Dietary Preference all carry over.
3. Open the seating plan and start dragging. Guests appear as cards with their dietary tags still attached, so you know who needs what without checking back against the spreadsheet.

It connects to the same guest list manager tracking everything above. Importing has no guest limit, and the free plan lets you seat up to 70 guests, 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 there's a pattern. Most couples manage RSVP tracking fine in a spreadsheet up to around 100 to 150 guests. What actually breaks first, usually, isn't RSVP tracking, it's seating. If you're renumbering tables by hand or losing track of which sticky note goes where, that's the moment to import this sheet into a seating tool instead of pushing the spreadsheet further.

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 your list outgrows what a spreadsheet can comfortably handle, especially once seating enters the picture, import it into Celebrate and pick up exactly where this template leaves off.