Annual Dinner Seating Plan: Free Excel Template and Guide
A free seating plan template for annual dinners to copy into Excel or Google Sheets, plus how to seat VIPs, departments and guests with dietary needs.
Every annual dinner has a moment, usually around 7.15pm, when 400 people arrive at once and crowd around one printed board looking for their name. Behind that board sit weeks of decisions: who sits with the CEO, which departments share a table, where the vegetarian guests and the wheelchair user go, and what happens when 20 people RSVP the week before.
This guide walks through those decisions in the order you'll make them, and gives you a free seating plan template to copy into Excel or Google Sheets, with formulas that count the seats left at each table and the dietary numbers per table for the caterer.
The short answer. An annual dinner seating plan assigns every confirmed guest to a numbered table on the venue floor plan. Start from the final RSVP list, seat the VIP and management tables first near the stage, keep departments together with one or two mixed tables, give the caterer dietary counts per table, keep 5 to 10% of seats spare, and freeze the plan three to five days before the dinner.
Free annual dinner seating plan template
The template is two tables you copy into Google Sheets or Excel. Select a table on this page, copy it, and paste it into cell A1 of a new sheet. Three formulas then do the counting for you.
Sheet 1: Guest list
Paste this into a sheet named Guest list, one row per guest. Delete the example rows when you start.
No. | Guest name | Department | Guest type | RSVP | Dietary | Notes | Table |
|---|---|---|---|---|---|---|---|
1 | Ahmad Kamal | Management | Management | Yes | Standard | CEO, speech at 8.30pm | 1 |
2 | Lim Mei Ling | Board | VIP | Yes | Vegetarian | Guest of honour | 1 |
3 | Tan Wei Jie | Sales | Staff | Yes | No beef | 2 | |
4 | Daniel Wong | Sales | Plus-one | Yes | Standard | Plus-one of Tan Wei Jie | 2 |
5 | Nurul Huda | Sales | Staff | Yes | Standard | Wheelchair, aisle seat near the entrance | 2 |
6 | Siti Aminah | Finance | Staff | Yes | Allergy | Peanut allergy | 3 |
7 | Ravi Kumar | Finance | Staff | Pending | Standard |
Keep the RSVP column to Yes, No or Pending, and the dietary column to one label per guest (Standard, Vegetarian, Vegan, No beef, No seafood or Allergy), or the counts won't match. In Google Sheets, Data, then Data validation, turns both columns into drop-down lists.
Sheet 2: Tables
Paste this into a second sheet named Tables, one row per table. The numbers in the last five columns come from the formulas below; these show what the example guests produce.
Table | Label | Capacity | Seated | Seats left | Vegetarian | No beef | Allergy |
|---|---|---|---|---|---|---|---|
1 | VIP | 10 | 2 | 8 | 1 | 0 | 0 |
2 | Sales | 10 | 3 | 7 | 0 | 1 | 0 |
3 | Finance | 10 | 1 | 9 | 0 | 0 | 1 |
The formulas
Type these into row 2 of the Tables sheet, then copy them down to every table:
Seated (column D): =COUNTIFS('Guest list'!H:H, A2, 'Guest list'!E:E, "Yes")
Seats left (column E): =C2-D2
Vegetarian (column F): =COUNTIFS('Guest list'!H:H, A2, 'Guest list'!E:E, "Yes", 'Guest list'!F:F, "Vegetarian")
For the No beef and Allergy columns, copy the vegetarian formula and change "Vegetarian" to "No beef" or "Allergy". Only guests who said yes are counted. A negative number under Seats left means the table is over capacity. To find confirmed guests who still have no table, filter the Guest list for RSVP Yes and an empty Table column.
Seating plan, seating chart or table plan?
They mean almost the same thing. A seating plan, or table plan, is the list of who sits at which table. A seating chart is the version guests read at the entrance, usually sorted A to Z with a table number beside each name. The floor plan, or layout, shows where the tables, stage, screens and doors physically sit in the room. An annual dinner needs all three, and they have to agree with each other.
What you need before you start
The final guest list with RSVPs. Set an RSVP cut-off about two weeks before the dinner and chase the non-replies. A seating plan built on "maybe" falls apart.
The venue floor plan from the hotel's banquet team, with the number and size of tables, the stage, screens, buffet lines and doors.
Table capacity. Round tables of 10 are the standard in Malaysian hotel ballrooms.
The VIP list: board members, the guest of honour, sponsors and anyone giving a speech or an award.
Dietary and access needs, collected on the RSVP form rather than by email the week before.
The programme, so you know who needs to reach the stage quickly. Your run of show has it.
If you have Muslim guests, confirm the venue and caterer are halal-certified first: a seating plan can't fix a kitchen. The dietary column is then for vegetarian and vegan guests, no beef, no seafood and allergies.
Banquet, cabaret or long tables?
Most annual dinners use banquet seating, but the layout changes how many tables you need and how well everyone sees the stage.
Layout | How it works | Seats per table | Best for |
|---|---|---|---|
Banquet | Round tables with chairs all the way round | 10 (8 to 12) | Dinners where the meal and the table conversation matter most |
Cabaret | Round tables with the side facing the stage left open | 6 to 8 | Award nights and shows where everyone needs to see the stage and screens |
Long tables | Rows of rectangular tables, guests on both sides | 8 to 20 per row | Casual dinners, family days and smaller rooms |
Cabaret seating needs between a quarter and two thirds more tables than banquet for the same crowd, so check the room can take them before you promise a show-style night.
Table size matters too. A 1.5 m (5 ft) round table seats 8 to 10, and a 1.8 m (6 ft) round seats 10 to 12. Ask the venue which they use: 12 people at a 1.5 m table is a squeeze.
To count tables, divide confirmed guests by seats per table, round up, then add 5 to 10% spare seats. For 380 guests at tables of 10, that's 38 tables plus two to four spare.
How to make an annual dinner seating plan, step by step
1. Number the tables on the floor plan
Number the tables in an order guests can follow: table 1 at the front centre, then outwards in a sweep, with no gaps. Put the numbers on tall stands so they can be seen over seated guests. With Chinese-majority crowds some organisers skip table 4, because the number sounds like the word for death in Mandarin and Cantonese.
2. Seat the VIP and management tables first
Table 1 goes front and centre, facing the stage, near the steps if anyone at it will go up for a speech or an award. Seat the CEO and the guest of honour where they can watch the stage without turning their chairs, with their spouses beside them. If there are more VIPs than one table holds, use tables 1 and 2 side by side instead of spreading them around the room.
3. Seat departments together, then mix on purpose
People enjoy the night more next to colleagues they know, so start by grouping departments and teams. Then decide where you want mixing: a table of new joiners from several departments, or two teams that work together but rarely meet. Note the reason. When someone asks why they're at table 17, "we put the new joiners together" is an easy answer.
4. Keep couples and plus-ones together
A plus-one seated away from the person who brought them spends the evening on their phone. Seat them together, and write "plus-one of" in the notes so the pair stays linked when you move tables around.
5. Plan for dietary and access needs
Give the caterer dietary counts per table, not just the total: the waiter at table 23 needs to know a vegetarian set is coming. Seat wheelchair users at an aisle table near the entrance and the toilets, and older guests away from the speaker stacks.
6. Seat sponsors, crew and performers
Sponsors usually sit at or next to the VIP tables, especially anyone presenting a prize. Give the emcee, photographers and AV crew a table near the stage or the control desk, so they can get up without crossing the room.
7. Leave spare seats
Keep 5 to 10% of seats spare, spread across a few tables near the entrance rather than one empty table. Late RSVPs, walk-ins and last-minute plus-ones will fill them, and an empty table in front of the stage looks worse than a few gaps at the back.
8. Check sightlines and service paths
Walk the floor plan with the venue. Can every table see a screen? Is any table behind a pillar or right in front of a speaker? Is there a clear path for the waiters, and for award winners walking to the stage?
9. Freeze the plan and send the numbers
Freeze the plan three to five days before the dinner, and send the final count to the venue by the guarantee date in your contract. After that, handle changes on the night with the spare seats instead of reshuffling tables.
Common seating mistakes
Splitting the VIPs across the room. Speeches, awards and the photographer all need them in one place.
Planning from the invite list instead of confirmed RSVPs. Empty seats at the front look worse than full tables at the back.
Seating a plus-one at a different table from the person who brought them.
Forgetting the waiters. Tables packed too close slow down every course.
Changing the plan without changing the door list. The guest is sent to table 12 and finds someone else in their seat.
One seating board for 400 guests. It creates a crowd at the entrance just as the programme is about to start.
On the night: how guests find their table
The seating chart at the entrance is where the plan meets the guests, and it is often the first queue of the evening.
Sort it A to Z by name, with the table number beside each name. Guests know their own name, not their department's table.
Split it across two or three boards above about 200 guests, for example A to H, I to Q and R to Z, so the crowd splits too.
Print it large. A1 or A0 foam boards are common at Malaysian print shops, and names should be readable from two steps back.
Give VIPs an usher so they never have to look for their name.
Use tall table-number stands so guests can spot table 23 from the doorway.
Digital check-in removes the board altogether: each guest is scanned at the door and told their table there and then. If you send the annual dinner invitation by email or WhatsApp, put the table number in the final reminder too.
Where SOURems fits
For a 50-person team dinner at one restaurant, the template above is all you need. For a few hundred guests in a ballroom, SOURems connects the seating plan to the rest of the night:
The floor plan. Draw the ballroom in the Layout Designer over a photo or PDF of the venue's plan, with banquet tables, the stage, entrances and named zones.
Seat assignment. Assign guests to tables one by one or in bulk, from the same guest list that holds their RSVPs and dietary notes.
The table travels with the guest. It appears on their ticket, in the confirmation email, on their Apple Wallet or Google Wallet pass and on their phone.
No crowd at the board. When a guest is scanned at the door, a "find your seat" welcome screen shows their table in large type with the route on the floor plan, and their phone shows a button that takes them to their table.
Staff see what matters. Dietary needs and VIP notes come up on the scanner, so the usher knows before the guest says a word, and walk-ins can be given a ticket on the spot.
After dinner. Run the lucky draw from the guests who actually checked in.
SOURapp is free to download for planning an event and collecting RSVPs. See how RSVP tracking and QR check-in work, or how SOURems handles event management in Malaysia. Still choosing a theme? Start with annual dinner theme ideas.
FAQ
What size should a table seating chart be?
Big enough to read from two steps back. For annual dinners in Malaysia, A1 (594 × 841 mm) and A0 (841 × 1,189 mm) foam boards are common, sorted A to Z by name. Above about 200 guests, use two or three boards split by letter so people don't crowd one spot.
What is the difference between cabaret seating and banquet seating?
Banquet seating fills round tables all the way round, usually 10 to a table. Cabaret seating uses the same round tables but leaves the side facing the stage empty, so 6 to 8 guests all face the front. Cabaret suits award nights and performances; banquet fits more people in the room.
What do you call a seating plan?
A seating plan is also called a table plan or seating arrangement. The display version at the entrance is usually called the seating chart, and the drawing of the room is the floor plan or layout.
How many people sit at a round table?
A 1.5 m (5 ft) round table seats 8 to 10, and a 1.8 m (6 ft) round table seats 10 to 12. Hotel banquets in Malaysia are usually planned at 10 per table.
Where should the CEO sit at an annual dinner?
At table 1, front and centre, facing the stage, with the guest of honour and their spouses. Keep the table close to the stage steps if anyone at it is giving a speech or presenting awards.
When should the seating plan be finalised?
Three to five days before the dinner: after the RSVP cut-off and before the venue's final guarantee date. Keep 5 to 10% of seats spare for changes on the night.
