Google Sheets Seating Chart Template

A free seating chart for Google Sheets: type each guest’s name under their table, and the guest list fills in everyone’s table and seat and flags anyone missing. Works in Excel too, with Google Docs and Slides options below.

  • Free, no sign-up here
  • Google Sheets and Excel
  • Flags unseated guests
  • Imports into the floor plan
Example
Show an example for

Get started

  1. Choose how to start
  2. Add your guests
  3. Set up your tables
  4. Seat everyone
  5. Print or share

Step 1 of 5: Choose how to start. What you see is an example. Click the others below to see what you can make, then keep a layout for your own names or start with an empty room.You’re looking at an example. Try the others, then pick one or start blank.

Show an example for
Every rule is met

How to use the Google Sheets seating chart template

  1. Open it in Google Sheets. Download the template, upload it to Google Drive and open it with Google Sheets.
  2. List your guests. Type one guest per row in the Name column of the Guests sheet.
  3. Fill in the chart. On the Chart sheet, type or paste each guest’s name into a seat under their table.
  4. Check the list. The Guests sheet shows every guest’s table and seat, and says Not seated or Seated twice where needed.
  5. Draw the room. Download the sheet as .xlsx and import it above to get a floor plan, or press Smart arrange to seat everyone for you.

Download the Google Sheets seating chart template

Download the template (.xlsx), upload it to Google Drive and open it with Google Sheets (or choose File > Import in a new spreadsheet). It has three sheets:

  • Guests: type everyone’s name here. Table, Seat no. and Check fill in by themselves.
  • Chart: the seating chart itself, ten tables of ten seats. Type or paste a name into a seat under its table. Seated and Free count each table.
  • How to use: these steps, in short.
The Guests sheet: eight names with their table and seat found from the chart; Sam Patel and Tom Reed show Not seated in the Check column.
The Chart sheet, first four tables: Table 1 has Ana Ortega, Luis Ortega and Priya Shah, Table 2 Mia and Leo Chen, Table 3 Grace Obi; below, Seated, Seats and Free for each table.

Rename “Table 1” and the others to your table names, and change Seats to each table’s size. For more tables, insert columns between Table 1 and Table 10; for more seats, insert rows between seat 1 and seat 10. The formulas follow. Names must be spelled the same on both sheets.

Turn the sheet into a floor plan

In Google Sheets, choose File > Download > Microsoft Excel (.xlsx). Above, press Use this layout to clear the example guests, then Add people and Import a file: everyone you placed in the chart sits at that table, and the rest wait in the list. Press Smart arrange to seat them, then print the floor plan as a PDF. You can also copy the Name and Table columns and paste them into Add people.

Google Docs seating chart templates

These Word templates open in Google Docs: upload the .docx file to Google Drive, then open it with Google Docs.

More, with pictures, on the seating chart template for Word page.

A seating chart in Google Slides

Slides suits a classroom chart you show on the board. The PowerPoint seating chart template opens in Google Slides (upload it to Google Drive, then open it with Google Slides): a classroom of 30 desks, round tables that move with their chairs, and a sign by table. More on the PowerPoint template page. To draw your own, use Insert > Shape and duplicate with Ctrl+D (⌘D on a Mac), or make the plan above, download the PNG image from Print & export and choose Insert > Image on a slide.

Frequently asked questions

Is there a free seating chart template for Google Sheets?

Yes. Download the template on this page and open it in Google Sheets. It’s free, with no sign-up here; you need a Google account to use Sheets.

How do I open the template in Google Sheets?

Upload the .xlsx file to Google Drive, then open it with Google Sheets. Or, in a new spreadsheet, choose File > Import > Upload.

Is there a seating chart template for Google Docs?

Yes. The Word templates (an A–Z list, a chart by table, and lists for round tables) open in Google Docs: upload the .docx file to Google Drive and open it with Google Docs.

Can I make a seating chart in Google Slides?

Yes. Open the PowerPoint seating chart template in Google Slides (upload it to Google Drive first), draw tables with Insert > Shape, or insert a PNG of the plan made above.

Does the template work in Excel too?

Yes. The formulas work in Excel and Google Sheets. For a guest list with seat counts per table, see also the Excel seating chart template. See the Excel template.

Can I share the seating chart?

In Google Sheets, use Share to edit it with a partner or planner. The chart above saves on your device; to pass it on, download the Plan file from Print & export, then choose “Open a plan file” on the other device.