Wedding Invite List Template: Guest Tracking Spreadsheet

Okay so you need a guest list spreadsheet

The first thing you gotta know is that a wedding invite list is basically gonna save your sanity or destroy it depending on how you set it up. I learned this the hard way back in summer 2021 when I had three weddings in the same month and one couple—lovely people, total disaster with organization—kept texting me at like 10pm asking “wait did we invite Sarah’s cousin or not?” because they were tracking guests on random scraps of paper and a Notes app that wasn’t syncing between their phones.

So here’s what you actually need in your spreadsheet. Open Google Sheets or Excel, doesn’t really matter, though I prefer Google because you and your partner can both access it and you won’t have that annoying thing where someone’s working on an outdated version.

The columns you actually need

Start with these basic columns and I promise you can add more later if you want to get fancy:

• Guest Name – full name, first and last
• Guest Category – like “Bride’s Family” or “Groom’s College Friends” or whatever
• Address – you’ll need this for save-the-dates and invites obviously
• Phone Number – trust me on this one
• Email – same, you’ll need it
• Plus One Status – yes/no/maybe
• Plus One Name – if you know it
• Save the Date Sent – date you mailed it
• Invitation Sent – date you mailed the actual invite
• RSVP Status – attending/declined/no response yet
• Number Attending – actual headcount
• Meal Choice – if you’re doing plated dinner
• Dietary Restrictions – this is important don’t skip it
• Thank You Note Sent – you’ll thank yourself later for tracking this

The category thing is more important than you think

When I say Guest Category I mean like actually break it down. You want “Bride’s Parents’ Friends” separate from “Bride’s Friends” because when you’re cutting the list (and you will be cutting the list, everyone does), you need to know where people fall. It’s way easier to say “okay we’re cutting all the parents’ work colleagues” than to scroll through 200 names trying to remember who everyone is.

Some categories I usually see:

• Bride’s immediate family
• Groom’s immediate family
• Bride’s extended family
• Groom’s extended family
• Bride’s friends
• Groom’s friends
• Couple’s mutual friends
• Bride’s work colleagues
• Groom’s work colleagues
• Parents’ friends (bride’s side)
• Parents’ friends (groom’s side)
• Wedding party

The plus one situation that annoys everyone

Okay this is the part that annoyed me so much I almost wrote a whole blog post just ranting about it. People do NOT understand how plus ones work. Your cousin who’s been dating someone for three weeks does not automatically get a plus one. Your friend who’s engaged obviously does. But there’s this whole middle ground where people get weirdly entitled about it.

In your spreadsheet you need to be crystal clear about plus one status from the beginning. I use:

• Yes with named partner – for married couples, engaged couples, long-term partners you know
• Yes open plus one – for wedding party members or guests who are in serious relationships but you haven’t met the partner
• No plus one – everyone else

And then in the Plus One Name column, if you know the person’s name, PUT IT THERE. This prevents the awkward situation where your guest thinks they can bring literally anyone and shows up with some random person you’ve never heard of.

Tracking the paper trail

The Save the Date Sent and Invitation Sent columns seem kinda redundant but they’re not. You need to know when you sent things because inevitably someone will claim they never got their invitation and you need to know if you’re dealing with a mail issue or if they’re just… I don’t know, not checking their mailbox? It happens.

I put actual dates in these columns, like “3/15/2024” not just a checkmark. My cat knocked over my coffee onto my planner once and destroyed three weeks of notes, so now I’m paranoid about having specific dates for everything digital.

The RSVP tracking part that’ll make you crazy

Okay so you’ve sent invitations and now you’re waiting for RSVPs and this is where the spreadsheet becomes your best friend or your worst enemy. Set your RSVP deadline for like 3-4 weeks before the wedding, not 2 weeks, because I’m telling you right now that at least 30% of your guests will not respond by the deadline and you’ll need time to chase them down.

In the RSVP Status column I use:

• Attending
• Declined
• No response – deadline not passed
• No response – PAST DEADLINE (I make this one red)
• Verbal yes (not official)
• Tentative

That “verbal yes” category is for when someone texts you like “omg can’t wait for the wedding!” but hasn’t actually sent back their RSVP card. Don’t count them as attending until you get the actual RSVP because people are weird and flakey.

The number attending thing

This is separate from RSVP status because someone might RSVP yes but their plus one can’t come, or they’re bringing their kids, or whatever. The Number Attending column is your actual headcount that you’ll give to your caterer and venue.

I usually add a column next to this called “Kids Attending” if the couple is doing a family-friendly wedding because you need to know how many kids meals to order and those are usually different from adult meals.

Meal choices will make you lose your mind

If you’re doing a plated dinner with meal choices—like chicken, fish, vegetarian—you need to track this obsessively. And this is where people get so sloppy and then they’re calling me two days before the wedding in a panic because they told the caterer 45 chicken and 30 fish but they actually have no idea because they didn’t write it down properly.

