Wedding Guest List Spreadsheet: What You Need to Track

A wedding guest list starts as a list of names.

Then very quickly it becomes much more complicated.

You may need to track:

• households;
• addresses;
• invitations;
• plus-ones;
• RSVP status;
• meal choices;
• dietary requirements;
• children;
• seating;
• hotel information;
• gifts;
• thank-you notes.

That is why a simple list in your phone or notes app can become difficult to manage once wedding planning gets serious.

A wedding guest list spreadsheet gives every guest one clear record and helps you answer questions like:

• How many people have we invited?
• How many have replied?
• How many are attending?
• Who still needs a reminder?
• How many vegetarian meals do we need?
• Which guests have plus-ones?
• Who is sitting at each table?
• Who still needs a thank-you note?

This guide shows you exactly what to track and how to organize it.

Start with one master guest list

Use one master guest list for the wedding.

Avoid keeping separate versions in:

• your phone;
• your partner's notes;
• email;
• paper lists;
• multiple spreadsheets.

Duplicate lists can quickly become inconsistent.

One version should be considered the current, authoritative guest list.

The essential wedding guest list columns

A practical guest spreadsheet can include:

You do not need every field if it does not apply to your wedding.

1. Guest name

Use one row per person whenever possible.

For example:

Instead of:

John and Sarah Smith

use:

• John Smith
• Sarah Smith

Why?

Because individual guests may have different:

• RSVP statuses;
• meal choices;
• dietary needs;
• seating needs.

One row per person makes tracking much easier.

2. Household

A household groups people who receive one invitation together.

Example:

Household

Smith Family

Individual guests

• John Smith
• Sarah Smith
• Emma Smith

This is useful because your invitation count is not always the same as your guest count.

You may invite:

120 people

but send only:

70 invitations

because many guests are grouped into households.

3. Side or relationship

You may want to track how each guest is connected.

For example:

• Partner A family
• Partner B family
• Mutual friends
• Work
• Family friends

This can help when reviewing the guest list for balance or discussing cuts.

Do not use this field to create unnecessary divisions later.

It is simply an organizational tool.

4. Mailing address

If you are sending physical invitations, record the full address.

Useful fields may include:

• Address Line 1
• Address Line 2
• City
• State/Region
• Postal Code
• Country

You can keep the address in one column or split it into several.

Separate columns are better if you plan to use mail merge or export the data.

5. Email address

Email can be useful for:

• digital invitations;
• RSVP reminders;
• wedding updates;
• travel information.

Make sure you have permission to use contact information appropriately and do not share guest details unnecessarily.

6. Phone number

A phone number can help with:

• last-minute contact;
• RSVP follow-up;
• travel issues.

You may not need one for every guest.

Track only information that is genuinely useful.

7. Invitation sent

Add a simple status:

• Yes
• No

Or track the date sent.

Example:

This helps you see whether someone has not replied because the invitation has not actually gone out yet.

8. RSVP status

This is one of the most important fields.

Keep statuses simple.

Recommended options:

• Awaiting Response
• Attending
• Declined

You may also use:

• Not Yet Invited

Avoid creating too many similar statuses such as:

• Maybe
• Probably coming
• Said yes verbally
• Needs to check

Those make totals unreliable.

Until the RSVP is confirmed, keep the guest in Awaiting Response.

9. RSVP response date

You may also want to record when the guest replied.

This is optional, but it can help when reviewing changes or updates.

10. Plus-one allowed

Separate:

Plus-One Allowed

from:

Plus-One Attending

For example:

This prevents you from assuming every permitted plus-one will attend.

11. Plus-one name

If the plus-one is confirmed, record their actual name.

Avoid keeping:

Guest of Alex

once you know who the person is.

They are now an attendee and may need:

• meal choice;
• dietary tracking;
• seating assignment.

12. Children

If children are invited, track them individually.

This can affect:

• catering;
• highchairs;
• seating;
• children's meals;
• entertainment.

You may add fields such as:

• Child
• Age
• Highchair Needed

Only use fields you actually need.

13. Meal choice

If your caterer offers multiple entrees, track each person's choice.

For example:

• Beef
• Chicken
• Fish
• Vegetarian
• Vegan

Use the exact wording from your caterer's menu.

That makes final counts easier.

14. Dietary requirements

Keep dietary requirements separate from meal choice.

For example:

Guest chooses:

Chicken

but has:

Gluten allergy

Those are two different pieces of information.

Possible notes may include:

• gluten-free;
• dairy-free;
• nut allergy;
• vegetarian;
• vegan;
• religious dietary requirement.

For serious allergies, confirm how your caterer wants the information submitted.

15. Accessibility needs

You may want a private field for practical requirements such as:

• wheelchair access;
• step-free seating;
• hearing support;
• transportation assistance.

Only record information guests have shared and that is actually needed for planning.

Treat sensitive information carefully.

