Classic Rounds
80–110 guestsBest for: a banquet-hall reception with a head table and a dance floor.
Head Table + 10 round tables · 98 seats
NewSeatPlan.io for non-profits: charities get a free, co-branded Event & Venue Manager workspace for a year. Apply now →
Seven reception layouts, each a workbook with Guests, Tables, Menu and Kitchen sheets that count seats and meals for you. Every file opens in Excel and in Google Sheets, and imports into SeatPlan.io so every guest sits down at their table. Prefer to edit online? Pick a wedding seating chart template by guest count and open it in the designer.
or start in the seating chart designerFree, no signup · Classic Rounds, 80–110 guests · 7 layouts for 30 to 160 guests
Each spreadsheet is one of our seating chart layouts. Its Tables sheet has the same tables and seats as the floor plan, so the two always line up.
Best for: a banquet-hall reception with a head table and a dance floor.
Head Table + 10 round tables · 98 seats
Best for: small weddings with a sweetheart table and a few rounds.
Sweetheart Table + 6 round tables · 50 seats
Best for: rustic or family-style dinners at long tables.
Top Table + 4 rectangle tables · 82 seats
Best for: large ballroom receptions with a stage or a band.
Head Table + 14 round tables · 150 seats
Best for: a sweetheart table with every round facing the dance floor.
Sweetheart Table + 8 round tables · 74 seats
Best for: big families at long tables, with friends at rounds.
Head Table + 2 rectangle tables + 8 round tables · 120 seats
Best for: small dinners where everyone faces in, such as a rehearsal dinner.
Top Table + 2 rectangle tables · 50 seats
Every layout has its own Google Sheet. One click gives you your own copy, already converted, in your Google Drive.
Everything carries over. We converted all seven templates in Google Sheets and checked them against the Excel files. Every formula gives the same result, the RSVP, Dietary, Meal, Table and Seat dropdowns come across, and over-full tables and double-booked seats still turn red.
Download the .xlsx, then in Google Drive choose New, then File upload. Double-click the file, choose File, then Save as Google Sheets, and work in the copy that opens. Share it and use filter views as above.
Every number is a formula, so it updates as you fill in the guest list. Sample guests show how it works until you replace them.
One row per guest in SeatPlan.io's guest list format. RSVP, Meal, Dietary and Table are dropdowns, and a seat used twice at one table turns red.
The tables of your SeatPlan.io layout with their shape and seats. It counts the guests at each one, leaves out anyone who RSVP'd no, and turns a table red when it is over capacity.
Your menu as SeatPlan.io keeps it: the dish, the short alias guests choose, and the course, with a running count for each dish.
Meals and dietary needs per table, laid out like the Kitchen sheet SeatPlan.io exports, so the caterer gets the numbers before the chart is final.
These are the formulas as they sit in row 2 of each sheet. On the Guests sheet, column B is RSVP, F is Meal and G is Table, and rows 2 to 501 leave room for 500 guests.
| Where | Formula | What it tells you |
|---|---|---|
| Tables D2 | =IF(A2="","",COUNTIFS(Guests!$G$2:$G$501,A2,Guests!$B$2:$B$501,"<>No")) | Guests at the table in A2. Guests who RSVP'd No are left out. |
| Tables E2 | =IF(A2="","",C2-D2) | Seats left at that table: its seats minus the guests counted. |
| Tables F2 | =IF(A2="","",IF(D2>C2,"Over capacity",IF(D2=C2,"Full",""))) | Says Full or Over capacity, so you can spot problem tables at a glance. |
| Tables A2:F61 (highlight) | =AND($A2<>"",$D2>$C2) | Conditional formatting that turns a table's row red when it has more guests than seats. |
| Tables I8 | =COUNTIFS(Guests!$A$2:$A$501,"<>",Guests!$G$2:$G$501,"",Guests!$B$2:$B$501,"<>No") | Guests still to seat: on the list, not declined, and no table yet. |
| Guests G2:H501 (highlight) | =AND($H2<>"",COUNTIFS($G$2:$G$501,$G2,$H$2:$H$501,$H2)>1) | Conditional formatting that turns a seat red when two guests share it at one table. |
| Menu D2 | =IF(B2="","",COUNTIFS(Guests!$F$2:$F$501,B2,Guests!$B$2:$B$501,"<>No")) | How many attending guests chose the dish in B2. |
| Kitchen B2 | =IF(OR($A2="",B$1=""),"",COUNTIFS(Guests!$G$2:$G$501,$A2,Guests!$F$2:$F$501,B$1,Guests!$B$2:$B$501,"<>No")) | How many guests at one table chose one dish, for the caterer. |
Rather build your own? These six steps give you the same counts as the template, and they work the same way in Google Sheets.
=COUNTIFS(Guests!G:G, A2, Guests!B:B, "<>No") in D2 to count the guests at that table, and =C2-D2 in E2 for the seats still free. Fill both down.=$D2>$C2 and choose a red fill. In Google Sheets the same rule lives under Format, then Conditional formatting, as a custom formula.Or skip steps 1 to 4 and download the template above, where they are already done for you.
The Guests sheet uses SeatPlan.io's own column names, and the guest import puts every one where it belongs.
| Column | In SeatPlan.io |
|---|---|
| Guest Name | The guest's name on the chart, place cards and seat finder. |
| RSVP | Guests marked No start unticked, so they stay off the chart. |
| Group | A guest group with its own colour, so the whole party moves in one drag. |
| Where seat emails and Wallet passes go. | |
| Dietary | Dietary icons in your guest list and counts on the Kitchen sheet. |
| Meal | The guest's menu choice. The import can build your menu from these. |
| Table | Apply seating seats the guest at the table with this name. |
| Seat | The seat number at that table. |
| Tags | Tags on the guest, such as Kids or Wheelchair. |
| Notes | A note on the guest. |
A spreadsheet is the right place for a guest list. It's the wrong place to decide who sits where.
Swap two couples and you retype four table numbers, recount two tables and hope you didn't skip a row. One late RSVP can undo an evening of work.
Row 48 and row 112 look harmless on their own. Put them at the same table and you may have seated the exes together, or one parent much closer to the front than the other.
Your venue wants a floor plan and your welcome sign wants a readable layout. A 150-row spreadsheet gives you neither without an afternoon of copying and pasting.
Merging a couple's row or a table heading looks tidy, but a merged cell keeps its value in the first cell only, so COUNTIF misses the rest, and Excel won't sort a range whose merged cells differ in size. Keep merged cells out of any range a formula or sort reads.
Keep planning the list in your spreadsheet. Do the seating on a wedding seating chart, a floor plan where every table shows who is sitting at it.
Click Use this template on the layout you downloaded. It opens in the free designer with the same table names as your Tables sheet.
Click Import in the guest list and choose your file. Every column lands where it belongs, guests who RSVP'd no start unticked, and your meal choices can become your SeatPlan.io menu.
On a computer, click Apply seating. Each guest sits down at their table and seat, and from then on moving someone is one drag.
Guest list on a wedding website instead? Here's how to import a guest list from The Knot, Zola or Joy.
Spreadsheets are great for the guest list. Here is where each one fits once you start seating people.
| Need | Excel | Google Sheets | SeatPlan.io designer |
|---|---|---|---|
| Works offline | Yes, in the desktop app. | Only once you turn on offline access in Google Drive. | No. It needs a connection to open and save. |
| Real-time sharing | Yes, when the file is saved to OneDrive or SharePoint. | Yes, built in. Share the sheet with your partner as Editor. | Yes, with live collaboration for a partner or planner. |
| Visual floor plan | No. The chart is a list unless you draw shapes by hand. | No. The chart is a list unless you draw shapes by hand. | Yes. Every table, seat and guest sits on a plan of the room. |
| Alphabetical sign | Sort by last name, then format and print. | Sort by last name, then format and print. | Export the guest list sorted by last name as a PDF or Excel file. |
| Last-minute changes | Retype the guest's table. The counts update. | Retype the guest's table. Everyone you share with sees it. | Drag the guest to a new seat. The chart and exports follow. |
Designing in SeatPlan.io needs no signup. Saving, exports and live collaboration need an account and are part of the paid plans.
Put every guest on their own row with columns for name, RSVP, meal and table. On a second sheet, list each table with its seats and use COUNTIFS to count the guests assigned to it, leaving out anyone who declined, then flag any table where guests outnumber seats. These templates already do that, with a Menu sheet and a Kitchen sheet for the caterer on top.
Click Open in Google Sheets on one of the templates above and choose Make a copy, or upload the Excel template to Google Drive and choose File, then Save as Google Sheets. To build your own, give each guest a row with a Table column, list each table's seats on a second tab, and use COUNTIF to count guests per table.
Excel's template gallery, under File, then New, changes over time, so search it for "seating chart" to see what it offers today. A wedding-specific template adds a guest list, a tables sheet with capacities, meal counts for the caterer, and formulas that update as RSVPs come in. You can also start from a blank workbook.
Use COUNTIF or COUNTIFS. For example, =COUNTIFS(Guests!G:G, A2, Guests!B:B, "<>No") counts guests assigned to the table named in A2 and leaves out anyone who declined, where column G holds each guest's table and column B their RSVP. Subtract the result from the table's seat count to see empty seats, and use conditional formatting to highlight tables over capacity.
A spreadsheet is ideal for the guest list, RSVPs and meal counts. A seating chart app is better for deciding who sits where, because you can see each table on a floor plan, move guests by dragging, and export a printable chart. Many couples keep the list in a spreadsheet and import it into an app.
A 60-inch round seats 8 comfortably and a 72-inch round seats 10 for a plated dinner. An 8-foot rectangular table seats 8, or 10 with one guest at each end. Ask your venue which sizes they stock, then set the Seats column on the Tables sheet to match.
Give every plus-one their own row, named if you know it or as "Guest of" the person they're coming with, and the same Group so they stay together. For divorced parents, give each their own table about the same distance from the head or sweetheart table, with the relatives and partners they're closest to. Use the Notes column for anyone who should sit apart and check those notes before you print.
Most couples print the welcome sign at 18 x 24 or 24 x 36 inches in the US, or A2 or A1 in Australia. List guests alphabetically with their table number so people find themselves fast. Give the venue a letter or A4 page of the floor plan with table numbers so the staff set up the room the same way.
Yes. Click Open in Google Sheets on any layout and choose Make a copy, and the template opens in your own Google Drive. We checked all seven: every formula gives the same result as in Excel, the dropdowns come across, and over-full tables still turn red.
Download the closest one and change the Tables sheet to your room: rename tables, change seat counts, add or delete rows. In the designer, add or remove tables to match and give them the same names, and Apply seating still finds every guest's table.
Yes, as it is. The guest import reads the Guests sheet, puts each column where it belongs, keeps each guest's table and seat, and leaves guests who RSVP'd no unticked. Open the same layout first and Apply seating seats everyone at the matching table.
More help: how many guests fit at a round table, seating divorced parents and wedding seating etiquette.
Start from a blank room, browse our printable PDF seating chart templates, or see how the wedding seating chart maker works.
Open the free designer