Wedding guest list spreadsheet: the columns you need
The columns a wedding guest list spreadsheet needs, from households to replies, a template you can fill in and download, and tips for keeping it accurate.
A wedding guest list spreadsheet needs one row per household, with the guests' names, whose guest they are, the postal address, an email or phone number, and their reply. Fill in the template below and download it, or download the empty columns to use in your own spreadsheet.
A guest list spreadsheet, ready to download
One row per household. Fill it in here and download it, or download the empty columns and fill them in your own spreadsheet.
Which columns do you need?
| Column | Why |
|---|---|
| Household | One invitation goes to each household |
| Guests | Names, and how many adults and children |
| Whose guest | Keeps the two sides balanced |
| Postal address | For save the dates and printed invitations |
| Email or phone | For digital invitations and reminders |
| Reply | Yes, no, and how many |
Add columns only when you need them: meal choices, dietary needs, gifts received, thank-you sent.
How do you keep it accurate?
- One row per household, never one per person, or you will send two invitations to one address.
- One person keeps the master copy. Two copies drift apart within a week.
- Write replies the day they arrive.
- Sort by side before you cut numbers, so you see the balance.
Spreadsheet or a dedicated tool?
A spreadsheet is flexible. A dedicated tool can check for missing addresses and duplicates for you. Our free guest list organiser does that and downloads the same columns, and how to collect wedding guest addresses explains how to fill the gaps.
Questions
What should a wedding guest list spreadsheet include?
Household, guest names, whose guest, postal address, email or phone, and reply.
Should I list households or individuals?
Households. One row per household keeps invitations and addresses right, with a count of adults and children.
Can I use Google Sheets?
Yes. Download the file above and open it in Google Sheets, Excel or Numbers.
How do I track replies?
Add a reply column and fill it in as replies arrive, or use an online reply form that keeps the list for you.