Free Wedding Guest List Template
Every wedding starts with the same spreadsheet: names in one column, and then the slow accumulation of RSVPs, meal choices, households, and table numbers around them. This is that spreadsheet, already built. No email required, no account, no catch. Download it and use it today.
Prefer Google Sheets? Open Google Sheets, go to File > Import > Upload, choose the file you just downloaded, and select "Replace spreadsheet." It converts automatically and you can edit it right there.
What the template tracks
One row per guest, with columns for:
- Guest name, one row per person, so meals and seats stay exact
- Household or party, so invitations and addresses stay grouped
- RSVP with a dropdown (Yes, No, Maybe, Pending) and live counters at the top: invited, RSVPs in, attending, declined, pending
- Meal choice, ready for the caterer's final count
- Table number, so a quick sort gives you a per-table view when seating time comes
- Notes, for allergies, plus-ones, and kids' meals
The counters calculate themselves. When your mother asks "how many are we at?", the answer is in the top row.
How to use it
1. Add everyone you're inviting, one row per person. Couples and families share a Household label but keep their own rows; that's what keeps meal counts and seating honest later.
2. Set every RSVP to Pending when invitations go out. From then on, the top-row counters tell you exactly where things stand.
3. Record meals as RSVPs arrive, not in a batch at the end. Future you, staring down the caterer's deadline, will be grateful.
4. Leave tables for last. Once the yes list settles, fill in table numbers and sort by that column to see each table at a glance.
The manual version, and the automatic version
This spreadsheet is yours to keep, free, no strings. It's also the manual version of what ToBeWed does automatically: a guest roster with RSVPs, meals, and households, connected to a drag-and-drop seating chart that only shows the guests who said yes, so nobody gets a chair who isn't coming. You can even import this exact spreadsheet later; nothing you type here is wasted. See how ToBeWed works. Free to start, no credit card. And if vendors are your current headache, there's a matching free vendor tracker template.
FAQ
How do I track RSVPs in a spreadsheet?
Give every guest one row and an RSVP column with a fixed set of values (Yes, No, Maybe, Pending), then count each value with COUNTIF. This template has the dropdown and the counters already wired, so the totals update as you type.
Should each guest get their own row, or one row per couple?
One row per person. Meals, seats, and headcounts are all per-person numbers; a shared row means fractions and footnotes. Use the Household column to keep couples and families grouped for invitations.
Do I need to give my email to download this?
No. There's no signup, no email gate, no account. Click the download link and it's yours.
Does this template work in both Excel and Google Sheets?
Yes. It downloads as an .xlsx file, which opens natively in Excel. For Google Sheets, use File > Import > Upload and choose the downloaded file.
How is this different from a wedding seating chart template?
This is the list the seating chart is built from. Track who's invited and who said yes here first; seating only makes sense once the yes list is real. ToBeWed connects the two automatically, with a visual seating chart fed by the RSVP list.