Wedding Guest List Template in Google Sheets: Organize Contacts, RSVPs & Meals
Your guest list drives almost every wedding decision — from venue capacity to catering costs. If it lives across messages, notes and random files, mistakes are guaranteed. A well-structured Google Sheets guest list keeps everything in one place, easy to update and share with your partner.
Still setting your numbers? Read our guide: Wedding Budget Spreadsheet.
Why Use a Guest List Spreadsheet (Not Apps or Notes)
-
Single source of truth: contacts, RSVPs, meals, and seating data in one sheet.
-
Real-time collaboration: edit with your partner/family without version chaos.
-
Simple filtering & counts: see totals by status, meal, family side, children, etc.
-
Future-proof: export to seating, vendor printouts, and thank-you tracking.
What to Include in Your Guest List (Columns & Categories)
Guest & Household Info
-
Household ID (e.g., H-001), Last Name / Household Name
-
Guest First Name, Last Name, Role/Side (Partner A / Partner B / Both)
-
Party Size, Adults, Kids, Plus-One Allowed? (Yes/No)
Contact & Address
-
Email, Phone, Street, City, State/Region, ZIP/Postal, Country
Attendance & RSVP
-
Invite Sent? (Yes/No/Date)
-
RSVP Status (Invited / Attending / Declined / No Response)
-
Headcount (1 per person; auto-sum for households)
-
Notes (travel, accessibility, room block, etc.)
Meal & Dietary
-
Meal Choice (Beef / Chicken / Veg / Vegan / Kids / Other)
-
Dietary Needs (allergies, gluten-free, halal, kosher)
Seating & Logistics
-
Table Name/Number, Seat #
-
Group (Family, College, Work, etc.)
Gifts & Thank-You
-
Gift, Thank-You Sent? (Yes/No/Date)
Set Up Your Google Sheet (Step-by-Step)
1) Create the Sheet & Freeze the Header
-
Name it “Wedding Guest List”.
-
Row 1 = headers. View → Freeze → 1 row for easy scrolling.
2) Add Data Validation (clean inputs)
-
RSVP Status: Data → Data validation → Dropdown: Invited, Attending, Declined, No Response.
-
Meal Choice: Dropdown list for your catered options.
-
Plus-One Allowed?: Dropdown Yes/No.
3) Use Conditional Formatting (quick visuals)
-
Color rows where RSVP Status = “No Response”.
-
Color Dietary Needs cells when not empty.
4) Basic Totals (ready-made formulas)
-
Total Guests Invited:
=COUNTIF(RSVP_Status_Range,"<>")(or count names) -
Attending (People):
=COUNTIF(RSVP_Status_Range,"Attending")(if one row per person) -
Declined:
=COUNTIF(RSVP_Status_Range,"Declined") -
Kids Attending:
=SUM(Kids_Column) -
Meal Counts: e.g., Beef
=COUNTIF(Meal_Choice_Range,"Beef")(repeat per option)
Tip: Put these summary cells at the top of the sheet so headcounts are always visible.
5) Create Filter Views
-
Data → Create a filter.
-
Save filter views for “No Response”, “Kids only”, “Partner A side”, “Vegetarian”, etc.
Managing +1s, Kids & Households (Without Chaos)
Two reliable setups:
A) One Row per Person (most flexible)
-
Every individual (including +1s and kids) gets a row.
-
Use Household ID to tie people together.
-
Totals and meal counts are precise; seating is easier.
B) One Row per Household (compact)
-
One row per invitation; use Party Size, Adults, Kids columns.
-
Faster for small weddings; less detail for meals/seating later.
Recommendation: One row per person for clarity and smoother seating.
Tracking RSVPs and Meal Choices
-
Record replies as they arrive (email, phone, text, website).
-
Change RSVP Status and Meal Choice immediately.
-
Use a filter view “Missing Meal Choice” to chase gaps before the catering deadline.
-
For destination weddings, add Travel & Accommodation notes to households.
How to Connect Guest List → Seating Chart
-
Finalize Attending counts.
-
Group guests by families/friends and flag special constraints (mobility, kids near parents).
-
Assign Table Name/Number and Seat # columns.
-
Export a venue-friendly PDF of Table → Guests for setup and the caterer.
Want it smoother? The Wedding Dream Planner Bundle links Guest List ↔ Seating ↔ Timeline so updates flow automatically.
Common Mistakes to Avoid
-
Mixing people and households randomly (choose one structure and stick to it).
-
Forgetting kids or +1s in totals → headcount shocks later.
-
Not using dropdowns → messy data, wrong counts.
-
Tracking meals in notes instead of a proper column.
-
Ignoring dietary needs until the week of the wedding.
-
Leaving “No Response” guests untouched — schedule one follow-up date.
FAQ: Wedding Guest List Spreadsheet
Q1: Excel or Google Sheets?
Google Sheets is perfect for sharing live; Excel is great offline. Both work — choose what suits your workflow.
Q2: One row per person or per household?
For accuracy with meals/seating, use one row per person and tie them with a Household ID.
Q3: How do I keep headcounts accurate?
Use dropdowns for RSVP Status and formulas like COUNTIF to total Attending by people and by meals.
Q4: How do I manage last-minute changes?
Keep filter views for “No Response” and “Changes This Week”. Update immediately and re-export seating PDFs.
Q5: What about privacy?
Limit edit access to trusted people. Avoid sensitive data beyond what you need for the event.
Final Thoughts
A clean guest list is the backbone of a smooth wedding day. With Google Sheets, you’ll keep invites, RSVPs, meals, and seating organized — without app overload or confusion.
Ready to skip the setup and use a proven system?
The Wedding Dream Planner Bundle includes an integrated Guest List, Seating Chart, Timeline, Vendor Comparison, and more — built to work together.
👉 Get the Wedding Dream Planner Bundle and plan with confidence.