Wedding List Excel Template: Set Up, Track and Share

How-to basics · Updated November 20, 2026

A wedding list Excel template is a workbook for organizing wedding guests, invitations, RSVPs and related details; it can also track gifts if you add a separate registry sheet. In Excel for Microsoft 365 on Windows, start with a blank workbook, create columns for each piece of information you need, and format the range as a table with Insert > Table. A good template keeps the guest list, response status and follow-up tasks easy to update without mixing private details into a document everyone can edit.

What “wedding list” can mean

The phrase can refer to two different lists. A guest list records people invited to the wedding and their responses. A wedding gift list, sometimes called a registry list, records gifts, who gave them and whether a thank-you note has been sent. Some couples use “wedding list” to mean both, so decide what you need before building a workbook. Keeping the lists on separate worksheets makes it easier to control access and avoid confusing a gift entry with an invitation record.

A guest tracker is most useful when more than one person is helping with invitations, when the event has several functions, or when you need to keep track of meal choices and accessibility requests. A gift tracker is useful for reconciling cards and presents after the wedding. Neither needs to be elaborate: the best template contains the information you will actually maintain, not every possible field.

Plan the workbook before entering names

Use one worksheet for the master guest list and add separate worksheets only for tasks that benefit from their own structure. For example, a workbook might have tabs called Guests, Gifts and Summary. Keep one row per invited person if you need individual meal choices or attendance details. If invitations are addressed to households, add an invitation or household ID so you can group guests without losing individual information.

Before adding data, agree on consistent terms. Use “Pending,” “Yes” and “No” for RSVP status rather than mixing “Not replied,” “Maybe” and blank cells. Decide whether children count as guests in your totals and how you will record plus-ones. These choices matter because a summary formula can only count consistently entered values. Avoid using color as the only way to communicate status; text labels remain understandable when printed or viewed by someone who cannot distinguish the colors.

Useful guest-list columns

A practical starting layout has one person per row, with a header row at the top. You can rename or remove columns to match your plans. Common fields include:

  • Guest ID: A short, unique identifier can help link a person to an invitation or household.
  • First name and last name: Separate fields make sorting and addressing easier than storing every name in one cell.
  • Household or invitation ID: Use the same ID for people receiving one invitation, while retaining separate guest rows.
  • Contact details: Add only what is needed to send the invitation or follow up.
  • Invite status and date sent: These distinguish a planned invitation from one already mailed or sent.
  • RSVP status and response date: Use a consistent status such as Pending, Yes or No.
  • Meal choice, dietary note and access request: Record relevant arrangements carefully and share them only with people who need them.
  • Event attendance: If there is a rehearsal dinner or another separate event, track its response in a distinct column.
  • Notes: Keep this field factual and appropriate for anyone with workbook access.

Do not use a single “guest count” cell for a whole invitation if individuals have different responses or meal needs. Instead, list each person and use the household ID to see who belongs together. That approach also makes it clearer whether a plus-one has been named, is still unknown or has not been offered.

Build the template in Excel

In Excel for Microsoft 365 on Windows, open a blank workbook and type the column headings in row 1. Enter one person per row, select the range and choose Insert > Table. Confirm that “My table has headers” is selected. A table supplies filter controls in the header row and expands as you add rows, which is more reliable than applying formatting to a fixed range that may not include later guests.

Use clear worksheet names and freeze the header row so column names remain visible while scrolling. On Windows, choose View > Freeze Panes > Freeze Top Row. For controlled values such as RSVP status, select the response cells and choose Data > Data Validation. Set Allow to List and enter consistent options, such as Pending,Yes,No, so users can choose a value instead of typing variations. If the list separator in your Excel settings differs, use the separator Excel expects.

To make the status easier to scan, select the RSVP cells and choose Home > Conditional Formatting > Highlight Cells Rules. Conditional formatting should reinforce the words, not replace them. For example, a light fill can distinguish Pending from Yes, but retain the actual status text so the sheet still works in printouts and when colors are unavailable. In Excel for Mac, the same features are available through the ribbon, though some dialog layouts and shortcut keys differ. Excel for the web also supports tables and data validation, but available controls can vary by feature and account.

Simple formulas for a useful summary

Formulas can report attendance without manually recounting every response. Put a small summary area on a Summary worksheet or above the table. Check that the status values are consistent before relying on the results; a formula counting “Yes” will not count a cell that says “Attending.”

With RSVP status in B2:B101, where each cell contains Yes, No or Pending, enter =COUNTIF(B2:B101,"Yes") to count confirmed individual attendees. If 78 cells contain Yes, the formula returns 78. This is a people count, not a count of invitation envelopes; a household that includes two guests with Yes responses contributes two.

With the same status range B2:B101, enter =COUNTIF(B2:B101,"Pending") to count responses still outstanding. If 14 guests have Pending status, the result is 14. If your workbook uses a different label, replace the text in the formula with the exact label used in the cells.

