Free Wedding Guest List Template for Excel & Google Sheets

Use one row per person and one shared household ID in your wedding guest list so addresses, RSVPs, meals, events, and shuttle seats stay countable. It sounds fussy now, but it prevents the classic spreadsheet disaster where “Jordan and Casey” are one cell, two meals, and three different event responses.

The free CSV below opens in Google Sheets, Excel, and Apple Numbers. It starts blank, keeps your data portable, and includes both household-level and person-level fields.

Download the free wedding guest list template (.csv)

The file contains headers but no guest data. Import it into your spreadsheet app, duplicate a clean backup, then begin with one row per invited person.

How to Open the Template

Use the instructions for your spreadsheet app, then save a working copy before changing columns or adding guests. That untouched backup is much easier to return to than a heavily formatted sheet with a broken import.

Google Sheets

1. Download the CSV above.
2. Open a blank Google Sheet.
3. Select File → Import → Upload.
4. Choose the CSV.
5. Select Replace spreadsheet or Insert new sheet, then import.

Microsoft Excel

1. Download the CSV.
2. Open it in Excel.
3. Select File → Save As.
4. Save a working copy as .xlsx so filters, colors, and formulas are preserved.

Apple Numbers

Open the downloaded CSV in Numbers, then save the document as a Numbers file before adding formatting.

What Every Column Is For

You do not need to fill every field on day one. Start with identity, household, and contact information; add RSVP and logistics fields when those parts of planning open.

Column group	Fields	Why it matters
Household	Household ID, party name	Groups people receiving one envelope
Identity	First name, last name, relationship	Supports place cards and sorting
Contact	Address, email, mobile	Mailing and direct updates
Invitations	Save-the-date sent, invitation sent	Prevents duplicate or missed sends
RSVP	Status, plus-one, meal, dietary needs	Builds the final headcount
Events	Welcome event, rehearsal, brunch	Tracks separate attendance
Logistics	Hotel, transportation needed	Supports shuttles and blocks
Follow-up	Gift, thank-you sent, notes	Closes the loop after the wedding

One Row Per Person, Not Per Couple

This is the structural choice that makes every later count work. Use the same household ID for everyone sharing an invitation, but give each person a separate row:

Household ID	First name	Last name	Party name	RSVP	Meal
H-001	Jordan	Lee	Lee household	Yes	Salmon
H-001	Casey	Lee	Lee household	Yes	Risotto
H-002	Morgan	Diaz	Morgan Diaz	Pending

This structure lets you count people, meals, and shuttle seats without splitting text inside one cell. It also lets one member of a household attend when another declines.

Recommended Dropdown Values

Consistent values make filtering reliable and stop “yes,” “Y,” and “probably” from becoming three different RSVP statuses. Customize the labels once, then use dropdowns instead of free typing.

RSVP status

• Not invited
• Invited
• Pending
• Yes
• No
• No response
• Waitlist

Yes/no fields

• Yes
• No
• Not applicable

Invitation group

• A list
• B list
• Family
• Couple’s friends
• Partner one’s family
• Partner two’s family
• Wedding party
• Vendors

Use whatever labels fit your wedding, but decide them once. “Maybe,” “probably,” and “I think so” should live in Notes, not in the official RSVP field.

Five Useful Spreadsheet Formulas

These formulas are useful once responses start arriving and you need quick totals for vendors. In the downloaded template, RSVP Status is column P, Meal Choice is column S, and Transportation Needed is column Y. The formulas below use those verified positions. Confirm the column letters in your copy before pasting them because inserting a new column changes every reference.

Confirmed guests

=COUNTIF(P:P,"Yes")

Pending responses

=COUNTIF(P:P,"Pending")

No response

=COUNTIF(P:P,"No response")

Salmon meals

=COUNTIF(S:S,"Salmon")

Shuttle seats

=COUNTIF(Y:Y,"Yes")

Build Five Working Views

You need different views for mailing, catering, and transportation, but not different versions of the truth. Create filtered views of the same data:

1. Mailing view: party name, address, invitation-sent fields.
2. RSVP follow-up: pending and no-response guests with mobile numbers.
3. Catering view: attending guests, meal choice, dietary needs.
4. Transportation view: attending guests, hotel, shuttle need.
5. Thank-you view: gift received and thank-you status.

