A wedding guest list Excel template is a workbook for recording each invited guest, grouping people by household, and tracking invitations, RSVPs, meals, and follow-up. In Excel for Microsoft 365 on Windows, you can make a useful version with one row per person, clear status columns, filters, and a few simple formulas.
What a wedding guest list template should do
A good guest list is more than a collection of names. It should help you answer practical questions throughout planning: how many people have been invited, how many have replied, who has dietary requirements, and which guests still need a reminder? Keeping those details together reduces the chance that a reply in a text message or email gets overlooked.
Separate the number of invitation households from the number of guests. One invitation might be addressed to two adults or to a family of four, but those are four people for catering and seating purposes. A spreadsheet that has one row per household can make headcounts harder to verify. For most couples, one row per person is the clearest structure, with a household or invitation ID repeated for people who belong together.
The spreadsheet is a planning aid, not a substitute for the final count required by your venue or caterer. Confirm the deadline, counting rules, and any requirements for children, vendors, or meal selections with the relevant providers.
Set up the workbook and guest rows
Create a blank workbook in Excel and rename the first sheet Guest List. Put one descriptive heading in each cell of row 1, then add one invited person per row beginning in row 2. A practical set of columns is:
- Guest ID: a short reference such as G001, useful when names repeat.
- Household ID: a shared label such as H014 for people receiving one invitation.
- First name and last name: keep them separate so sorting and addressing labels are easier.
- Email or mailing address: include only the contact details needed for your process.
- Invitation status: for example, Not sent, Sent, or Hand-delivered.
- RSVP status and response date: use a consistent set of statuses and record when the reply arrived.
- Meal choice and dietary or accessibility notes: record only information that helps with arrangements.
- Save-the-date, invitation, and thank-you status: optional columns for tracking each mailing or follow-up.
- Table or notes: add these only when useful, and keep sensitive personal commentary out of the shared file.
Use a clear convention for plus-ones. If a guest is allowed to bring a companion but has not named that person, you can record the allowance in a separate plus-one column or note. Do not treat an unnamed companion as a confirmed person for meal and seating totals. Add a guest row once the person is identified, or use a clearly marked placeholder and replace it before final counts.
Make the list easier to use in Excel
Turn the range into an Excel table: select a cell in the headings and guest data, then choose Insert > Table and confirm that the table has headers. A table gives the columns filter buttons, carries formatting into new rows, and expands as you add guests. Use short, unique headings and avoid merged cells in the data area; merged cells interfere with sorting and filtering.
Freeze the heading row so labels remain visible while scrolling. On Windows, choose View > Freeze Panes > Freeze Top Row. The equivalent command is available from the View tab in Excel for Mac, although the menu arrangement can vary by release. You can filter the RSVP column to show only unanswered guests, or filter invitation status to find people whose invitations have not been sent.
For consistent entries, create dropdowns. Select the cells under a status heading, then choose Data > Data Validation. Set Allow to List and enter choices separated by commas, such as Not sent,Sent,Hand-delivered. Repeat for RSVP values such as Awaiting,Attending,Declined. The exact dialog may look slightly different on Mac or Excel for the web, but the data-validation feature is available in current Excel versions. Agree on the wording before entering many rows; “Yes,” “Attending,” and “Accepted” should not all mean the same thing in different rows.
Count invitations and responses with simple formulas
Formulas can summarize the list, but only when the entries are consistent. With RSVP statuses in H2:H151 and individual guests on rows 2 through 151, enter this in a summary cell to count people marked Attending: =COUNTIF(H2:H151,"Attending"). If 28 cells in that range contain Attending, the result is 28 people. This counts guest rows, not invitation households.
To count sent invitations, first use a consistent value such as Sent in the invitation-status column. With invitation status in G2:G151, this formula counts the rows marked Sent: =COUNTIF(G2:G151,"Sent"). If 35 guest rows are marked Sent, the result is 35 people who have a sent invitation status; it does not mean 35 separate envelopes, because several people may share a household invitation.
To find invited guests who have not replied, use the invitation status in G2:G151 and RSVP status in H2:H151. If Sent means the invitation has gone out and an empty RSVP cell means no answer is recorded, enter: =COUNTIFS(G2:G151,"Sent",H2:H151,""). For example, if 35 rows are marked Sent and seven of those RSVP cells are blank, the result is 7 outstanding responses. This formula also counts any sent invitation whose status was accidentally left blank, so review the underlying rows before relying on the total.
On a summary sheet, label each number clearly: “Attending guests,” “Sent guest invitations,” or “Awaiting replies.” A label prevents someone from mistaking a guest count for a household or envelope count. If you use an Excel table, formulas can also use table references, but ordinary cell ranges are often easier for a first-time spreadsheet.
A reliable workflow from first draft to final count
- Draft the people list. Add names and household IDs before sending invitations. Ask the couple and relevant family members to review the proposed list against the venue capacity and budget.
- Record invitation decisions. Mark who is invited and whether each invitation has been sent. Keep people who are only being considered off the active invited list, or give them a separate planning status so they are not included in counts.
- Enter replies promptly. Update RSVP status and date when a reply arrives, whether it comes through a card, email, phone call, or online form. If one person replies for a household, record each person’s answer if attendance or meal choices differ.
- Follow up on missing replies. Filter for sent invitations with blank RSVP cells and compare the results with the response deadline. Record a reply received by phone just as you would an online response.
- Verify the final headcount. Review attendance, children, plus-ones, meals, and special arrangements with the venue or caterer. Save a dated copy of the final version so later edits do not obscure what was sent.
Consider using conditional formatting to make statuses visible at a glance. Select the RSVP cells and choose Home > Conditional Formatting > Highlight Cells Rules, then apply a rule to a value such as Awaiting. Color is a visual cue, not a replacement for the text: keep the actual status in the cell so filtering and formulas continue to work.
Choose the right amount of detail
A template should capture details that someone will act on. Meal choice is useful if the caterer needs it; a dietary note may be important, but it should be specific enough to communicate the requirement accurately. Avoid broad guesses such as “picky eater.” Where a note affects food safety or accessibility, confirm the wording directly with the guest and pass it to the appropriate provider through a suitable channel.
Likewise, do not collect every possible personal detail just because a column is available. Phone numbers, home addresses, children’s names, and health-related notes deserve care. If a detail is not needed for invitations, seating, or event arrangements, leave it out. Use a notes column for concise logistics, not private commentary that could embarrass someone if the workbook is shared.
Common spreadsheet problems to prevent
- Counting households instead of people: a party of four is one invitation address but four guests. Keep household IDs and guest rows separate.
- Inconsistent RSVP wording: mixed values such as Yes, Y, and Attending make filters and counts unreliable. Use a dropdown and correct older entries.
- Blank rows inside the list: a formula that counts blanks across a large unused range can overstate unanswered replies. Count blanks only when the invitation status shows that a reply is due, as in the COUNTIFS example.
- Overwriting a formula: put summaries in a separate area or sheet, and avoid typing over formula cells. Keep a backup before making large changes.
- Sorting only one column: sorting names without the rest of the row can attach the wrong RSVP or meal to a person. Sort the entire Excel table, not an isolated column.
- Using color as the only record: a green fill does not tell a filter or formula that someone accepted. Store a clear text status in the RSVP cell.
Excel, shared workbooks, and alternatives
Excel is a good fit when you want flexible columns, filtering, printable lists, and control over the workbook. Microsoft 365 users can store a workbook in OneDrive or SharePoint and share it for coauthoring, subject to the account and file permissions. Agree on who edits which fields, and avoid sending multiple uncoordinated copies by email; those copies can quickly disagree about the latest RSVP.
Google Sheets or a wedding-planning service may be more convenient if collaborators already use those tools or if a built-in RSVP form is important. A service may collect responses directly, while a spreadsheet gives you more control over layout and analysis. Features and privacy practices differ by provider, so check who can access guest information and how responses are exported before choosing. Excel for the web can handle common list editing and sharing, though some desktop commands and workflows may differ from Windows Excel.
Frequently Asked Questions
Is there a free wedding guest list Excel template?
Microsoft and other template providers may offer downloadable spreadsheets, but availability and design can change. You can also build one yourself from the columns and steps above in a blank workbook. Before using a download, inspect its formulas, fields, and sharing settings rather than assuming every template counts guests the way you need.
Should I use one row per guest or one row per household?
Use one row per person when you need an accurate attendance and meal count. Add a household ID to connect people who share an invitation or address. A household-only list can be useful for mailing labels, but it is less clear for individual replies and catering totals.
How do I count wedding RSVPs in Excel?
Choose a consistent RSVP value, such as Attending, for every person who accepts. With those statuses in H2:H151, =COUNTIF(H2:H151,"Attending") counts the attending guest rows. Check that each person has a separate row and that the range covers the whole list.
How should I track a plus-one who has not been named?
Record the invitation allowance separately from the confirmed guest list, or use a clearly labeled placeholder that is excluded from final counts. Add the companion as a named guest when confirmed, then record their own RSVP and meal choice if needed.
Can I share the guest list with family members?
Yes, but share only with people who need access and use the service’s permission controls. A guest list can contain contact details and sensitive dietary or accessibility information. Limit those fields, avoid public links, and consider giving some collaborators a less detailed copy.
Related
- Vendor Contact List Excel Template: Fields and Setup
- Vendor Comparison Matrix Template in Excel: Scoring Guide
- Vendor Comparison Excel Template: A Practical Setup Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Docs and Excel Sheets: How Password Protection WorksGoogle Docs and Google Sheets do not offer a password you can set to lock an individual file…
- Excel Data Validation Allow List: Create and Manage OneYes. In Excel for Microsoft 365 on Windows, create an allow list by selecting the cells, choosing Data…
- Excel Data Validation List: Remove DuplicatesYes. In Excel for Microsoft 365, create a unique list from the original entries with =SORT(UNIQUE(FILTER(A2:A100,A2:A100<>""))), then use…
- Remove All Formatting in Word Without Losing TextTo remove formatting from a Word document, save a copy, press Ctrl+A on Windows (Command+A on Mac), then…
- How to Make a Bullet List in Two Columns in Microsoft WordTo make a bulleted list flow through two columns in Word, create or select the list, then choose…
- How to Zoom in Microsoft Excel: Quick Ways to ResizeTo zoom in Microsoft Excel on Windows, use the zoom slider at the bottom-right of the Excel window,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.