What each column is for
Most guest list templates fail the same way: they are an address book with a headcount bolted on, so by the time you need to seat anyone the file cannot answer the only question that matters — who sits together. These seven columns are ordered by when you actually use them.
- Name. One row per person, not per invitation. Two seats means two rows.
- Party. The household or invitation they belong to — keeps couples and families together.
- Side. Whose guest it is. Useful for balancing the room, ignorable after that.
- Group. College, work, cousins. This column is what actually builds your tables.
- RSVP. Yes / No / Pending. Only Yes rows get a chair.
- Meal. What the caterer needs, counted per table on the night.
- Table. Leave blank until RSVPs are in. This is the column the seating chart fills.
How big is a normal guest list?
The average US wedding is 117 guests, per The Knot 2026 Real Weddings Study, which surveyed 10,474 US couples married in 2025. That number hides an enormous regional spread — the Midwest averages 140 and the South and Southeast 102 — and it moves with the venue: hometown weddings average 123 guests, domestic destination weddings 92. The same study found 40% of couples cut their guest count in response to rising costs, which is the real reason this spreadsheet needs an RSVP column and a Party column rather than a single number at the bottom.
Practically: at 117 guests you are looking at fifteen rounds of eight, or twelve rounds of ten. The layouts in this library run from 22 to 76 seats across 10 rooms, so there is a starting floor plan at either end of that range on the template page.
Build the list in the order you will actually use it
- Dump every name first, judge later. Three passes — yours, your partner's, both sets of parents — into the same file, duplicates and all. Arguing about a name before it is written down costs twice as much time.
- Fill the Party column immediately. It is the column that stops a couple being split across two tables when the list gets sorted later.
- Cut against a number, not a feeling. Set the headcount your venue and budget allow, sort by Group, and cut whole groups rather than individuals. Cutting a person from a group you invited is the version that gets noticed.
- Freeze it, then let RSVP do the work. Once invitations go out the Name column stops changing and only RSVP moves. Filter to Yes and you have your chair count, live, without rebuilding anything.
- Sort by Group and seat it. Copy the Name column, paste it into the seating chart maker, drag the names onto tables, then write the table numbers back into the Table column.
From spreadsheet to seating chart
A guest list and a seating chart are the same data at two stages: the list knows who is coming, the chart knows where they sit. The handoff is the Name column — the tool takes one name per line, which is exactly what the Copy the names column button above puts on your clipboard.
After that it is a question of arrangement rather than data entry, and the order to work in — couple first, parents next, then groups outward — is laid out step by step in the how-to guide. When it comes to displaying the finished thing, the choice between one alphabetical list and a panel per table is covered on alphabetical vs. by-table, and if you would rather hand every guest their own card, start with escort cards.
Why CSV and not a fancier file
A .csv is plain text: seven columns, one row per guest, no formulas that break, no macros your work laptop blocks, no version that stops opening in three years. Google Sheets imports it in two clicks and Excel and Numbers open it on a double-click. If you want conditional formatting or a pivot of meal counts by table, add it in your own copy — the template's job is to get the structure right, and the structure is the part that is hard to fix later.