You do not need special software to manage a wedding guest list. A shared spreadsheet in Google Sheets or Excel does the job, as long as it is set up well on day one. The goal is one list that feeds your save-the-dates, invitations, RSVPs, meals, seating chart and thank-you notes, so no one retypes an address in a panic.
This guide walks through the columns to include and how to use them. You can build it from scratch in about twenty minutes.
Set up the basics first
Start with the columns you need before invitations go out:
Use one row per person, not one row per household. It is easier to count heads, track meal choices and seat people. The household column lets you sort by address when you print envelopes or labels.
Add the columns you’ll need later
Add these as soon as you send save-the-dates, so you can work down the list in order:
| Column | What it is for |
|---|---|
| Save-the-date sent | Mark the date or a yes/no |
| Invitation sent | Same idea |
| RSVP | Yes, no or waiting |
| Meal choice | Entrée and any dietary needs |
| Table | Filled in once you plan seating |
| Gift received | Helps with thank-you notes |
| Thank-you sent | Check off as you write them |
Our RSVP and meal tracker works the same way if you would rather use a ready-made tool. For the timing of each mailing, see our save-the-date and invitation timeline.
Use tiers to control the number
The tier column is the most useful one. Fill in your must-invite names first, then the would-love list, then the nice-to-haves. When you know your venue’s capacity and per-guest budget, you can sort by tier and see where the line falls. If you need to cut, you cut the bottom tier as a group, and if people decline, you can invite from the next one.
A quick estimate helps: many couples expect roughly 75 to 85 percent of local guests to attend, though this varies. Use the guest count and cost calculator to test totals.
Keep it clean
- Use consistent formatting. Write states as two-letter abbreviations and phone numbers one way.
- Check addresses early. Text or email each household to confirm before printing envelopes.
- Make one editor the owner. Two people can edit, but only one person should reorganize columns.
- Back it up. Download a copy before big changes.
- Protect privacy. Guests’ addresses and phone numbers are personal. Share the file only with the people planning with you.
For more on deciding who to invite, read our guide to making (and cutting) a guest list.
General information, not legal, medical or financial advice. Confirm details with your vendors, venue, officiant and local authorities.
Questions people ask
What columns should a wedding guest list spreadsheet have?
At minimum: name, household, side, tier, address, email or phone, RSVP, meal choice and table. Add save-the-date, invitation, gift and thank-you columns so one list covers everything.
Should I use Google Sheets or Excel for my wedding guest list?
Either works. Google Sheets is easier to share and edit together in real time. Excel works well offline. Choose the one you and your partner already use.
When should I start my wedding guest list?
As soon as you start planning. A rough list shapes your venue, budget and catering choices, so start it before you book a venue.
