A solid wedding guest list template is the single most important planning tool you will use before the invitations go out. It keeps every name, address, RSVP status, meal preference, and seating note in one place so nothing slips through the cracks. Whether you are planning an intimate 50-person dinner or a 250-guest celebration, the right spreadsheet saves hours of back-and-forth texts, sticky notes, and mental math.
Below you will find a complete, free wedding guest list template you can open in Google Sheets or Microsoft Excel, along with step-by-step guidance on how to customize it for your wedding. We also cover when a simple spreadsheet stops being enough and what to do about it.
Download for Excel (.xlsx) | Download for CSV (Google Sheets)
No email required. No strings attached. Just a clean, functional template.
Skip the spreadsheet. Sorry, Not Invited organizes your guest list with built-in tiers, RSVP tracking, and meal preferences. Try the free demo →
What a Wedding Guest List Template Should Include
Not all templates are created equal. A bare-bones name-and-address list might work for a birthday party, but weddings have layers: plus-ones, dietary restrictions, table assignments, gift tracking, and more. Here is what a well-designed template covers.
Essential Columns
Column | Purpose
Guest Name | Full name as it will appear on the invitation envelope
Partner / Plus-One | Name of the accompanying guest, if applicable
Relationship | How the guest is connected to you (bride's family, groom's coworker, mutual friend, etc.)
Side | Bride's guest, groom's guest, or shared
Mailing Address | Street, city, state, ZIP for sending invitations
Email | For digital save-the-dates or follow-ups
Phone | For last-minute coordination
Invite Sent | Date the invitation was mailed or emailed
RSVP Status | Attending, Declined, Awaiting Response
RSVP Deadline | Date by which you need their answer
Meal Preference | Chicken, fish, vegetarian, vegan, etc.
Dietary Restrictions | Allergies or other notes
Table Number | Assigned seating, if applicable
Gift Received | Check box or date to track thank-you cards
Notes | Anything else: accessibility needs, childcare, travel info
Optional Tabs or Sheets
A single tab can get crowded fast, especially once your count passes 100. Consider splitting your template into multiple tabs:
- Master List -- every person you are considering inviting
- A-List / B-List -- your priority tiers (more on this below)
- RSVPs -- a filtered view showing only confirmed attendees
- Seating Chart -- table assignments and notes
- Budget Tracker -- estimated and actual cost per head
- Gift Log -- what was received and whether a thank-you was sent
According to The Knot's 2024 Real Weddings Study, the average U.S. wedding hosts 117 guests at a cost of roughly $270 per person. That means every single name on your list carries real financial weight. A well-structured template helps you see that impact clearly.
Free Wedding Guest List Spreadsheet: Google Sheets and Excel
How to Use the Template in Google Sheets
Google Sheets is the most popular choice for couples planning together because both partners (and parents, and the wedding planner) can edit the same document in real time. Here is how to get started:
- Download the CSV file. Click the download link above and import it into Google Sheets via File > Import.
- Share with your partner. Click Share in the top-right corner and add your partner's email with Editor access.
- Protect key columns. Right-click a column header, choose "Protect range," and set permissions so only you can edit sensitive data like addresses.
- Use data validation for RSVP status. Select the RSVP column, go to Data > Data validation, and create a dropdown with options: Attending, Declined, Awaiting Response. This prevents typos and makes filtering easy.
- Add conditional formatting. Highlight the RSVP column, go to Format > Conditional formatting, and set rules: green for Attending, red for Declined, yellow for Awaiting Response.
- Create filter views. Go to Data > Create a filter view. This lets each collaborator filter the list (e.g., "show only groom's family") without affecting what others see.
A free wedding guest list Google Sheets template eliminates version-control problems. There is only one file, always up to date, accessible from any device.
Download for Google Sheets (CSV)
How to Use the Template in Excel
If you prefer working offline or your workplace has trained your fingers to think in Excel, the same template works there too.
- Download the .xlsx file. Save it to your computer or OneDrive using the link above.
- Enable editing. If Excel opens the file in Protected View, click "Enable Editing" in the yellow banner.
- Use the Table feature. Select your data range and press Ctrl+T to convert it into an Excel Table. This gives you automatic filter arrows, alternating row colors, and structured references in formulas.
- Add dropdown lists. Select the RSVP column, go to Data > Data Validation > List, and type your options separated by commas.
- Use COUNTIF for totals. In a summary row, use
=COUNTIF(RSVPColumn,"Attending")to get a live headcount. - Pivot tables for analysis. Insert a PivotTable to quickly see breakdowns: how many guests per side, how many vegetarian meals, how many awaiting responses.
A wedding guest list Excel file is a strong choice if you want powerful formulas, pivot tables, or macros. The trade-off is that real-time collaboration requires OneDrive or SharePoint.
Printable Version
Some couples want a printable wedding guest list they can pin to a corkboard or hand to a day-of coordinator. To create one:
- Hide columns that are not needed on paper (email, phone, gift log).
- Set the print area to only the visible columns.
- Use landscape orientation and narrow margins.
- Set rows to repeat at top so headers print on every page.
- Export as PDF for easy sharing.
A printed list works well as a backup on the wedding day itself, even if you manage everything digitally up to that point.
How to Organize Your Wedding Guest List Template
Having columns is one thing. Filling them in strategically is another. Here is a step-by-step approach to organizing your wedding guest list so it actually helps you make decisions.
Step 1: Brain Dump Every Name
Open your template and list every person you can think of inviting. Do not filter yet. Include family, friends, coworkers, neighbors, your parents' suggestions, everyone. The goal is to get every possible name out of your head and into the spreadsheet.
Step 2: Assign Tiers (A-List and B-List)
Not every name carries the same weight, and that is okay. Create a Tier column and label each guest:
- A-List -- Must invite. You cannot imagine the day without them.
- B-List -- Would love to have them there, but the wedding still feels complete without them.
- C-List -- Nice to invite if budget and venue allow.
This tiered approach is the most practical way to decide who to invite to your wedding when you are over capacity. Send A-List invitations first. As declines come in, move B-List guests up.
Step 3: Set a Hard Number
Your venue capacity and budget set a ceiling. Calculate your maximum guest count using this formula:
Total Budget for Reception / Cost Per Guest = Maximum Headcount
If your reception budget is $30,000 and your venue charges $250 per plate, your ceiling is 120 guests. Write that number at the top of your spreadsheet and reference it every time you are tempted to add "just one more."
Step 4: Handle Plus-Ones
Plus-one policies cause more guest list stress than almost anything else. Establish clear rules early and apply them consistently:
- Married or engaged couples always get a plus-one.
- Couples living together for six months or more are typically invited together.
- Single guests in the wedding party usually receive a plus-one.
- All other single guests may or may not receive a plus-one depending on budget.
Add a Plus-One Eligible column (Yes / No) and a Plus-One Name column. If the name is blank, the guest has not told you who they are bringing yet. Follow up before the RSVP deadline.
Step 5: Color-Code for Clarity
Color coding is the fastest way to scan a large spreadsheet. Here is a scheme that works well:
Color | Meaning
Green | Confirmed attending
Red | Declined
Yellow | Awaiting RSVP
Blue | Invitation not yet sent
Gray | On the B-List (not yet invited)
Purple | Needs follow-up (missing address, dietary info, etc.)
In Google Sheets, use conditional formatting rules tied to cell values so colors update automatically as you change data.
Customization Tips for Your Wedding Guest List Template
Every wedding is different. Here are ways to adapt the template to fit your situation.
Destination Weddings
Add columns for Travel Confirmed, Hotel Block Reserved, and Arrival Date. Destination weddings tend to have higher decline rates (often 30-40%), so your B-List strategy becomes even more important.
Multi-Event Weddings
If you have a rehearsal dinner, welcome party, morning-after brunch, or other satellite events, add a column for each event with a Yes / No indicator. This prevents the awkward moment of forgetting to invite someone to the rehearsal dinner who should obviously be there.
Cultural or Religious Considerations
Some weddings involve separate ceremonies (e.g., a church wedding and a reception, or a mehndi and a baraat). Add a Ceremony column to track which guests are invited to which parts of the celebration. For guidance on who to invite to your wedding when navigating family expectations across cultures, clear categories in your spreadsheet make the conversations easier.
Child-Free Weddings
Add a Children Invited column. If you are hosting a child-free wedding, this column helps you keep track of which families need to arrange childcare and whether any exceptions have been made (e.g., a nursing infant).
When a Spreadsheet Is Not Enough
A free wedding guest list spreadsheet handles the basics well, but it has real limitations once your planning gets more complex:
- No built-in scoring. Spreadsheets cannot help you objectively rank guests when you are 30 people over capacity. You end up relying on gut feelings and whatever name you happen to see first.
- Collaboration gets messy. Even in Google Sheets, two people editing the same row at the same time can create conflicts. And when parents want input, sharing a raw spreadsheet can lead to accidental deletions.
- No visual overview. You can build charts in Excel, but they require manual setup and do not update dynamically in a way that helps you make fast decisions.
- RSVP tracking is manual. Every response has to be typed in by hand. There is no automated flow from receiving an RSVP to updating the count.
- Version history is hard to follow. Google Sheets has version history, but reviewing who changed what and when is tedious once you have several collaborators.
These are the exact problems that purpose-built guest list tools solve. If you find yourself spending more time managing the spreadsheet than actually making decisions, it may be time to upgrade.
Ready to go beyond a spreadsheet? Sorry, Not Invited is a wedding guest list app that lets you and your partner score and rank every potential guest, manage tiers automatically, track RSVPs, and make tough decisions together without the spreadsheet headaches. Try the free demo →
Wedding Guest List Template: Quick-Start Checklist
Use this checklist to go from blank spreadsheet to working guest list in one sitting:
- Download the template (Excel) or CSV for Google Sheets.
- Brain dump every possible name into the Master List tab.
- Add the Relationship and Side columns for every entry.
- Assign A / B / C tiers to each guest.
- Calculate your maximum headcount based on venue and budget.
- Set plus-one rules and mark eligibility.
- Collect mailing addresses (start early -- this takes longer than you think).
- Apply conditional formatting for RSVP status.
- Share the sheet with your partner and set editing permissions.
- Review and update weekly until invitations go out.
Frequently Asked Questions
How many guests should I invite to my wedding?
The average U.S. wedding in 2024 had 117 guests, according to The Knot. However, the right number depends entirely on your budget, venue capacity, and personal preference. A good rule of thumb is to start with your maximum headcount (budget divided by cost per guest) and work backward. Expect roughly 15-20% of invited guests to decline, so you can invite slightly above your target and still land near your ideal count.
What is the best format for a wedding guest list -- Google Sheets, Excel, or an app?
Google Sheets is best for couples who want free, real-time collaboration from any device. Excel is better if you need advanced formulas, pivot tables, or offline access. A dedicated app is the best choice when you need scoring, ranking, or automated RSVP tracking. Many couples start with a spreadsheet and move to an app once the list grows past 100 names or when difficult cut decisions need to be made.
How do I handle the B-List without offending anyone?
The B-List is standard wedding planning practice, and most guests will never know they were on it. The key is timing. Send A-List invitations 8-10 weeks before the wedding. As declines come in, send B-List invitations promptly, ideally no later than 5 weeks before the date. Use the same invitation style so there is no visible difference. Your spreadsheet template should track invitation sent dates so you can manage this timeline precisely.
Should I give every guest a plus-one?
No. Plus-ones are generous but expensive. At $270 per guest, every additional plus-one is a meaningful budget decision. Standard etiquette says married couples, engaged couples, and cohabiting partners are always invited together (these are not plus-ones; they are named invitations). Beyond that, plus-ones for single guests are at your discretion. Be consistent with whatever rule you set, and communicate it clearly on the invitation.
How do I track RSVPs in my guest list spreadsheet?
Add an RSVP Status column with a dropdown menu (Attending, Declined, Awaiting Response) and an RSVP Date column for when the response came in. Use a COUNTIF formula to keep a running total at the top of your sheet. Set a calendar reminder to follow up with non-responders one week after the RSVP deadline. A polite text or email is perfectly appropriate for chasing down responses.
When should I start building my wedding guest list?
Start as soon as you are engaged, or at least 9-12 months before the wedding. The guest list drives nearly every other decision: venue size, catering budget, invitation quantity, and seating layout. Beginning early gives you time to collect addresses, negotiate with family members about their additions, and make tier decisions without the pressure of a looming deadline. Use your template from day one so every name and note is captured in one place.
Last updated: February 2026