Wedding Guest List Spreadsheet: One Row, Four Counts

Hey folks, it's Ren here.

My kitchen table went through a phase last year where it stopped being a table.

A friend had come over to "just sort the list out" before her wedding, and by nine that night there were three piles on it. Her mum's names on the back of a bank envelope. A half finished note on a phone. A printout from a wedding site with about forty rows and no addresses on any of them.

Every pile had someone the other two did not.

We found her uncle on two of them, spelled two different ways.

She was not disorganised. She had done what almost everyone does, which is start the list in whatever was closest to hand and then never merge it.

The fix took an hour and it was not clever. One sheet, one row per person, and every other count in the wedding reading from that sheet instead of from memory. That is genuinely all a wedding guest list spreadsheet is.

"The ornament of a house is the friends who frequent it." — Ralph Waldo Emerson

📬 Why the list always ends up living in three places

A wedding guest list starts in three places because three different people start it, usually on the same weekend and never in the same file.

One of you opens a note on your phone in the car home from the engagement dinner. Someone's mum writes hers on paper, because that is how she has always made a list. And then a wedding site gets used for about a fortnight before its export turns out to be missing the addresses.

None of that is careless. It is just three reasonable starts that never got merged, and merging is the boring job nobody schedules.

Here is where it costs you:

• Duplicates survive, because the same person is spelled differently in each list.
• The stationery order gets guessed, because nobody knows the real envelope count.
• Addresses arrive months after the names and land in a fourth document.
• RSVPs come back by text, card and phone call, and only some of them get written down anywhere.
• The caterer, the venue and the stationer each get a number from a different pile.

Please do not be hard on yourself if this is you. The guest list is the only wedding document that gets edited by four people over eleven months, and it is the one everybody starts before deciding where it lives.

🧾 What one guest row actually has to carry

One guest row has to carry everything anyone will later ask about that person, because the whole point is that you type each fact once and read it many times.

That sounds obvious right up until you notice how many separate jobs the same row is doing. The row that decides whether Aunty Kath gets an envelope is also the row that decides whether she gets a chicken, whether she gets a seat at table six, and whether she gets a thank you card in March.

Follow one person through and it becomes very clear what the columns need to be.

Column	What it does for you
Guest name	One row per person, so a plus one and a fifteen year old are both real seats.
Household	The key that collapses people into envelopes. This is the column that does the stationery maths.
Side or group	Lets you sort into rough table groups later without starting the seating from nothing.
Tier (A or B)	Decides who is in the first mail wave. Useless if you add it after the invitations go out.
Address and address complete	A tick box for complete turns chasing addresses into a filter rather than a re read.
Save the date sent, invitation sent	Two dates. They are the only proof of who was actually posted and when.
RSVP status	Yes, No or Waiting. Blank and No mean completely different things and must not share a cell.
Age band	Adult, child or under three. Caterers price these differently and highchairs come from here.
Meal choice and dietary	Rides with the seat, so the kitchen count and the seating chart can never disagree.
Table number	One editable field that hands the whole list straight to your seating plan.
Gift received, thank you sent	The two columns everyone adds in week one after the honeymoon, having needed them for a month.

Eleven columns is not a lot to look at, and it is the difference between a list and a system.

If you would rather this sat in the same file as the budget, the checklist and the seating plan instead of on its own, that is exactly the job the whole wedding in one planning spreadsheet was built to do.

🔢 How many invitations do you order for 145 guests?

You do not order 145 invitations for 145 guests, and the gap is much bigger than most couples expect.

Invitations go to households, not to people. A married couple is one envelope. A family of four is one envelope. Across a normal list, the number of households usually lands somewhere around 50 to 60 percent of the number of names.

So a list of 145 names is realistically about 82 envelopes.

Add the buffer every stationer will tell you to add, which is 10 to 15 percent for postal accidents, late additions and a couple of keepsakes, and you order about 95.

Not 145. Ordering 145 is 50 spare suites, and at the 1.50 to 8 dollars a suite that digital and custom printing ran through 2025, that is somewhere between 75 and 400 dollars of paper you will never post, before you have bought a single stamp for them.

Here is the part I almost never see written down anywhere, and it is the reason this sheet earns its keep.

You will type those 145 names once. Then four different people will ask you for a number, and not one of the four numbers is 145.

Who is asking	What they actually want counted	This wedding
The stationer	Distinct households, plus a 10 to 15 percent buffer	95 invitations
The venue	Rows where RSVP equals Yes	120 attending
The caterer	Adult plates, child plates and crew plates, priced separately	126 plates (111 + 9 + 6)
You, in March	Households that sent a gift, including people who could not come	about 92 thank you notes

Every one of those four numbers is a filter on the same sheet. Every one of them is a fresh piece of guesswork if the sheet does not exist.

The 120 comes from the decline rate, which is the other number couples tend to guess. Across the usual published figures roughly 15 to 20 percent of invited guests say no, so 145 names at about 17 percent lands near 120 attending. Destination weddings run much higher, often 30 percent or more, and a small local wedding of close family runs lower.

Which means the honest way to build a guest list is backwards. Decide the number of chairs you can afford, divide by your expected acceptance rate, and that is how many names you are allowed to write down.

🍴 Who is missing from your catering number?

Your catering number is almost always short by the people who are working, because they are not on the guest list and nobody thinks to add them.

Photographers, second shooters, videographers, the band or DJ, and your coordinator are all usually owed a meal, and most of them have it written into the contract as a vendor meal clause. The rule of thumb people use is anyone working four or five hours or more whose shift overlaps dinner service.

