Loading Forever Farrah…
By Forever Farrah Published 2026-09-12, last updated 2026-09-24.
A spreadsheet layout that works for a wedding seating chart, the formulas that catch overfull tables and unseated guests, and when a spreadsheet stops being enough.
Lee esta guía en español · اقرأ هذا الدليل بالعربية
Use one row per guest, not one tab per table. Give each row the guest's name, their party or household, their meal choice and a Table column. Then add a small summary that counts guests per table and flags any table that is over capacity or any guest without a table. Sort by Table when you're done to get a list for the caterer, and sort by surname to get the chart for guests.
| Column | Example | Why it's there |
|---|---|---|
| Last name | Garcia | Sorting the guest-facing chart |
| First name | Maria | Telling guests with the same surname apart |
| Party | Garcia family | Keeping households and couples together |
| Side or group | Bride, college | Seating friend groups together |
| RSVP | Yes | Only seat the confirmed yes answers |
| Meal | Chicken | The caterer's count by table |
| Dietary needs | Nut allergy | Flagging the table for the caterer |
| Table | 6 | The one column you edit while planning |
| Notes | Keep away from table 9 | Anything you need to remember |
One guest per row is the important choice. If you make one column or tab per table, moving a guest means cutting and pasting, counts are done by hand, and it is easy to seat someone twice or not at all.
If you would rather start from a layout than a blank page, our wedding seating chart templates are ready to edit.
Put a small summary on a second sheet with one row per table number (1, 2, 3...) in column A and the table's capacity in column C. These work the same way in Excel and Google Sheets; replace Guests with your first sheet's name.
=COUNTIF(Guests!H:H, A2)=IF(B2>C2, "Over by "&(B2-C2), "")=COUNTIFS(Guests!E:E, "Yes", Guests!H:H, "")=COUNTIFS(Guests!H:H, A2, Guests!F:F, "Chicken")In these formulas, column E is RSVP, F is Meal and H is Table, following the layout above. Adjust the letters if your columns differ.
COUNTIF and COUNTIFS behave the same in both programs. Microsoft documents COUNTIFS for Excel and Google documents COUNTIFS for Sheets, if you want to extend them, for example to count vegetarian meals per table.
1. A dropdown on the Table column. Typing table numbers by hand is how "6", "Table 6" and "6 " end up as three different tables that your counts treat separately. Restrict the column to your list of table numbers instead. In Google Sheets it's Data, then Data validation, then Add rule, then "Dropdown from a range" (Google's instructions). In Excel it's Data Validation with Allow set to List (Microsoft's instructions).
2. Highlight duplicate names. The same guest entered twice, once from each side of the family, is the most common spreadsheet error. In Excel, use Conditional Formatting, then Highlight Cells Rules, then Duplicate Values (Microsoft's guide to conditional formatting). In Google Sheets, add a conditional formatting rule with a custom formula such as =COUNTIF($A$2:$A$300,A2)>1 on the name column (Google's guide).
3. Colour the overfull tables. On the summary sheet, add a conditional formatting rule to the count column with the custom formula =$B2>$C2, so any table over its capacity turns red as soon as you seat one guest too many.
For a typical wedding, expect one evening to set the sheet up and a few sessions to seat everyone. The average 2025 wedding had 117 guests, according to The Knot's 2026 Real Weddings Study. That's 117 rows and 12 to 15 tables. The first pass is quick. The time goes into the changes: every late RSVP means editing the row, rechecking the counts and reprinting anything you've already printed.
A spreadsheet is fine for the list. It is weak at the part of seating that is really about the room:
If you have already built your guest list in Excel or exported one from Google Sheets as an .xlsx file, you can import it into Forever Farrah's guest list and seat those guests on a floor plan instead. Guests then find their table with a QR code, and a change you make shows up for them straight away.
If the spreadsheet is getting unwieldy, paste its names column into an editable seating chart template and see the room instead of a grid.
You can build one in a few minutes with the columns above: one row per guest with a Table column, plus a summary sheet that counts guests per table.
List the table numbers in a column, then use COUNTIF on the Table column of your guest sheet for each number, for example =COUNTIF(Guests!H:H, A2).
No. Keep one row per guest with a Table column. Moving someone is then a single edit, and the counts update themselves.
Highlight duplicates on the name column: in Excel with Conditional Formatting's Duplicate Values rule, and in Google Sheets with a custom-formula rule such as =COUNTIF($A$2:$A$300,A2)>1.
Yes, most seating chart apps import a spreadsheet. Forever Farrah imports an Excel .xlsx file into its guest list, and you can also paste names straight in, then seat those guests on a floor plan.
Loading Forever Farrah…