Free Wedding Seating Chart Template for Excel & Google Sheets (That Actually Works)

Looking for a wedding seating chart template for Excel or Google Sheets? Good instinct — the spreadsheet is where most couples start, and done right it genuinely works. Below you'll find a free template that does it properly (RSVP dropdowns, tables that count themselves, a caterer dashboard, no email gate), the exact steps to build your own from scratch in either app, and — because we'd rather be useful than salesy — an honest map of where the spreadsheet approach breaks.

Download the free template

Grab the free wedding seating chart template (.xlsx). No email gate, no watermark, five sheets: Guest List, Tables, Dashboard, Keep-Apart List, and instructions. For Google Sheets: open sheets.new, then File → Import → Upload and drop the file in — everything converts cleanly, dropdowns and formulas included. And if you already know spreadsheets aren't your thing: tableplanner imports this exact file and adds the parts no spreadsheet can do — conflict warnings and one-click auto-seating, free up to 30 guests.

What's inside (and why each sheet exists)

• Guest List — one row per human: name, party/group, RSVP status and meal choice as dropdowns (so 'Confirmed' never gets typed as 'confimed' and silently breaks every count), dietary notes, accessibility, table number. The Party column is the one DIY sheets always skip — it's how you remember that moving Anna means moving Karlis.
• Tables — each table has a capacity and counts its own confirmed guests; assign one too many and the status cell turns red with OVER CAPACITY. That single formula prevents the classic disaster: eleven names at a ten-chair table, discovered by the venue.
• Dashboard — live totals: confirmed, pending, declined, seated, confirmed-but-not-yet-seated (the number that must hit zero before you print), and meal counts by type. Two weeks out, this sheet is your caterer email, pre-written.
• Keep-Apart List — the pairs who must not share a table, written down where you'll actually re-check them. Honest confession: no spreadsheet can check this for you. More on that below.

Build it yourself: Excel and Google Sheets, step by step

Prefer to roll your own (or adapt ours)? Here's the whole construction — the steps are nearly identical in both apps.

1. Columns A–H on a 'Guest List' sheet: First name, Last name, Party, RSVP, Meal, Dietary notes, Accessibility, Table.
2. Dropdowns for RSVP and Meal. Excel: select the column → Data → Data Validation → List → type Invited,Confirmed,Declined,Pending. Google Sheets: Data → Data validation → add rule → Dropdown, same options.
3. A 'Tables' sheet with Table #, Capacity, and the counting formula — identical in both apps: =COUNTIFS('Guest List'!H:H, A5, 'Guest List'!D:D, "Confirmed"). Seats-left is just =Capacity−Seated.
4. The over-capacity alarm: conditional formatting on the status column — Excel: Home → Conditional Formatting → Highlight Cell Rules; Sheets: Format → Conditional formatting — turn the cell red when Seated > Capacity.
5. Dashboard counts with COUNTIF: =COUNTIF('Guest List'!D:D,"Confirmed") and friends. Five formulas and your caterer email writes itself.

Excel or Sheets? Sheets wins if two of you are editing — real-time collaboration beats emailing wedding-seating-FINAL-v3-ACTUAL.xlsx back and forth, which is exactly how versions diverge during wedding week. Excel wins offline and handles huge lists more smoothly. The template works identically in both.

The workflow that makes it survivable

1. Enter the full invite list first; track RSVPs as they land. Don't assign a single table until your RSVP deadline passes.
2. Fill the Keep-Apart List before seating anyone — it's a constraint list, not an afterthought.
3. Assign tables party-by-party (sort by the Party column), never guest-by-guest — that's how couples get split.
4. After every change: check the Tables sheet for red, then re-read the whole Keep-Apart List. Yes, the whole thing.

Where the spreadsheet breaks (we built it, we'd know)

Three walls, and no formula gets past them. One: no conflict warnings — there is no reasonable formula that watches column H and warns you the exes just landed at the same table, so the keep-apart check is your memory, repeated after every edit, during the exact week you're busiest. Two: no auto-seating — 120 names get placed by hand, and the second draft (there's always a second draft) costs the same evening as the first. Three: a grid isn't a room — cells can't show that table 12 backs onto the speakers or that grandma's seat faces a pillar.

If your wedding is small and your RSVPs are stable, the template may be all you ever need — sincerely. If you've just re-read the Keep-Apart List for the fourth time this week: import this exact file into tableplanner and the warnings become automatic, the auto-seater does the first draft, and the room becomes an actual floor plan. We compared the two approaches honestly here, and the complete seating chart guide covers everything that happens after the spreadsheet.