16. Table assignment

Once RSVPs are mostly complete, add:

• Table Number
• Seat Number if relevant

Example:

This lets you connect the guest list to the final seating chart.

17. Seating group

Before assigning exact tables, you can use a temporary grouping field.

Examples:

• College Friends
• Bride Family
• Groom Family
• Work Friends

This can make the first seating draft easier.

18. Invitation count vs guest count

These are not the same number.

Example:

Guest count

120 people

Invitation count

70 households

Your spreadsheet should be able to calculate both.

This matters when ordering:

• invitations;
• envelopes;
• postage.

Do not order one invitation per guest unless that is actually how your invitations are structured.

19. Save-the-date sent

If you use save-the-dates, track:

• Sent
• Date Sent

This can help distinguish between guests who received early notice and those added later.

20. Save-the-date returned

Physical mail can be returned.

A field such as:

Mail Returned

can help you identify incorrect addresses before sending invitations.

21. Invitation returned

The same applies to formal invitations.

If mail is returned, update the address before resending.

22. RSVP deadline

Your whole guest list may use one general deadline.

Still, keep that deadline visible at the top of the spreadsheet.

Work backward from your vendors' requirements.

For example:

Caterer's final count due:

September 10

Your RSVP deadline might need to be earlier so you have time to follow up with non-responders.

23. RSVP follow-up status

As the deadline approaches, you may add:

• Follow-Up Needed
• Follow-Up Sent
• Confirmed

This helps manage outstanding responses.

Keep this temporary field simple.

24. How to follow up with guests who haven't RSVP'd

Once the RSVP deadline passes, send a polite message.

For example:

"Hi! We're finalizing our wedding numbers and noticed we haven't received your RSVP yet. Could you let us know whether you'll be able to join us? Thank you!"

You do not need to make the message complicated.

The goal is simply to get a clear answer.

25. Track declined guests instead of deleting them

Do not delete guests who decline.

Set:

RSVP = Declined

Why?

Because you may still need to remember:

• that they were invited;
• whether they sent a gift;
• whether a thank-you note is needed.

Deleting the row loses useful history.

26. Track cancellations separately

A guest may first RSVP yes and later cancel.

You may want a note:

Cancelled after RSVP

This matters if final catering numbers have already been submitted.

27. Track late additions carefully

If you invite additional guests after declines, label them clearly.

For example:

Invitation Round: B

This is optional, but can help you understand how the list evolved.

Avoid creating a visible social hierarchy in anything guests see.

28. Track hotel information if needed

For destination weddings or weddings with many travelers, useful fields might include:

• Hotel
• Room Booked
• Arrival Date
• Departure Date

Only include this if you genuinely need to coordinate accommodations.

29. Track transportation

If you are arranging guest shuttles, add:

• Shuttle Needed
• Pickup Location
• Return Shuttle

This can help calculate transportation capacity.

30. Track rehearsal dinner or other event invitations separately

Not everyone invited to the wedding may attend:

• rehearsal dinner;
• welcome party;
• brunch.

Add separate yes/no fields if needed.

For example:

• Wedding Invited
• Rehearsal Dinner Invited
• Welcome Party Invited

This is much cleaner than maintaining three separate guest spreadsheets.

31. Track gifts

After the wedding, the guest list can become a thank-you tracker.

Add:

• Gift Received
• Gift Description
• Gift Date

Example:

Use whatever level of detail helps you write personal thank-you messages.

32. Track thank-you notes

Add:

Thank-You Sent

with:

• Yes
• No

You may also record the date.

This ensures gifts do not get forgotten after the wedding.

Wedding guest list formulas worth using

A guest spreadsheet can calculate useful totals automatically.

Total people invited

Count all active invited guest rows.

Total attending

Count guests where:

RSVP Status = Attending

Total declined

Count:

RSVP Status = Declined

Awaiting response

Count:

RSVP Status = Awaiting Response

RSVP response rate

Responses Received / Total Invited

Meal totals

Count each confirmed meal type among attending guests.

Table totals

Count attendees assigned to each table.

These summaries reduce manual counting.

Create a guest-list dashboard

A simple guest summary can show:

This lets you see your current status quickly.

Use filters

Filters are one of the most useful spreadsheet features for guest management.

You can filter by:

• RSVP status;
• household;
• meal choice;
• table;
• dietary needs;
• side;
• plus-one status.

For example:

Filter:

RSVP = Awaiting Response

Now you instantly have your follow-up list.

Use dropdowns for consistency

Useful dropdowns include:

RSVP Status

• Awaiting Response
• Attending
• Declined

Invitation Sent

• Yes
• No

Plus-One

• Yes
• No

Thank-You Sent

• Yes
• No

Dropdowns prevent variations such as:

• Yes
• Y
• yep
• sent

which make formulas harder to use.

Use conditional formatting carefully

Helpful examples:

