NewSeatPlan.io for non-profits: charities get a free, co-branded Event & Venue Manager workspace for a year. Apply now →

Wedding seating chart template for Excel and Google Sheets

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 designer

Free, no signup · Classic Rounds, 80–110 guests · 7 layouts for 30 to 160 guests

Pick the spreadsheet that matches your reception

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.

Dance Floor DJ Bar Head Table 1 2 3 4 5 6 7 8 1 1 2 3 4 5 6 7 8 9 2 1 2 3 4 5 6 7 8 9 3 1 2 3 4 5 6 7 8 9 4 1 2 3 4 5 6 7 8 9 5 1 2 3 4 5 6 7 8 9 6 1 2 3 4 5 6 7 8 9 7 1 2 3 4 5 6 7 8 9 8 1 2 3 4 5 6 7 8 9 9 1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 6 7 8 9

Classic Rounds

80–110 guests

Best for: a banquet-hall reception with a head table and a dance floor.

Head Table + 10 round tables · 98 seats

CT Bar Sweetheart Table 1 2 1 1 2 3 4 5 6 7 8 2 1 2 3 4 5 6 7 8 3 1 2 3 4 5 6 7 8 4 1 2 3 4 5 6 7 8 5 1 2 3 4 5 6 7 8 6 1 2 3 4 5 6 7 8

Intimate Celebration

30–60 guests

Best for: small weddings with a sweetheart table and a few rounds.

Sweetheart Table + 6 round tables · 50 seats

Bar Top Table 1 2 3 4 5 6 7 8 9 10 A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 B 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 C 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 D 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

Long Table Banquet

60–90 guests

Best for: rustic or family-style dinners at long tables.

Top Table + 4 rectangle tables · 82 seats

Stage Dance Floor Head Table 1 2 3 4 5 6 7 8 9 10 1 1 2 3 4 5 6 7 8 9 10 2 1 2 3 4 5 6 7 8 9 10 3 1 2 3 4 5 6 7 8 9 10 4 1 2 3 4 5 6 7 8 9 10 5 1 2 3 4 5 6 7 8 9 10 6 1 2 3 4 5 6 7 8 9 10 7 1 2 3 4 5 6 7 8 9 10 8 1 2 3 4 5 6 7 8 9 10 9 1 2 3 4 5 6 7 8 9 10 10 1 2 3 4 5 6 7 8 9 10 11 1 2 3 4 5 6 7 8 9 10 12 1 2 3 4 5 6 7 8 9 10 13 1 2 3 4 5 6 7 8 9 10 14 1 2 3 4 5 6 7 8 9 10

Grand Ballroom

130–160 guests

Best for: large ballroom receptions with a stage or a band.

Head Table + 14 round tables · 150 seats

Dance Floor Photo Booth Bar Sweetheart Table 1 2 1 1 2 3 4 5 6 7 8 9 2 1 2 3 4 5 6 7 8 9 3 1 2 3 4 5 6 7 8 9 4 1 2 3 4 5 6 7 8 9 5 1 2 3 4 5 6 7 8 9 6 1 2 3 4 5 6 7 8 9 7 1 2 3 4 5 6 7 8 9 8 1 2 3 4 5 6 7 8 9

Modern Sweetheart

60–80 guests

Best for: a sweetheart table with every round facing the dance floor.

Sweetheart Table + 8 round tables · 74 seats

Dance Floor Head Table 1 2 3 4 5 6 7 8 Family A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Family B 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 1 1 2 3 4 5 6 7 8 9 10 2 1 2 3 4 5 6 7 8 9 10 3 1 2 3 4 5 6 7 8 9 10 4 1 2 3 4 5 6 7 8 9 10 5 1 2 3 4 5 6 7 8 9 10 6 1 2 3 4 5 6 7 8 9 10 7 1 2 3 4 5 6 7 8 9 10 8 1 2 3 4 5 6 7 8 9 10

Rounds + Family Tables

100–130 guests

Best for: big families at long tables, with friends at rounds.

Head Table + 2 rectangle tables + 8 round tables · 120 seats

Dance Floor Bar Top Table 1 2 3 4 5 6 7 8 9 10 Left 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Right 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

U-Shape

30–50 guests

Best for: small dinners where everyone faces in, such as a rehearsal dinner.

Top Table + 2 rectangle tables · 50 seats

How to use this template in Google Sheets

