How to make a seating chart in Excel
A spreadsheet is a fine place to decide who sits where. It is a rough place to make the actual cards. Here is how to plan the seating in Excel or Google Sheets, then turn it into printed paper without wrestling the page layout.
Set up three columns
One row per guest, three columns across. That is the whole structure a seating chart needs, whether you use Excel or Google Sheets.
- Name: first and last, one guest per row
- Table: a number, or a name like Head Table
- Meal: chicken, beef, or vegetarian, if you offered a choice
Sort by table to check your work
Sort the sheet by the Table column and every table lands together. Count the rows in each group against your seats per table, and you will catch an overbooked table before the day, not during it.
Sort by Name instead and you get a find-your-seat view, the same order an escort display or a chart poster wants. Switching between the two views is the one thing a spreadsheet is genuinely good at here.
The part a spreadsheet cannot do
A sheet holds the plan. It does not lay out tent cards, fold lines, table signs, or a poster the room can read. Formatting a few hundred cards by hand is the lost weekend most people do not see coming.
Paste the same three columns into Seatwright and it prints the set: escort cards sorted A to Z, place cards grouped by table, a number for every table, and one chart poster. It reads the exact columns you already built, so the plan you made in the sheet becomes the paper.
Related reading
How to make a seating chart in Canva
Canva is a lovely place to design a sign. It is a slow place to seat 120 people. Here is how to build a seating chart in Canva, and where you will feel the drag, so you can decide if it is the right tool for your list.
How to make a seating chart in Word
Word is where a lot of people try to turn the plan into paper. It can do it, with a table for the chart or mail merge for the cards. Here is the method, and the part that quietly eats an evening.
How to make a wedding seating chart
The RSVPs are finally in, and now a hundred names have to land at a dozen tables. Here is a straightforward way to build the chart without moving sticky notes around a wall for a week.
Keep going
Seating chart
One poster by the door lets everyone find their seat at a glance. Seatwright lays out your whole list alphabetically with each guest's table beside the name.
Place cards
Place cards sit at the seat itself. Seatwright groups your guests by table and prints one card each, with the meal choice underneath the name if you added one.
Wedding
The seating took weeks. The paper should take an afternoon. Paste your final list and Seatwright lays out the whole day-of set at once.
Corporate banquet
Awards night, team dinner, or annual banquet. Paste the roster and print escort cards, table signs, and a chart at once.
Questions
Can you make a seating chart in Excel?
Yes, as a plan. Three columns, name, table, and meal, with one guest per row, and a sort by the table column to group everyone. For the printed cards you still have to lay them out, which is the slow part a card tool handles.
How do I turn a spreadsheet into place cards?
Copy the name and table columns and paste them into Seatwright. It fills every card from the list, so you skip placing each name by hand. If you paste only names with no tables, it can assign the tables for you.
Google Sheets or Excel for a seating chart?
Either is fine, since the columns are identical. Whichever you pick, the sheet is only the plan until you print the cards, so choose the one you already know.
Paste your list, see it laid out
When the plan is done, Seatwright turns your guest list into the whole day-of paper set in one pass.
Start freeFree to preview. One payment per event to print.