• highlight guests awaiting RSVP after deadline;
• highlight missing meal choices for attending guests;
• highlight attending guests without table assignments.

Avoid making every column a different color.

Formatting should identify an action that needs attention.

How to handle couples and families

One row per individual is generally easiest for final planning.

For example:

Then each person can have an individual:

• RSVP;
• meal;
• table.

You can still calculate household-level invitation counts.

How to organize plus-ones correctly

A common mistake is creating 20 anonymous plus-one rows before you know whether anyone is actually bringing someone.

A cleaner approach:

Step 1

Mark:

Plus-One Allowed = Yes

Step 2

When confirmed, add the person's name.

Step 3

Track them as an individual guest.

This keeps your list more accurate.

How to manage your guest count against venue capacity

Suppose your venue maximum is:

120

Your guest list currently contains:

145

Do not assume everyone will decline until the number works.

Your initial guest list should be built around a number you can realistically accommodate.

If 130 accept and your venue holds 120, you have a serious problem.

How guest count affects your wedding budget

Guest count influences more than catering.

Each additional guest can potentially affect:

• food;
• drinks;
• chairs;
• tableware;
• stationery;
• favors;
• transportation;
• venue capacity.

That is why the guest list should connect to your wedding budget.

For budgeting guidance, see our Wedding Budget Breakdown.

Separate invited count from confirmed count

Your spreadsheet should always show both.

Invited

Everyone invited.

Confirmed

Guests who accepted.

Do not plan final catering quantities from the invited number once RSVPs are available.

Use your caterer's final-count rules.

Wedding guest list mistakes to avoid

Mistake 1: One row per couple

This makes individual meal and RSVP tracking difficult.

Mistake 2: Deleting declines

Keep the history.

Mistake 3: Mixing meal choices with allergies

Track them separately.

Mistake 4: Not tracking plus-ones clearly

Allowed and confirmed are different.

Mistake 5: Multiple guest lists

Keep one master list.

Mistake 6: No RSVP status

A name without status does not tell you enough.

Mistake 7: Waiting too long to collect addresses

If physical stationery is part of your plan, collect addresses early.

Mistake 8: Ignoring household count

This can lead to ordering too many invitations.

Mistake 9: Finalizing seating too early

Wait until RSVPs are mostly complete.

Mistake 10: Sharing sensitive guest information unnecessarily

Only collect and share information required for wedding planning.

Wedding guest list spreadsheet checklist

Your spreadsheet may include:

• ☐To do: Guest Name
• ☐To do: Household
• ☐To do: Side/Relationship
• ☐To do: Address
• ☐To do: Email
• ☐To do: Phone
• ☐To do: Save-the-Date Sent
• ☐To do: Invitation Sent
• ☐To do: RSVP Status
• ☐To do: RSVP Date
• ☐To do: Plus-One Allowed
• ☐To do: Plus-One Name
• ☐To do: Meal Choice
• ☐To do: Dietary Requirements
• ☐To do: Accessibility Needs
• ☐To do: Table
• ☐To do: Hotel
• ☐To do: Transportation
• ☐To do: Gift
• ☐To do: Thank-You Sent
• ☐To do: Notes

Remove anything you do not need.

Wedding guest list spreadsheet FAQ

What should a wedding guest list spreadsheet include?

At minimum, track:

• guest name;
• household;
• invitation status;
• RSVP;
• plus-one;
• meal choice;
• dietary needs;
• table assignment.

Add addresses and contact information if you need them for invitations or communication.

Should couples be on one row or separate rows?

Separate rows are usually better because each person may have a different RSVP, meal choice, or seating need.

Use a household field to group them together.

Should I delete guests who decline?

No.

Mark them as declined so you preserve the history of who was invited.

How do I track plus-ones?

Use separate fields for:

• plus-one allowed;
• plus-one confirmed;
• plus-one name.

Once confirmed, treat the plus-one as an individual guest.

When should I finalize my seating plan?

After most RSVPs are complete and before your venue or stationery deadline.

Avoid locking it too early while attendance is still changing.

Should the guest list be connected to the budget?

Yes.

Guest count can influence catering, rentals, transportation, stationery, and other costs.

Keeping the numbers aligned helps prevent budget surprises.

Final thoughts

A wedding guest list is more than a list of names.

It becomes a working system for:

• invitations;
• RSVPs;
• meals;
• seating;
• transportation;
• gifts;
• thank-you notes.

The key is keeping one clean master list and tracking information consistently.

Use one row per person.

Keep household information separate.

Track confirmed status rather than assumptions.

And update the list whenever something changes.

Want your guest list connected to the rest of your wedding plan?

The Ultimate Wedding Planning Spreadsheet includes guest tracking alongside your budget, expenses, vendor directory, payment schedule, checklist, timeline, ceremony, reception, and planning notes.

For vendor negotiation and savings tools, explore the Wedding Budget-Saver Bundle.