Skip to content
The title slide and first slides of the Wedding Guest List template

Wedding Guest List

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
3
Difficulty
Beginner
Updated
November 6, 2026

Every slide (3)

Overview

A guest list for couples planning a wedding or a similar celebration. Each row is one guest, with their side, group, reply, meal choice, plus one and table number. The Dashboard counts replies, seats and meal choices, so you can see how many places to cater for and who still needs a reply.

The template comes with sample guests. Make a copy, then replace the sample rows with your own. Seat counts, the dashboard and the charts update on their own as you add guests or change a reply.

Useful for

  • Chasing replies and counting the seats confirmed so far
  • Sending the caterer a final meal count
  • Planning the seating by table

What's included

  • 3 tabs: Dashboard, Guests, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Guests: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Guests tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Is this Wedding Guest List template free?

Yes. Download the template and make a copy for your own use at no cost.

Does it work in Excel?

Yes. Download the .xlsx file from this page and open it in Microsoft Excel. The tabs, formulas, dropdowns and charts all work there.

How are seats counted?

Each guest counts as one seat, or two when Plus one is ticked. The dashboard adds up the seats for guests who have replied Yes.

  • #wedding-planner
  • #wedding-guest-list
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Holidays

All holidays templates
Get this template

Preparing your template…