Wedding guest list template: the columns worth tracking
A wedding guest list template that works from first draft to final headcount: the columns to track, from household and contact to RSVPs and dietary needs.
A guest list starts as a list of names and ends as the source of truth for invitations, replies, seating and catering. A good wedding guest list template is set up for that whole journey from the start, so you are not rebuilding it at the busiest moment. This guide explains the columns worth tracking, how to use them at each stage, and a few habits that keep the list accurate.
One row per person, grouped by household
The most useful structure is simple: one row for each guest, with a household column that groups people who receive one invitation together. That gives you both numbers you need: people for catering and seats, and households for invitations and replies.
Our guide to how to organize a wedding guest list by household explains the approach in detail.
The wedding guest list template: core columns
Start with these:
| Column | What goes in it | | --- | --- | | Household | A label such as "Garcia family (Madrid)" | | Guest name | Full name, as it should appear on place cards | | Role | Adult, partner, child, or plus-one | | Side | Which partner or family invited them | | Group | Family, friends, work, sponsors, entourage | | Contact | Email or phone for the person who replies for the household | | Location | City and country, for travel planning | | Invited to | Ceremony, reception, and any other events |
If you only track these eight columns, you will already avoid most guest list problems.
Columns for replies and planning
Add these once invitations go out:
- Invitation sent (date).
- RSVP status: attending, declined, or no reply.
- RSVP date.
- Meal choice, if you are offering choices.
- Dietary needs and allergies, written precisely.
- Accessibility needs, such as step-free access or seating near the exit.
- Table number, once you begin seating.
Our guide to how to manage dietary requirements for wedding guests explains how to collect and hand over allergy information safely.
Columns for travel and accommodation
For destination weddings or many travelling guests:
- Arrival and departure dates.
- Accommodation, such as the hotel block or staying with family.
- Transport needs, such as airport transfers or shuttles.
- Children's ages, for rooms and meals.
Columns for after the wedding
- Gift received.
- Thank you note sent (date).
This makes the job of writing thank you notes much faster. Our guide on how to write wedding thank you notes has examples.
Using the list at each stage
Drafting. Each partner and each family adds names. Use the "side" column to keep the list balanced and to see where it is growing.
Cutting. Sort by group and household, then apply the same rule to everyone. Our guide on how to cut down your wedding guest list has fair approaches.
Inviting. Filter by household to send invitations, and record the date sent.
Replies. Update the status as replies arrive. A filter for "no reply" shows who needs a gentle follow-up; our guide on how to follow up on missing wedding RSVPs politely has message templates.
Final numbers. Count attending rows for headcount and meal totals. Our guide to the final wedding headcount explains how to reconcile late replies.
Habits that keep the list accurate
- Keep one master list. Avoid separate lists for each family; merge them early.
- Agree who can edit. Too many editors leads to duplicates and lost changes.
- Write names fully and correctly, and check spellings with someone who knows.
- Record decisions as you make them, such as "plus-one confirmed" or "children not invited".
- Back it up, or use a shared document with version history.
Spreadsheet or website?
A spreadsheet works well for drafting and planning. Once invitations go out, an online RSVP system that writes replies straight into your list saves hours of copying and reduces mistakes. Whichever you use, keep the same columns, so the data flows from first draft to final headcount.
Sharing the list with family
Parents and other hosts often want to add or check names. Rather than sending copies back and forth, share one view of the master list, or ask each family to fill in a separate tab that you merge carefully. Agree a deadline for additions, and decide in advance how you will handle names that push the total over your limit. Clear rules early prevent difficult conversations later.
Privacy
A guest list contains personal information: names, addresses, phone numbers and health details such as allergies. Share it only with people who need it, such as your caterer for dietary needs or your venue for seating, and only the columns they need.
A tidy guest list rarely feels exciting, but it quietly makes every later decision easier.