Wedding Guest List Spreadsheet, RSVP Counts, Meal Choices and Table Numbers, Excel

One row per guest, with counts that update as replies come in.

Guests tab: guest name, household, side, adult or child, mailing address, invitation sent, RSVP, reply date, meal, dietary note, table, gift and thank-you sent. It holds 400 guests. Give people on one invitation the same Household name, and they count as one invitation.

Counts tab: invited, coming, not coming, no reply, invitations and reply rate. Below that, a table by side with adults and children coming, and a table of meals for the guests who said yes. These are the numbers a caterer asks for.

Seating tab: one row per table with its seats, how many are seated, how many are free, and the first 12 names.

No Reply tab: who has not answered, up to 60 lines, with the days since their invitation went out and the address.

The Check column on Guests names what is missing on a row: No meal, No table, Listed twice, Table over seats, Not sent, Chase reply and others.

Setup tab: your own names for the sides, up to 8 meal choices, and up to 40 tables with their seats.

The Example file has 92 made-up guests. The Blank file has starter lists and no guests.

WHAT'S INCLUDED
- Wedding-Guest-List-Example.xlsx, filled in with made-up guests
- Wedding-Guest-List-Blank.xlsx, for your own guests

Tabs in each: Start Here, Setup, Guests, Counts, Seating, No Reply. Digital download. Nothing is shipped.

COMPATIBILITY
An .xlsx workbook with ordinary formulas. No macros and no add-ins. A script recalculated it in LibreOffice 26.8 and compared the results with a separate Python calculation. Another script confirmed it uses no LAMBDA, LET, XLOOKUP or spill formulas. A script also opened this file in Microsoft Excel for Mac 16.114.3 and ran a full recalculation: every cell matched the values stored in the file, with no error cells. That test did not type new data into Excel or look at the screen. Excel for Windows and Google Sheets have not been tried, and the menu steps below have not been tried in Excel or Google Sheets.

QUESTIONS AND HOW-TO
Does it send invitations or reminders?
No. It holds your list and counts it. Addresses stay in your file.

How are plus-ones handled?
Add a row for each plus-one, with the same Household name as the guest.

Who counts in the meal totals?
Only guests marked Yes in RSVP. A guest with no answer counts as Waiting.

Can I draw a seating chart with it?
It lists names by table. It doesn't draw a floor plan.

What happens when more than 12 people sit at one table?
The Seated number still counts everyone. The row shows the first 12 names.

Using this file in Excel
Open the .xlsx file. If a yellow bar says Protected View, click Enable Editing.
Type only in the colored input cells. The other cells hold formulas and are locked so they don't get overwritten by accident.
The Example file has made-up entries so you can see how it fills in. Start your own work in the Blank file.
Before you type anything, use File > Save As and give the Blank file a new name. That keeps a clean copy for next time.
To change a locked cell, go to Review > Unprotect Sheet. There is no password. If you edit a formula, the totals may stop being right.

Copying this file to Google Sheets
Open Google Sheets in a browser and start a blank spreadsheet.
Go to File > Import, choose the Upload tab and select the .xlsx file.
Under Import location choose Replace spreadsheet, then click Import data.
Your copy now lives in your own Google Drive. Name it with File > Rename.
Sheets may not keep the locks from the Excel file, so type only in the colored input cells.

HOW AI WAS USED
AI helped write the listing text, the how-to text, the task lists and the code that builds these files. Scripts tested status, the Check column, every count by side and meal, the seating list and the no-reply list, on 9 sets of test data including households that differ only in capitals, a table exactly full and then one over, a reply deadline falling on the as-of date, more than 12 at one table and a full 400 rows. No person is claimed to have checked it unless stated here.

PLEASE NOTE
This file counts what you type. It sends nothing to anyone. License: for your personal use only. No resale or sharing of this file.