Wedding guest list template
A guest list spreadsheet with a row per household and a column for everything you'll need later: addresses for the save-the-dates, RSVPs, headcounts and dietary needs. Free, no sign-up.
Download the template
Opens in Excel and LibreOffice, with dropdowns for Side, Tier and RSVP.
For Google Sheets (File › Import) and Numbers.
Free. No sign-up. Nothing to install.
What's in it
One row per household, the way the invitations go out. Write the names as they'd appear on the envelope.
- Names
- The household as the envelope reads. One row per invitation.
- For example: Ada & Ellis Marchetti
- Group
- Who they are to you: family, friends, work.
- For example: Bride's Family
- Side
- Whose side they're on, or both.
- For example: Bride's side
- Tier
- Who's invited first if the list must shrink.
- For example: Top Priority
- Save the Date
- Yes once the save-the-date has gone out.
- For example: Yes
- Invite
- Yes once the invitation has gone out.
- For example: Yes
- RSVP
- Their reply so far.
- For example: Attending
- Invited
- How many people the invitation is for.
- For example: 2
- Attending
- How many said they're coming.
- For example: 2
- Kids
- How many of those coming are children.
- For example: 0
- Dietary
- Each need with how many people have it.
- For example: Vegetarian (1)
- For the save-the-dates and reminders.
- For example: ada@example.com
- Address
- Street address for the envelope.
- For example: 12 Larch Row
- City
- Town or city.
- For example: Halden
- Region
- State, province or county.
- For example: ON
- Postal code
- ZIP or postal code.
- For example: K0A 1B0
- Country
- Leave blank when it's your own.
- For example: Canada
- Phone
- A number to reach them on.
- For example: 555-0101
- Notes
- Anything else: a plus-one's name, access needs.
- For example: Bring the cake knife
The examples are made up.
Prefer paper?
Print a blank ruled list with room for the names, the address, how many are invited, the reply and dietary needs. Handy for a parent who'd rather write theirs by hand.
When your list is ready
- Step 1
Create a free account
The free plan holds up to 75 guest households, with no time limit.
- Step 2
Bring the file in
Open Guests › Import CSV for the CSV, or upload the .xlsx to the spreadsheet importer.
- Step 3
Check the preview and import
The columns are matched for you, and the preview names anything it couldn't read.
How to use it
A wedding guest list does three jobs over a year: it sets the headcount, it addresses the envelopes and it collects the replies. Most lists start as a column of names and grow columns as each job arrives, which is when the gaps show. This template starts with every column the later jobs need, so the address spreadsheet, the RSVP tracker and the headcount are the same list.
- Download the template. Pick the .xlsx for Excel or LibreOffice, or the CSV for Google Sheets and Numbers. Both have the same columns, and the .xlsx adds dropdowns for Side, Tier and RSVP.
- Write one row per household. A household is everyone one invitation goes to. Write the names the way the envelope will read them, then the group, the side and how many people the invitation is for.
- Fill in addresses as you collect them. Leave a cell blank when you don't know yet. Addresses matter by the time the save-the-dates go out, and email by the time you send reminders.
- Track replies and dietary needs. When invitations go out, mark Invite as Yes. As replies come in, set the RSVP, how many are attending, how many of them are children and any dietary needs.
Why a row per household
One invitation goes to one household, so a row per household keeps the list the same shape as the envelopes. The names cell holds what the envelope will say, such as "Ada & Ellis Marchetti" or "The Okonkwo-Vale family", and Invited holds how many people that is. Your headcount is the sum of Invited, and the number coming is the sum of Attending once replies are in.
Group and Side say who each household is to you. They make it easy to see how the list splits between families and friends, and to cut by group if the numbers need to come down. Tier is for that moment: the households you'd invite first sit at the top. To see where a budget or a venue stops the list, the guest count calculator adds the tiers up for you.
Bringing it into Linenfold
Every heading in the template is one Linenfold reads on its own. Save the CSV, or the Guest list tab of the .xlsx as CSV, and open Guests › Import CSV in your wedding; or upload the whole .xlsx to the spreadsheet importer. The preview shows each household before anything is saved. From there the list feeds the seating plan, the address form, the RSVP page and the headcount, so it never needs copying again. Create a free account to start; the free plan holds 75 guest households.
Two guides cover the jobs that follow: collecting addresses for the save-the-dates, and setting up a free RSVP website where guests find their own name.
Questions couples ask
- Should a guest list count households or people?
- Both, in different columns. Each row is one household, because that's one envelope and one address. The Invited column says how many people the invitation is for, and the sum of that column is your headcount.
- How do I list a plus-one?
- On the same row as the guest who brings them. Write "Pim Lindqvist & guest" in Names, count two in Invited and add the plus-one's name in Notes once you know it.
- How do I write addresses for guests in other countries?
- Put the street in Address, the town in City, the state, province or county in Region and the postcode in Postal code, then the country's name in Country. Leave Country blank for guests in your own country.
- Can our parents add their guests to it?
- Yes. Send them the file, or share it in Google Sheets, and ask for one row per household with the group set to their side's family. Merge the rows into your copy, and look for the same household twice before the invitations go out.
- Does it work in Google Sheets?
- Yes. In Google Sheets, open File, then Import, and upload the CSV or the .xlsx. The .xlsx keeps its dropdowns there; the CSV is the plain header row.
- What happens to the columns when I import it into Linenfold?
- Every heading is one Linenfold already knows, so each column lands in its field with nothing to match by hand. Groups, tiers and RSVP answers that match your lists are picked up as they are, and the preview shows anything it couldn't read before you import.
Want the rest of the toolkit? Browse the free wedding planning tools.
Guest list
Wedding of ________________________ Page ____ of ____
| # | Names (as on the envelope) | Address | Invited | RSVP | Attending | Dietary | Notes |
|---|---|---|---|---|---|---|---|
| 1 | ☐ Yes ☐ No | ||||||
| 2 | ☐ Yes ☐ No | ||||||
| 3 | ☐ Yes ☐ No | ||||||
| 4 | ☐ Yes ☐ No | ||||||
| 5 | ☐ Yes ☐ No | ||||||
| 6 | ☐ Yes ☐ No | ||||||
| 7 | ☐ Yes ☐ No | ||||||
| 8 | ☐ Yes ☐ No | ||||||
| 9 | ☐ Yes ☐ No | ||||||
| 10 | ☐ Yes ☐ No | ||||||
| 11 | ☐ Yes ☐ No | ||||||
| 12 | ☐ Yes ☐ No | ||||||
| 13 | ☐ Yes ☐ No | ||||||
| 14 | ☐ Yes ☐ No | ||||||
| 15 | ☐ Yes ☐ No | ||||||
| 16 | ☐ Yes ☐ No | ||||||
| 17 | ☐ Yes ☐ No | ||||||
| 18 | ☐ Yes ☐ No | ||||||
| 19 | ☐ Yes ☐ No | ||||||
| 20 | ☐ Yes ☐ No |
linenfold.co/tools/guest-list-template