For an invitation mailing count, the appropriate formula depends on how the sheet is organized. If invitation IDs are in C2:C101 and each invited person has a row, a simple count of nonblank IDs counts people, not unique invitations. Do not treat that result as an envelope total. You can instead maintain a separate invitation table with one row per household and count its records, or carefully review the grouped IDs. This prevents the common mistake of sending the wrong number of invitations because a household was counted once per guest.

Track gifts without confusing them with guests

For a gift worksheet, use one row per gift or card. Useful columns include received date, giver name as written on the card, gift description, event or source, thank-you status and note-sent date. If a gift is shared by several people, record the names together as appropriate and consider a separate notes field. Keep the wording neutral and avoid putting account details or other unnecessary sensitive information in the workbook.

With thank-you status in I2:I50 and each entry set to Sent or Pending, use =COUNTIF(I2:I50,"Pending") to count outstanding thank-you notes. If 9 entries say Pending, the result is 9. The count represents gift records, not necessarily individual recipients: one shared gift may require one note or a different arrangement. A spreadsheet is a reminder system, so review the actual card and circumstances before sending a note.

Sharing, privacy and backup

A guest workbook may contain addresses, contact information, dietary notes or accessibility requests. Share it only with people who need those details, and use view-only access when collaborators do not need to change the master list. With a workbook saved to OneDrive or SharePoint, use Excel’s Share controls to invite named collaborators and choose their access. Avoid sending multiple attachments around by email: different copies can quickly acquire conflicting RSVP updates.

Before sharing, remove columns that a particular helper does not need. Someone confirming meal numbers may need meal choices but not postal addresses. Keep a separate copy before making major structural changes, and make sure the current workbook is saved in a suitable location. A password or a hidden worksheet should not be treated as a substitute for careful sharing permissions. If you export a copy as CSV, remember that CSV stores plain tabular text for one sheet and does not preserve workbook formatting, formulas or other worksheets.

Common problems and how to prevent them

  • Duplicate names: Two guests can share a name. Add a household or guest ID and compare contact or invitation details before deleting a suspected duplicate.
  • Inconsistent responses: “Yes,” “Attending” and “Confirmed” are different text values to a counting formula. Use data validation and agree on a small set of labels.
  • Counting invitations as people: A household invitation may cover several attendees. Track people individually and keep a separate invitation-level record if envelope totals matter.
  • Overloading one column: A cell containing a name, meal choice and note is difficult to sort and summarize. Separate fields make later updates safer.
  • Accidental sorting of only part of the list: Format the range as a table and use its header filters so records stay together when sorted.
  • Unclear ownership: If several people edit the workbook, decide who resolves conflicting updates and who maintains the final master copy.
  • Too much personal detail: Record only information that supports a real planning task, and limit access to sensitive notes.

Excel template versus other options

Excel is a good fit when you want flexible columns, offline editing or a workbook that can be tailored to several events. It can sort, filter and summarize a list without requiring a specialized wedding-planning service. Its trade-off is that you must define your own process: it will not automatically manage invitations, guest-facing RSVP pages or registry reservations just because you have entered the data.

A shared online spreadsheet can make collaboration convenient, but a dedicated planning service may offer built-in RSVP collection or guest messaging. A paper list can work for a small event, although updating and counting it becomes less convenient as responses arrive. Choose based on how many people need access, whether guests will reply online, and whether you want a flexible tracker or a managed planning workflow. You can also use Excel as the private master list while collecting responses through another service, then reconcile updates deliberately.

Frequently Asked Questions

Is there a wedding list template in Excel?
Excel may offer templates through its template gallery, but available templates can change. You can also create a simple one by entering your own headers, selecting the range and choosing Insert > Table. Check that any downloaded template has the fields and privacy approach you need before adding personal information.

Should I use one row per guest or one row per household?
Use one row per guest when people need individual RSVP, meal or access details. Add a household or invitation ID to group people who receive one invitation. A separate invitation table can be useful if you need to count envelopes independently from attendees.

How do I count wedding guests who accepted in Excel?
If the RSVP column contains the exact word Yes, use COUNTIF on that column, for example =COUNTIF(B2:B101,"Yes") when responses are in B2:B101. The result counts rows marked Yes, so structure the list with one row per person if you want a people total.

Can I share a wedding guest list with family?
Yes. Save the workbook in OneDrive or SharePoint and use Share to give selected people view or edit access. Consider removing contact or sensitive planning columns for anyone who does not need them, and agree on who updates the master list.

Can I use the same workbook for guests and gifts?
Yes, but use separate worksheets and distinct columns for each purpose. Guest records and gift records have different units: one guest is not necessarily one invitation, and one gift record is not necessarily one giver. Separate sheets make those distinctions clearer and reduce accidental edits.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.