Seating Chart Template for Excel and Google Sheets

A spreadsheet is a perfectly good place to start a seating chart. You already know how to use one, it is free, and the guest list probably lives in one anyway. The trouble starts later, and it is predictable. This guide shows how to set up an Excel or Google Sheets seating chart so it holds up, where it stops helping, and what to do when you reach that point.

Everything below works in both Excel and Google Sheets unless it says otherwise.

Sheet one: one row per guest#

The rule that saves the most pain is simple: one row per person, never one row per household or one row per table. Rows can be sorted, filtered and counted. A cell that says "Sam, Priya and the kids" cannot.

These are the columns worth having:

First name	Last name	Party	Side	Table	Seat	Meal	Notes
Alex	Morgan	Morgan-Lee	Bride	4	1	Fish
Jamie	Lee	Morgan-Lee	Bride	4	2	Vegetarian	Cousin of Alex
Sam	Patel	Patel	Groom	7		Chicken	Needs step-free access
Riley	Brooks	Brooks	Groom			Chicken	RSVP pending
Jordan	Kim	Kim	Friends	2	5	Vegan	Not next to Sam Patel

What each one is for:

• Party is the household or group that arrives together. Everyone in a party normally sits at the same table, so this is the column you sort by when you start filling tables.
• Side (or any group label: work, school, neighbours) tells you who a table is made of. Mixed tables are fine; accidental ones are not.
• Table stays empty until you decide. A blank here is useful: filter on it and you see exactly who is still unplaced.
• Seat is optional. Many weddings only assign tables. Fill it in if you need place cards, a head table, or named seats.
• Meal and Notes keep dietary needs, accessibility and "keep these two apart" reminders attached to the person they apply to.

Sheet two: the tables#

Add a second sheet called Tables with one row per table:

Table	Capacity	Assigned	Free
1	10
2	10
3	8

The Assigned column is where the spreadsheet starts earning its keep. In cell C2, count how many guests currently have that table number:

=COUNTIF(Guests!E:E, A2)

Guests!E:E is the Table column on the guest sheet (adjust the letter if yours is different) and A2 is the table number on this row. The formula is the same in Excel and Google Sheets (if your regional settings use semicolons as separators, write =COUNTIF(Guests!E:E; A2)). Fill it down, then in D2 add =B2-C2 to see how many seats are free.

Flag over-capacity tables automatically#

You do not want to find out at the venue that table 4 has twelve people. Select the Assigned column and add conditional formatting:

• Excel: Home, Conditional Formatting, New Rule, "Use a formula to determine which cells to format", then enter =C2>B2 and choose a red fill.
• Google Sheets: Format, Conditional formatting, "Custom formula is", then enter =C2>B2 and choose a red fill.

Any table with more guests than seats now turns red the moment you type a table number.

Stop typos with a dropdown#

A table number typed as "4 " or "four" will not be counted. Fix that with data validation on the Table column of the guest sheet:

• Excel: Data, Data Validation, Allow: List, Source: =Tables!$A$2:$A$20.
• Google Sheets: Data, Data validation, "Dropdown (from a range)", then Tables!A2:A20.

Now the only values you can enter are table numbers that exist.

Turn it into an escort list#

Once guests are placed, the same sheet produces the list people actually read at the entrance. Sort by Last name (or First name, whichever your signage uses): in Excel, Data, Sort; in Google Sheets, Data, Sort range. Then copy the name and Table columns onto a clean sheet and print or format it. Sorting by Table instead gives you the reverse view, which is what the caterer and the person writing place cards want.

Sharing the sheet#

If a partner, parent or planner needs to weigh in, Google Sheets is the easier route: Share, add their email, and set them to Editor or Commenter. Commenters can leave notes on a cell ("Aunt Rosa will not sit with Uncle Tom") without being able to move anyone. Version history (File, Version history) shows who changed what, which settles most "I never moved that" arguments. In Excel, the equivalent is saving to OneDrive and sharing from there.

Where a spreadsheet stops helping#

A spreadsheet is a database, not a floor plan. For a small, simple event it is enough. For a wedding of 80 or more, you will run into the same four limits:

1. No picture of the room. A table number does not show you that table 7 is next to the speakers or that the dance floor cuts the room in half.
2. No drag and drop. Moving someone means retyping a number, then checking the count, then checking you did not break a party.
3. Rules live in your head. "Keep these two apart" and "keep these four together" are not things a cell can enforce. They sit in the Notes column, and you re-read them by eye.
4. Every RSVP change means re-checking everything. One guest drops out and one plus-one is added, and now two tables are off by one.

None of this means the spreadsheet was a mistake. The guest data you entered is the valuable part. The limit is in what you can do with it.

Keep the spreadsheet, add a visual tool#

You do not have to choose. Keep your Excel or Google Sheets guest list as the source of names, and use a seating tool for the part a grid is bad at.

1. Add a third sheet called Export with two columns: Name (the full name, for example =A2&" "&B2 from the guest sheet) and Group (the Party). The import reads one name column and one group column, so first and last name must already be joined.
2. Save that sheet as CSV (Excel: File, Save As, CSV; Google Sheets: File, Download, Comma-separated values). Open the seating chart maker and import the CSV, or paste the list with one name per line. SeatSort accepts a CSV upload; it does not read .xlsx files directly, so export to CSV first.
3. Lay out your tables to match the venue, then use keep together for parties and keep apart for the pairs you flagged in Notes.
4. Shuffle to get a first arrangement that respects those rules, and adjust by hand from there.
5. Export a PDF for the printer, the venue or the planner.

If the event is a wedding, the wedding seating chart maker covers the same flow with wedding-specific layouts, and the templates page has ready-made room layouts to start from. For the order to do things in, see how to make a wedding seating chart, and for choosing table shapes, the round vs rectangular tables guide.

FAQ#

Is there a free seating chart template for Excel?#

You can build one in about ten minutes with the two sheets above: a guest sheet with one row per person, and a tables sheet with capacity and a COUNTIF formula. Starting from your own columns is usually better than a downloaded template, because it will match the information you actually have.

How do I make a wedding seating chart in Excel?#

Put every guest on their own row, add a Table column, and fill it in as you decide. Use COUNTIF on a second sheet to count guests per table, and conditional formatting to highlight any table over capacity. Sort by last name when you are done to produce an escort list.

Can I use Google Sheets for a seating chart?#

Yes. The formulas, dropdowns and conditional formatting described here work the same way, and sharing with a partner or planner is easier than emailing an Excel file back and forth.

How do I count how many guests are at each table?#

Use =COUNTIF(Guests!E:E, A2), where column E is the Table column on the guest sheet and A2 holds the table number. Fill it down for every table.

Can I import my spreadsheet into a seating chart tool?#

Export it as CSV and import that file, or paste the names one per line. Give each guest their own row, with the full name in one column and the party in another, since that is the shape the import expects.