One source of truth prevents a corrected name from remaining wrong in a second spreadsheet.

Guest List Rules to Decide Before Adding Names

Write down the rules before the emotional part begins. A consistent rule will not make every guest-list decision easy, but it gives you something firmer than deciding household by household at midnight.

• Are children invited?
• Which guests receive a plus-one?
• How long must a couple be together to receive a joint invitation?
• Are coworkers invited as a group or individually?
• Are reciprocal invitations a factor?
• What is the venue’s true seated capacity?
• Is the working limit lower than capacity to allow vendors and last-minute needs?
• Will there be a B list, and when will it be contacted?

Then apply the rules consistently. If a rule needs an exception, note the reason privately in the sheet instead of inventing a second unofficial rule.

Protect Guest Data

The sheet contains home addresses, contact details, dietary information, relationships, and travel plans. Treat it like a private planning document, not a link anyone with the URL can open:

• Share edit access only with the people managing the list.
• Give vendors a filtered export containing only what they need.
• Do not send the caterer phone numbers or addresses.
• Do not put the sheet on a public link.
• Remove access for former vendors or helpers.
• Delete unnecessary exports after the wedding.

If you collect accessibility or medical details, keep the notes factual and limited to the arrangement being provided.

Moving From Spreadsheet to Invitations and Messages

The master sheet should power each phase without being copied into a new uncontrolled version. Filter, export only the columns needed for the task, and record the result back in the master.

Before save-the-dates:

1. Filter for invitees.
2. Confirm party names and postal addresses.
3. Run a duplicate check on names and addresses.
4. Export only the mailing columns.
5. Mark the send date in the master sheet.

Before invitations:

1. Confirm plus-one and child eligibility.
2. Add RSVP lookup names exactly as guests will search them.
3. Test four household types in the RSVP system.
4. Mark the invitation send date.

At the RSVP deadline:

1. Filter Pending and No response.
2. Check that a partner did not respond for the full household under a different name.
3. Send one clear reminder.
4. Record replies in the master sheet immediately.

Use our wedding RSVP questions guide to build the form, then our RSVP reminder timeline and scripts when responses slow down.

Spreadsheet vs. Wedding Guest List App

Choose a spreadsheet for control and portability, an app for guest-facing automation, or both when different tools do different jobs well. The deciding question is not which looks prettier; it is where the current source of truth will live.

Use a spreadsheet when…	Use an app when…
You want full control over columns	You want invitation and RSVP integration
Several vendors need custom exports	You prefer guest-facing forms
You are comfortable with filters	You want household logic handled for you
You want a free, portable file	You value automated reminders

Many couples use both: the wedding platform collects responses, while a spreadsheet remains the planning master. Export regularly and keep one clearly named current version.

Daisy Chat can put the mobile-number and invitation-group columns to work. Send an update to the whole list or one segment, then let guests text back with questions that are answered from your wedding website.

Frequently Asked Questions

What columns should a wedding guest list spreadsheet include?

Include household ID, name, relationship, invitation group, postal address, email, mobile number, save-the-date and invitation status, RSVP status, plus-one, meal, dietary needs, event attendance, hotel, transportation, gifts, thank-you status, and notes.

Should couples share one row in a guest list template?

No. Give each invited person a separate row and use a shared household ID to connect people receiving one invitation. This makes headcounts, meal totals, place cards, event attendance, and transportation counts accurate.

Can this wedding guest list template be used in Google Sheets?

Yes. Download the CSV, open a blank Google Sheet, and use File, Import, Upload. Save an untouched backup before adding data, then use dropdowns and filter views to keep entries consistent.

How should plus-ones be tracked?

Use one field to record whether a plus-one is allowed and a separate row for the plus-one once their name is known. Assign both guests the same household ID. Do not count an unnamed plus-one as a confirmed guest until the RSVP is received.

Who should have access to the wedding guest list?

Limit edit access to the couple, planner, and anyone actively managing invitations. Send vendors filtered exports containing only the fields they need. Avoid public links because the list contains addresses, contact details, relationships, and travel information.