Seating plan spreadsheet UK: Excel and Google Sheets table planner with drop-downs and capacity warnings
A seating plan spreadsheet (or wedding seating plan Excel / Google Sheets table planner) is the working file where you assign every guest a table, watch seat counts and over-capacity, then print table cards for the room. This UK guide compares a spreadsheet to a printable visual chart and to table numbers, shows the columns that match a ready Tables / Guests / Table Plan layout, covers Excel vs Sheets, an over-capacity workflow, and the sync from guest list to chart to caterer. Sample rows below are made-up. There is a free DIY method, so you do not need to buy anything. Still deciding who sits where? Start with how to write a wedding seating plan. Need the big entrance board? See the wedding seating chart template UK. Counting tables first? Use the free table seating calculator.
Spreadsheet vs printable visual chart vs table numbers
UK searches mix three different things. Use the right tool for each job:
| What | Job | Typical format |
|---|---|---|
| Seating plan spreadsheet | Assign guests to tables, track free seats, flag over-capacity, feed the caterer | Excel or Google Sheets (working file) |
| Printable visual seating chart | Big board guests read at the entrance (alphabetical or by table) | A3 / A2 / A1 print or PDF |
| Table numbers / table plan cards | Sign on each table; optional cards listing who sits there | A5 / A6 card |
The spreadsheet is the source of truth. The chart and table numbers are what guests see. For the chart walk-through (columns, alphabetical vs by-table, print sizes), use wedding seating chart template UK and the Editable Wedding Seating Chart (£5.95). For numbering the room and place-card meal codes, see wedding table numbers and place cards UK and the Table Numbers & Table Plan Cards (£4.50). Want chart + numbers + gala plan in one download? The Seating Chart Bundle (£9.95).
Template: the Place Cards & Escort Cards (Editable + Printable) (£3.49) has editable tent place cards and escort cards in four designs (including a Christmas dinner design), optional discreet meal codes with a caterer key sheet, and A4 print sheets with cut lines.
What columns a seating plan spreadsheet needs
A practical layout matches three linked sheets (the same shape as the Seating Plan & Table Planner (£4.95)):
- Tables: table name or number, shape (round / long), seat count (capacity), seated count, free seats, and a clear over-capacity warning when seated > capacity.
- Guests: guest name, household or plus-one link, meal choice, diet / allergen note, table assigned via a drop-down of table names, with unseated guests highlighted so nobody is left off.
- Table Plan: auto-filled cards or rows per table listing who sits there, ready to print on A4 for the venue or for table-plan cards.
Keep RSVPs, day vs evening and the 14 UK allergens in the guest list first, then copy only confirmed day guests into the seating file. The Guest List, RSVP & Allergen Tracker (£4.50) is built for that hand-off.
Excel vs Google Sheets for a seating plan
| Need | Excel (.xlsx) | Google Sheets |
|---|---|---|
| Working offline / venue Wi-Fi is weak | Strong | Needs a connection (or offline mode set up first) |
| Sharing with a partner or planner | OneDrive / email copies | Share a link; both edit live |
| Drop-down of table names | Data Validation → List | Data → Data validation → Dropdown |
| Highlight unseated guests | Conditional formatting | Conditional formatting |
| Print A4 table cards | Print → Fit to page / 100% | File → Print → fit to width |
A common UK workflow is to build in Excel, then upload the .xlsx to Google Drive so both of you can edit on phones. The Seating Plan & Table Planner (£4.95) ships as .xlsx for that reason.
Over-capacity workflow
- Lock capacities first. Enter every table with its real seat count from the venue (not the hopeful squeeze figure).
- Assign guests only from confirmed day RSVPs. Evening-only guests stay off the seating sheet until the venue confirms evening tables.
- Watch free seats and warnings. If seated > capacity, either move guests, add a table, or switch that table to a larger size — do not print the chart until every warning is clear.
- Recheck after late RSVPs. One couple accepting late can tip a table over; re-run the free-seat column before you freeze numbers for the caterer.
Use the free table seating calculator (and how many tables for 100 guests UK) to decide how many tables you need before you fill the spreadsheet. The Seating Plan & Table Planner (£4.95) then flags any table that goes over its seat count while you assign names.
Sync: guest list → spreadsheet → chart → caterer
- Guest list: names, day/evening, RSVP, meal, allergens (see wedding guest list template UK and the Guest List, RSVP & Allergen Tracker (£4.50)).
- Seating spreadsheet: only confirmed day guests; table drop-downs; clear over-capacity.
- Entrance chart: export or copy names into the alphabetical or by-table chart (wedding seating chart template UK / Editable Wedding Seating Chart (£5.95)).
- Table numbers: print one number (or name) per table (table numbers and place cards / Table Numbers & Table Plan Cards (£4.50)).
- Caterer sheet: meal and diet counts per table from the same guest rows — do not retype from memory.
Freeze the file when the venue wants final numbers (often 7–14 days before). After that, only move people with the caterer's agreement.
Example tables and guests (made-up)
The rows below are a made-up example for an imaginary 40-guest wedding breakfast. They are illustrative only — not a recommendation for who should sit with whom.
| Table (example) | Shape (example) | Seats (example) | Seated (example) | Free / warning (example) |
|---|---|---|---|---|
| Top Table | Long | 8 | 8 | 0 free |
| Table 1 | 5ft round | 8 | 8 | 0 free |
| Table 2 | 5ft round | 8 | 7 | 1 free |
| Table 3 | 5ft round | 8 | 9 | Over capacity — move 1 guest |
| Table 4 | 5ft round | 8 | 8 | 0 free |
| Guest (example) | Meal (example) | Diet note (example) | Table (example) |
|---|---|---|---|
| Alex Reed | Chicken | — | Top Table |
| Sam Reed | Vegetarian | — | Top Table |
| Jordan Lee | Fish | Nut allergy | Table 1 |
| Casey Morgan | Chicken | — | (unseated — highlighted) |
In a real file, Casey would stay highlighted until assigned, and Table 3's over-capacity warning would block printing until someone moves.
How to make a seating plan spreadsheet yourself (free DIY)
- Sheet 1 — Tables: columns Table name, Shape, Capacity, Seated (COUNTIF from Guests), Free (=Capacity−Seated), Warning (IF Seated>Capacity, "Over capacity", "").
- Sheet 2 — Guests: columns Name, Meal, Diet, Table. Data-validate the Table column against the Tables name list. Conditional-format blank Table cells.
- Sheet 3 — Table Plan: for each table, FILTER or a pivot of guests where Table = that name; print each block on A4.
- Start from confirmed day guests only copied from your guest list.
- Print a test page before the final freeze, and keep one offline copy.
Prefer not to build the formulas and drop-downs yourself? The Seating Plan & Table Planner (£4.95) already includes Tables with over-capacity warnings, Guests with a table drop-down and unseated highlighting, and an auto-fill Table Plan for up to 20 tables / 300 guests.
DIY vs ready template vs seating bundle
- DIY (free): the steps above in a blank Excel workbook or Google Sheet. Best if you enjoy formulas and have time before RSVP deadline.
- Ready seating spreadsheet: the Seating Plan & Table Planner (£4.95) (£4.95) when you want Tables / Guests / Table Plan, drop-downs, capacity warnings and A4 prints already set up.
- Visual chart + numbers: the Editable Wedding Seating Chart (£5.95) and Table Numbers & Table Plan Cards (£4.50), or the Seating Chart Bundle (£9.95) if you want chart, table numbers/plan cards and a gala plan together.
- Gala / corporate dinner: longer lists and diet codes per table — see gala and corporate seating plan UK (product 23), not this wedding-style planner.
What is (and is not) in the Seating Plan & Table Planner
- Included in the Seating Plan & Table Planner (£4.95): Tables sheet (name, shape, seat count, seated/free, over-capacity warnings); Guests sheet (table drop-down, unseated highlighted); Table Plan (auto-fill table cards, up to 20 tables of 12 seats / 300 guests); prints A4; Start Here guide. Excel .xlsx / Google Sheets upload. UK edition (£ GBP, DD/MM/YYYY). Digital download for personal use or use within your own organisation. AI-assisted with an original brief.
- Not included: it is not legal advice. Nothing physical is posted. Please do not resell or share the file. It does not replace a printable entrance chart or table-number cards (use the Editable Wedding Seating Chart (£5.95) / Table Numbers & Table Plan Cards (£4.50) or the Seating Chart Bundle (£9.95) for those), and it is not the gala/corporate planner (see the gala guide).
More: how to write a wedding seating plan · wedding seating chart template UK · table numbers and place cards · how many tables for 100 guests · wedding guest list template UK · gala and corporate seating plan UK · table seating calculator
Free tools for this
Frequently asked questions
What is a seating plan spreadsheet?
A working Excel or Google Sheets file where you list tables with seat counts, assign each guest a table (often with a drop-down), watch free seats and over-capacity warnings, and print table cards. It is different from the big printable entrance chart guests read at the door.
Is a seating plan spreadsheet the same as a seating chart?
No. The spreadsheet is the editable source of truth. A seating chart is the large printed board (usually A2 or A1) guests use to find their table. Table numbers are the small signs on each table. Build the spreadsheet first, then print the chart and numbers from it.
Can I make a wedding seating plan in Excel or Google Sheets?
Yes. Use a Tables sheet (name, capacity, seated, free, warning), a Guests sheet with a data-validated table drop-down and highlighted blanks, and a Table Plan sheet that lists who sits at each table for A4 printing. Or start from a ready UK template such as our Seating Plan & Table Planner.
How do table drop-downs and over-capacity warnings work?
Point the Guests "Table" column at the list of table names (Excel Data Validation or Sheets dropdown). Count seated guests per table with COUNTIF, set Free = Capacity − Seated, and show a warning when Seated is greater than Capacity. Clear every warning before you freeze numbers for the caterer.
How do I sync the guest list with the seating plan and the caterer?
Keep RSVPs, meals and allergens on the guest list, copy only confirmed day guests into the seating spreadsheet, then generate the entrance chart and per-table meal counts from the same rows. Freeze when the venue wants final numbers, often 7–14 days before.
What size should I print table plan cards from a spreadsheet?
A4 is fine for a planner or venue copy of who sits at each table. The entrance chart is larger (A3, A2 or A1). Table number signs on the tables themselves are usually A5 or A6 on card — see our wedding table numbers and place cards UK guide.
DIY seating spreadsheet or a ready template?
DIY suits you if you are happy building COUNTIF, drop-downs and conditional formatting. A ready template such as our Seating Plan & Table Planner (£4.95) suits you if you want Tables, Guests and auto-fill Table Plan already set up for up to 20 tables and 300 guests. Add a visual chart template when you need the entrance board.
What is included in the Seating Plan & Table Planner?
Tables sheet (name, shape, seat count, seated/free, over-capacity warnings); Guests sheet (table drop-down, unseated highlighted); Table Plan auto-fill cards for up to 20 tables of 12 seats / 300 guests; A4 prints; Start Here guide. Excel .xlsx for Google Sheets upload. UK edition in £ with DD/MM/YYYY dates. Digital download; not legal advice; nothing is posted.
Written with AI assistance and checked against GOV.UK guidance. General information, not financial, tax or legal advice.