In spring 2023 I had a bride who was tracking meal choices in her head. Just… in her head. She was convinced she could remember who wanted what. She had 120 guests. It was a disaster. We literally had to call like 40 people the week of the wedding to ask again what they wanted to eat.

So your Meal Choice column should have the actual choice (Chicken, Fish, Vegetarian, whatever your options are) and then I also add a Notes column where you can put stuff like “guest says she’s vegetarian but will eat fish” or “requested extra sauce” or whatever weird specific things people tell you.

Dietary restrictions are not optional to track

The Dietary Restrictions column is non-negotiable. You need to know who’s gluten-free, who’s allergic to shellfish, who’s vegan, all of it. And you need to give this information to your caterer in writing, with names attached, not just “three people are gluten-free.”

I’ve seen too many situations where someone with a severe allergy doesn’t get a safe meal because the venue just… forgot, or didn’t take it seriously, or the information got lost somewhere between the couple and the kitchen staff.

Add some helper columns that’ll make your life easier

Okay so beyond the basics, here are some columns that seem extra but are actually gonna save you:

Gift Received – track what gifts you get and from who, makes thank you notes so much easier

Gift Value (approximate) – I know this sounds weird but some couples like to track this for… I don’t know, budgeting purposes? Or just curiosity?

Hotel Block – if you have out-of-town guests, note if they’re using your hotel block

Transportation Needed – if you’re providing shuttles or rides, track who needs them

Rehearsal Dinner – separate yes/no if you’re doing a rehearsal dinner with a smaller group

Bridal Shower Invite – if applicable

Bachelor/Bachelorette Party – if applicable

The formulas that’ll make you look like a genius

At the top of your spreadsheet or on a separate tab, set up some automatic calculations:

• Total number of guests invited
• Total number of guests attending
• Total number of guests declined
• Total number of no responses
• Percentage of RSVPs received
• Total meal count by type

In Google Sheets you can use COUNTIF formulas for this. Like =COUNTIF(J:J,”Attending”) if your RSVP Status is in column J. I’m not gonna write out all the formulas because honestly there are tons of tutorials online and it depends on how your specific sheet is set up, but these automatic counts will save you so much time.

Color coding because we’re visual creatures

Use conditional formatting or just manually color code things. I like to make:

• Wedding party rows highlighted in one color
• VIP guests (like grandparents or whoever) in another color
• Past-deadline no responses in red
• Declined guests in gray (or just hide them honestly)

It just makes it easier to scan the sheet quickly when you’re looking for specific information or trying to figure out patterns.

Share it with the right people only

If you’re using Google Sheets, be really careful about who you share it with. You and your partner obviously need access. Your wedding planner if you have one (hi that’s me). Maybe your parents if they’re heavily involved in the guest list. But you don’t need to share it with your whole wedding party or every family member who’s curious.

And for the love of everything set the permissions correctly. I had a situation where a couple shared their guest list with “anyone with the link can edit” and someone’s friend accidentally deleted like 50 rows and we didn’t notice for two days because we weren’t checking the version history… anyway it was a whole thing.

Keep it updated or it’s useless

The spreadsheet only works if you actually update it. Like I know that sounds obvious but I cannot tell you how many couples start this beautiful detailed spreadsheet and then abandon it three weeks in and go back to tracking things on paper or in their heads or via text messages.

Make it a habit to update the sheet every time something changes. Got an RSVP in the mail? Update it that day. Someone texted you their meal choice? Put it in immediately. I know it feels tedious but I promise you that having everything in one place will reduce your stress exponentially as you get closer to the wedding date.

Also back up your spreadsheet. Download a copy every week or so. I’ve seen people lose entire guest lists because of technical issues or because they accidentally deleted something. Just… back it up.

The B-list strategy that no one talks about

Okay so this is kinda controversial but a lot of couples have an A-list and a B-list. The A-list gets invited first, and if people decline, you invite people from the B-list. It’s not mean, it’s just practical when you have venue capacity limits and budget constraints.

If you’re doing this, add a column called “List” or “Priority” and mark people as A or B. Then when you get declines from the A-list, you know who to invite next from the B-list. Just make sure there’s enough time between sending A-list and B-list invites so it’s not obvious what you’re doing.

I usually recommend at least 2-3 weeks between waves if you’re doing this strategy. And don’t tell people they’re on the B-list, obviously. Some things are better left unsaid.

The whole guest list thing is honestly one of the most stressful parts of wedding planning because it involves so many people’s feelings and expectations and family politics and budget limitations, but having a solid tracking system makes it manageable. You’ll still have moments where you want to elope and skip the whole thing (totally normal), but at least you’ll have data to work with instead of just chaos and sticky notes everywhere