How to make a wedding seating chart in Excel

Start a new sheet with five headers in row 1: name, group, meal, rsvp, note. Enter one row per person, not per household or per invitation. A household row ('The Johnsons, 4') cannot be counted for meals, cannot be split across tables and cannot be sorted alphabetically for the chart; you will end up splitting it later anyway.

Use the name as it should appear on the chart. Put the group in words you will reuse consistently (family, friends, colleagues), the meal as a short label (standard, vegetarian, vegan, child) and the RSVP as yes, pending or no. Keep allergies and anything the caterer or venue needs to know in the note column. Freeze the top row (View, Freeze Panes) so the headers stay visible while you scroll.

• name: full name, surname spelled the way the guest spells it
• group: family, friends, colleagues, or your own labels
• meal: standard, vegetarian, vegan, child, or the menu names from your caterer
• rsvp: yes, pending, no (leave blank for not yet invited, or add a 'sent' value)
• note: allergies, mobility needs, 'must sit with Grandma', 'ex of Table 4'

Turn the header row into a filter (Data, Filter, or Ctrl+Shift+L) so you can show only pending guests when chasing replies, or only vegetarians when confirming numbers. To stop typos such as 'Veg' and 'vegetarian' being counted as two meals, add a dropdown to the meal and rsvp columns with Data Validation, List, and type the allowed values separated by commas.

Put the counts you will be asked for in a corner of the sheet: =COUNTIF(D:D,"yes") for confirmed guests, =COUNTIF(D:D,"pending") for replies outstanding, and =COUNTIFS(D:D,"yes",C:C,"vegetarian") for each meal among confirmed guests. The caterer wants meals for people who are coming, not for everyone invited, which is why the two-condition version matters. In Google Sheets the same formulas work unchanged.

Add a sixth column, table, and type a table number or name against each confirmed guest. Sort by table (Data, Sort) to see each table as a block, and sort by name when you need the alphabetical view. In a spare area, list your table numbers down a column and put =COUNTIF(F:F,H2) beside each to see how many people you have put on it. Add a conditional format that turns the cell red when the count exceeds the seats on that table (8 on a 5 ft round, 10 on a 6 ft round).

Keep the note column open while you do this. The 'keep together' and 'keep apart' constraints that make seating hard live only in your head and in those notes, and the spreadsheet will not warn you when you break one. If you and your partner are both editing, use Google Sheets; an Excel file emailed back and forth quickly becomes two conflicting versions.

The spreadsheet has no idea of the room. It cannot tell you that Table 9 is next to the speakers, that the two tables of your partner's colleagues are at opposite ends of the hall, or that there is no table near the door for the guests who arrive late with a baby. Moving a guest means retyping a cell, and moving a whole table means retyping a dozen; after the tenth RSVP change you will stop re-checking capacities.

Printing is the other wall. Excel prints a grid, not a poster; getting a legible A1 chart out of it means exporting to another program and laying out the text by hand, then doing it again for the place cards and the catering list. Most couples who start in Excel end up with the guest list in one file, the poster in Canva and the caterer's list in an email, and the three drift apart in the final week.

The fix is to keep Excel for what it is good at, the list, and import it into a planner for the room and the printing. In Excel, use File, Save As, and choose CSV UTF-8 as the type; in Google Sheets, use File, Download, Comma Separated Values. The free Seating Plan planner reads the headers name, group, meal, rsvp and note, accepts common variants such as guest, side, diet, status or allergies, matches your meal labels to its standard, vegetarian, vegan and child categories where they fit (anything else is kept as 'other'), and treats blank RSVP cells as yes.

If you would rather not export at all, copy the cells and paste them into the paste-a-list box; tab-separated cells import the same way. From there you draw the tables and the dance floor, drag guests into seats or let auto-seat fill the gaps around the people you placed by hand, and the poster, place cards and catering list come out of the same data. When you need the spreadsheet again, export a CSV with the table and seat added as columns.