Free Seating Chart Spreadsheet for Your Wedding

A free wedding seating chart spreadsheet needs two tabs and one formula: a guest tab with a Table column, and a tables tab that counts how many people you've put at each table. You can build it in Google Sheets or Excel in one sitting, and for a small wedding with the replies already in, it may be all you need.

It starts to cost you time once replies are still arriving, couples have to stay together, or guests want to know their table on the day. Here's how to build the sheet, and how to tell when it's time to move the plan somewhere else.

TL;DR:

• Tab 1 lists every guest, one row each, with Party, RSVP, Meal and Table columns.
• Tab 2 lists every table with its seat count, and COUNTIF tells you how many seats are taken.
• A dropdown on the Table column stops "Table 7" and "table7" from counting as two tables.
• Sort by table for the caterer, and by last name for the escort cards.
• Move to an app when RSVPs are still changing, when parties keep getting split, or when you want guests to see their own table.

Start from the guest list you already have

Don't build the seating sheet from scratch. Your guest list is the seating list, and copying names between two files is how a cousin ends up seated twice.

If you don't have a list yet, our free wedding guest list template already has a Table column, and it opens in Google Sheets or Excel. Add these columns if they're missing:

One row per person matters more than anything else here. A row that says "Dana and Chris" is one row to a formula, and your head count will be wrong by one for every couple.

Add a tables tab that counts for you

Make a second tab called Tables, with three columns:

Change F to whichever column holds the table in your Guests tab. COUNTIF counts how many guests carry that table's name, so Seated goes up as you fill in the Table column on the other tab. Add a fourth column, =B2-C2, for seats left, and give it a red fill whenever it drops below zero (Format, then Conditional formatting, in Google Sheets).

Then turn the Table column on the Guests tab into a dropdown that reads from the Tables tab. In Google Sheets it's Data, then Data validation, with the list taken from your Tables column. It's quick, and it means a typo can't create a table that doesn't exist.

Pro tip: only seat guests marked Yes. Seating the Waiting rows feels productive, but you'll unseat a good share of them later, and they take seats you need.

Getting it out of the spreadsheet

The sheet only helps if people outside it can use it, and different people need it sorted different ways.

• Your caterer wants it by table, with meals and allergies. Sort by Table, then copy each table's rows onto its own page.
• Escort cards or a seating board work best alphabetically by last name, with the table beside each name. Sort by Last name.
• Your venue wants the number of tables, their shape and how many seats each one has. That's your Tables tab.

Every sort is a new printout, though. If anything changes after you send them, you send them all again. Our guide on when to send your seating chart to the venue has the usual deadlines, and they come earlier than most couples expect.

Four signs the spreadsheet has stopped helping

Replies are still coming in. Every new yes or no is now a change in two places: the RSVP column and the Table column. Miss one and the counts are off without you noticing.

You keep splitting couples. Move Dana to Table 4 and Chris stays at Table 2, because a row has no idea who it came with. With 30 couples and a handful of families, this is where the evenings go.

You can't see the room. A column of table numbers doesn't tell you that Table 9 is the one next to the speakers, or that Grandpa's table is a long walk from the restroom. Most couples end up with a spreadsheet and a paper floor plan, kept in sync by hand.

Guests will ask where they sit. At the reception, the answer is a board, a stack of escort cards or a phone. If you'd like the phone to be one of them, a spreadsheet can't send it. We compared the options in how guests find their table.

If none of these apply, keep the spreadsheet. Forty guests at three long tables don't need software.

Moving the plan to an app without retyping it

Most seating apps will take your guest list from a spreadsheet, so the time you spent above isn't wasted. In WhiteClover, the guest list import reads a CSV or Excel file with columns for first name, last name, email, phone and plus-ones, in any order. It doesn't read a Table column, so you'll seat people again in the app. It's quicker the second time:

• Tap a guest, then tap a seat. Partners, kids and plus-ones take the seats next to them, so couples stop getting split.
• Or press "Arrange automatically" to seat everyone who said yes, keep parties together, and add tables if you run out. Then fix the two tables your family will have opinions about.
• Put the venue's floor plan in as a background, so you're placing tables in the actual room.
• Export a PDF with a list per table, or a CSV, for the caterer. The venue gets a link that always shows your current plan, so a change doesn't mean another email.

On the wedding day, each seated guest sees their own table and seat in the guest app, from 2 hours before the reception. They don't see anyone else's. If you turn it on, guests with an email address get their table by email at the same time.

The WhiteClover seating chart is free, including the guest table reveal and the exports. The only paid part is a second seating plan for the same event, which costs €3.99, paid once.

The short version

Use a spreadsheet while your guest list is small and your replies are in: two tabs, COUNTIF, a dropdown, and three different sorts. Move when replies are still changing, when you're spending your evenings putting couples back together, or when you'd like guests to find their table on their own phone.

Frequently asked questions

Can I make a wedding seating chart in Google Sheets?

Yes. Put guests on one tab with a Table column, list your tables on a second tab with their seat counts, and use COUNTIF to count how many guests are at each table. A dropdown on the Table column stops typos from creating extra tables.

Is Excel or Google Sheets better for a seating chart?

Both handle it. Google Sheets is easier if your partner or a parent is editing at the same time, because you're both in the same file. COUNTIF and data validation work the same way in each.

How do I keep couples together in a seating spreadsheet?

Give everyone who arrives together the same value in a Party column, and sort by Party before you assign tables. The spreadsheet won't move them together for you, so check the Party column every time you move someone.

When should I stop using a spreadsheet for seating?

When replies are still coming in, when you keep splitting couples and families, or when you want guests to see their own table on their phone. For a small wedding with final replies, a spreadsheet is usually fine.

Can I import my seating spreadsheet into WhiteClover?

You can import the guest list from it, as a CSV or Excel file. Table assignments aren't imported, so you seat guests again in the app, by tapping or with "Arrange automatically".

Recommended

• Free Wedding Seating Chart Tools That Sync With RSVPs
• Free Wedding Guest List Template (Excel, CSV, Sheets)
• How Guests Find Their Table: Board, Cards or Phone
• When to Send Your Seating Chart to the Venue
• How to Create a Wedding Seating Chart