Blue title card reading Wedding Guest List, RSVP, meals and tables, counted live, with a tablet showing the Counts tab.
  • Blue title card reading Wedding Guest List, RSVP, meals and tables, counted live, with a tablet showing the Counts tab.
  • The Guests tab, a wide table of made-up guests with household, side, RSVP, meal, table and status columns and yellow input cells.
  • The Counts tab with cards for invited, coming, not coming, no reply, invitations and reply rate, then tables by side and by meal.
  • The Seating tab, one row per table with seats, seated, free and up to twelve guest name columns, filled with made-up names.
  • The No Reply tab with a reply deadline, counts of no reply and not sent yet, and a list of guests with days since invitation.
  • The Setup tab with yellow cells for wedding name, reply deadline, side names, meal choices and a list of tables with seats.
  • Two panels: the Example and Blank .xlsx files, and the tabs Start Here, Setup, Guests, Counts, Seating and No Reply.
  • A text panel on how the file was tested, with test data run through LibreOffice and compared with a Python calculation.

Wedding Guest List Spreadsheet

Keep every invitee in one sheet and let the totals work themselves out. The Guests tab has a row per person with household, side, adult or child, address, RSVP and meal, then dietary needs, seating, gift received and thank-you sent. People sharing an invitation get the same Household name, so they count once. On Counts you see who is invited, coming, declined and silent, with meal totals for the yes replies, the figures a caterer wants. Seating names who sits where, and No Reply lists who still owes an answer, with days since the invitation went out. A Check column points to gaps such as a missing meal or a table that is over its seats. Capacity is 400 guests, and the Example file has 92 made-up ones.

$6.49 on Etsy

From our listing records. Etsy shows the current price and your local currency at checkout.

Buy on Etsy

Excel for Mac recalculated every cell with no errors, and LibreOffice matched a Python check. No new data was typed. Excel for Windows and Google Sheets not tried.

Instant download from Etsy · nothing shipped

What's included

  • Wedding-Guest-List-Example.xlsx, filled in with made-up guests
  • Wedding-Guest-List-Blank.xlsx, for your own guests
Two panels: the Example and Blank .xlsx files, and the tabs Start Here, Setup, Guests, Counts, Seating and No Reply.

How it works

  1. The Guests tab, a wide table of made-up guests with household, side, RSVP, meal, table and status columns and yellow input cells.
    One row per guest The Guests tab with household, side, RSVP, meal and table columns, and a Check column for what is missing.
  2. The Counts tab with cards for invited, coming, not coming, no reply, invitations and reply rate, then tables by side and by meal.
    Counts for the caterer The Counts tab with invited, coming, not coming and no reply, then a table by side and meals for guests coming.
  3. The Seating tab, one row per table with seats, seated, free and up to twelve guest name columns, filled with made-up names.
    Names by table The Seating tab with seats, seated and free for each table, and the first names at each.
  4. The No Reply tab with a reply deadline, counts of no reply and not sent yet, and a list of guests with days since invitation.
    Who has not answered The No Reply tab listing guests yet to answer, with days since their invitation and address.
  5. The Setup tab with yellow cells for wedding name, reply deadline, side names, meal choices and a list of tables with seats.
    Your own names The Setup tab where you enter side names, meal choices, tables with seats and a reply deadline.

Compatibility and file formats

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.

Instant download from Etsy · nothing shipped.

Video

Questions

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.

This file counts what you type. It sends nothing to anyone. License: for your personal use only. No resale or sharing of this file. 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.