A spreadsheet is where most guest lists already live. Here is how to turn it into a seating plan, and where it starts to fight you.
Columns to set up
One row per guest with: Name, Party/household, Group (bride's family, college…), RSVP, Meal, Table, and Notes (high chair, wheelchair, keep away from…).
Useful formulas
Guests per table: =COUNTIF(F:F, 1) for table 1, then fill down.
Meals per table: =COUNTIFS(F:F, 1, E:E, "Veg").
Unseated guests: filter the Table column for blanks.
Tables needed: =ROUNDUP(COUNTIF(D:D,"Yes")/8, 0) for tables of 8.
Where spreadsheets break down
You can't see the room: who is near the speakers, the dance floor, the exit.
Moving one family means re-checking several table counts by hand.
Printing a nice chart, escort cards and table numbers is a separate project.
Keep the spreadsheet, skip the busywork
Copy the Name and Group columns and paste them straight into SeatSorted. It keeps households together, seats each group at shared tables and shows the real floor plan. You can export back to CSV for your caterer.
Example: 60 guests, seated automatically by SeatSorted on 8-seat round tables.
Is there a free wedding seating chart template for Google Sheets?
You can build one with the columns above in a few minutes. If you want a visual floor plan and printable chart instead, SeatSorted is free for up to 50 guests and imports CSV.