Every layout has its own Google Sheet. One click gives you your own copy, already converted, in your Google Drive.

  1. Click Open in Google Sheets on the layout you want. It opens in a new tab.
  2. Sign in to Google if asked, then click Make a copy. Your copy lands in your own Google Drive, ready to edit.
  3. Click Share, add your partner's email and give them Editor access, so you both work on one list.
  4. When you want to sort or filter, choose Data, then Create filter view. A filter view changes only your screen, so your partner's view stays as they left it.

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.

Prefer to upload the Excel file yourself?

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.

Diagram of the steps from Excel to Google Sheets: download the .xlsx template, upload it with New and File upload in Google Drive, choose File then Save as Google Sheets, share it with your partner as Editor, and use Data then Create filter view.

Four sheets that do the counting

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.

Guests

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.

Tables

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.

Menu

Your menu as SeatPlan.io keeps it: the dish, the short alias guests choose, and the course, with a running count for each dish.

Kitchen

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.

The formulas in the template

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.

WhereFormulaWhat 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.

How to make a wedding seating chart in Excel from scratch

Rather build your own? These six steps give you the same counts as the template, and they work the same way in Google Sheets.

  1. One row per guest, never per couple. Give each guest a row with columns for Name, RSVP, Meal and Table. Couples and families share a Group value instead of a row, so a plus-one or a child is never missing from a count.
  2. A Tables sheet with seats per table. On a second sheet, put each table's name in column A and its seats in column C. A 60" round seats 8 and a 72" round seats 10. For other sizes, see how many guests fit at a round table.
  3. COUNTIF for seats used, and seats minus used for seats free. With Table in column G and RSVP in column B of the Guests sheet, enter =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.
  4. Conditional formatting to turn over-full tables red. Select A2:E60, choose Home, then Conditional Formatting, then New Rule, and pick “Use a formula to determine which cells to format”. Enter =$D2>$C2 and choose a red fill. In Google Sheets the same rule lives under Format, then Conditional formatting, as a custom formula.
  5. Sort by last name for the alphabetical sign. Add a Last Name column, sort the guest list by it with Data, then Sort, and print the name and table side by side. Guests find themselves fastest on an A to Z list. For ways to display it, see these wedding seating chart ideas.
  6. Sketch the room or import into a floor plan. A list can't show who faces whom or where the dance floor goes. Draw the room on paper, or import the sheet into SeatPlan.io and drag tables to match your venue.

Or skip steps 1 to 4 and download the template above, where they are already done for you.

Every column is a SeatPlan.io field

The Guests sheet uses SeatPlan.io's own column names, and the guest import puts every one where it belongs.

ColumnIn SeatPlan.io
Guest NameThe guest's name on the chart, place cards and seat finder.
RSVPGuests marked No start unticked, so they stay off the chart.
GroupA guest group with its own colour, so the whole party moves in one drag.
EmailWhere seat emails and Wallet passes go.
DietaryDietary icons in your guest list and counts on the Kitchen sheet.
MealThe guest's menu choice. The import can build your menu from these.
TableApply seating seats the guest at the table with this name.
SeatThe seat number at that table.
TagsTags on the guest, such as Kids or Wheelchair.
NotesA note on the guest.

Why seating charts get messy in Excel

A spreadsheet is the right place for a guest list. It's the wrong place to decide who sits where.

Every change is a chain of edits

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.

Rows can't show who sits beside whom

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.

It prints as a list

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.

Merged cells break the counts

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.

From spreadsheet to seated in three steps

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.

1. Open the same layout

Click Use this template on the layout you downloaded. It opens in the free designer with the same table names as your Tables sheet.

2. Import your guest list

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.

3. Apply seating

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.

Excel, Google Sheets or a seating chart tool: which should you use?

Spreadsheets are great for the guest list. Here is where each one fits once you start seating people.

NeedExcelGoogle SheetsSeatPlan.io designer
Works offlineYes, 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 sharingYes, 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 planNo. 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 signSort 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 changesRetype 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.

Excel and Google Sheets seating chart questions

How do I make a wedding seating chart in Excel?

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.

How do I make a wedding seating chart in Google Sheets?

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.

Does Excel have a wedding seating chart template?

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.

What formula counts guests per table in a seating chart spreadsheet?

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.

Is a spreadsheet or a seating chart app better for a wedding?

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.

How many guests should sit at each table?

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.

How do I handle plus-ones and divorced parents?

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.

What size should I print my wedding seating chart?

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.

Does this template work in Google Sheets?

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.

My venue doesn't match any of these layouts. What should I do?

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.

Can I import this spreadsheet into SeatPlan.io?

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.

See your seating chart as a floor plan

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