Weddings

Wedding Guest List & Seating Chart

One row per household or guest with invite sent, RSVP, meal choice, dietary needs and table number. The Tables sheet counts who sits where, how many seats are left and who still has no table.

File in EnglishNo macrosExcel · Google Sheets4 linked sheets

Buy on Etsy See the screenshots

Price, checkout and download happen on Etsy.

Guests: group, adults and children, invite sent, RSVP, table, meal choice and dietary needs (Example data) — Guests: group, adults and children, invite sent, RSVP, table, meal choice and dietary needs · Example data · Enlarge image

Real screenshots of the file

Images of the file with example data. Tap an image to enlarge it.

Tables: seats, assigned, free and a status for each table (Example data) — Tables: seats, assigned, free and a status for each table

What's inside

Linked sheets, with instructions on the first sheet.

InstructionsHow to fill in the file, step by step.

SettingsYour names, wedding date, expected guests and the guest groups.

GuestsUp to 300 rows with people per row counted from adults and children.

Tables30 tables with seats, assigned, free, status, totals and guests without a table.

Demo data

A worked example

In the example three households are listed and two tables have guests assigned.

Example data in the file, there to overwrite. Guests who replied No take no seat.

Wedding Guest List & Seating Chart
Seats, 30 tables	300
Guests assigned to a table	4
Confirmed or pending guests without a table	2
Anna Smith's household (2 adults, 1 child)	3 people

Getting started

Settings: your names, wedding date, expected guests and the guest groups.
Guests: one row per household, then update RSVPs and meal choices as replies come in.
Type the table number next to each guest: the Tables sheet updates.

Compatibility and limits

Compatibility

Plain .xlsx file, no macros, standard functions only.
Tested by full recalculation in Excel for Microsoft 365.
Calculations also checked in Google Sheets (upload the file to Google Drive).
Not tested in Apple Numbers or Excel for Mac.

Good to know

The file does not send invitations or reminders.
Entries are typed in; nothing is connected or sent.

Questions

Does it count adults and children?

Yes: people per row = adults + children; a row with no numbers counts as 1.

What happens when a table is full?

The status shows Full, and Over capacity! when more people are assigned than seats.

Will anything be posted to me?

No. It's a digital file you download from Etsy straight after purchase.