Your caterer's own staff are the exception. They feed themselves.

On a normal wedding that is four to eight extra plates. In our worked example it is six, and that is where the 126 came from rather than 120.

Six plates does not sound like a crisis until you find out on the day, when the alternative is a supplier standing in a service corridor at eight at night or a late addition charged at whatever the kitchen feels like charging.

So put them in the sheet. A small block under the guest rows, marked as crew, with their own meal choices and their own count, keeps the catering number honest without polluting the guest count.

And because table count, plate count and hire all move together, it is worth reading the money off at the same time. Our free wedding cost calculator will give you a quick sense of where a headcount change lands before you sign a catering minimum.

⏳ Does a B list actually work?

A B list works, but only if you decide to have one before you post a single invitation, because it is a date problem rather than a list problem.

The standard advice you will see everywhere is to mail invitations about eight weeks out with RSVPs due three to four weeks out. That timing is fine, and it also quietly makes a B list impossible.

Follow it through. If the first wave replies at four weeks, a second wave posted at three weeks arrives with a fortnight to go and a deadline of about ten days. Nobody misreads that. It announces itself.

The version that actually works shifts everything earlier. Mail the A list at twelve weeks with RSVPs due at eight. Then mail the B list at eight weeks with RSVPs due at three to four.

Both waves get the same four weeks to answer. Both waves get a normal looking envelope with a normal looking deadline. The only difference is a date in a column that nobody else can see.

That is the whole trick, and it is why the tier column and the date sent column have to exist before the stationery order rather than after it. A B list is not an extra list. It is a mail schedule you either left room for or you did not.

✅ How to build it in about 30 minutes

1. Merge everything into one sheet before you add a single column. Paste all three lists in, sort by surname, and delete the duplicates first, because every clever thing you build afterwards will otherwise be built on top of your uncle appearing twice.
2. Put one row per person, never one row per invitation. A couple is two rows sharing a household, which is the only structure that lets the same sheet count both envelopes and chairs.
3. Add a household column and let it do the envelope maths. Give everyone who shares an address the same household label, then count the unique labels, and your invitation number stops being a guess.
4. Add tier and date sent columns now, not later. Mark each row A or B and leave two date cells empty, so the mail schedule that makes a B list possible is already in the file when you place the stationery order.
5. Make RSVP a three state dropdown. Yes, No and Waiting, because a tick box cannot tell the difference between someone who declined and someone you still have to chase, and that difference is the entire point in the last fortnight.
6. Add a crew block under the guest rows. List the vendors owed a meal with their own age band and meal choice, so your catering total includes them and your guest total does not.

⚠️ Mistakes that cost you postage

• Ordering invitations off the guest count. Fix it: count households, add 15 percent, and order that, which on a 145 name list is about 95 rather than 145.
• Deleting people who decline. Fix it: set RSVP to No and keep the row, because that row still owes a thank you note if a gift turns up.
• Adding the tier column after the invitations are posted. Fix it: decide A and B before the mail date, since the schedule is the only thing that hides a B list.
• Keeping addresses in a separate document. Fix it: same row, plus a complete tick box, so chasing the last eleven addresses is a filter rather than an evening.
• Giving the caterer the guest number. Fix it: give them adult plates, child plates and crew plates as three figures, because they are priced differently and one of them is invisible on the guest list.

Once the names are settled and the RSVPs stop moving, the same rows do the next job for you, and the seating chart that keeps every table within capacity picks the list up exactly where this one hands it over.

🎯 Your action steps this week

• Merge your three lists into one sheet tonight and count the duplicates you find, because there are always more than you think.
• Label households and count the unique ones, so you know your real envelope number before you talk to a stationer.
• Divide the chairs you can afford by 0.83 and see how many names that actually allows.
• Write your mail dates down now, twelve weeks and eight weeks, if there is any chance you want a B list.
• Ask your photographer, videographer, band and coordinator whether their contracts include a vendor meal, then add the crew block.
• Check the headcount against the cap before the catering deposit, because guest count drives almost everything, and the wedding budget spreadsheet that holds a cap is where that argument gets settled.

⚡ Quick answers

How many wedding invitations do I need for 145 guests?

About 95. Invitations go to households rather than people, and households usually work out at 50 to 60 percent of your guest count, so 145 names is roughly 82 envelopes. Add 10 to 15 percent for mistakes and keepsakes.

What should a wedding guest list spreadsheet include?

Name, household, side or group, tier, address with a complete tick box, save the date and invitation dates, RSVP status, age band, meal choice, table number, and gift received with thank you sent. Eleven columns covers the whole wedding.

Do I have to feed my wedding vendors?

Usually yes, and often contractually. Photographers, videographers, second shooters, the band or DJ and your coordinator are typically owed a meal if they work four or five hours or more across dinner. Your caterer's own staff are not your responsibility.

What percentage of wedding guests usually decline?

Around 15 to 20 percent for a local wedding, so roughly 83 out of every 100 invited turn up. Destination weddings often reach 30 percent or more, and small family only weddings tend to sit lower.

Can I use a B list without anyone noticing?

Yes, if you shift the whole schedule earlier. Mail the A list at twelve weeks with replies due at eight, then mail the B list at eight weeks with replies due at three to four. Both waves get four weeks, so neither looks different.

The kitchen table is a table again, by the way, and the list it produced is still the file that answered every question anyone asked her for the next eleven months.

Type the names once. Let the wedding do its own counting.

To your financial freedom,
Ren

This article is for general information only and is not financial advice. It does not take into account your personal situation, needs or objectives. Please consider speaking with a qualified financial adviser before making financial decisions.