GUESTORA: Wedding Guest List Template for Google Sheets

GUESTORA holds the whole guest list on a single tab and keeps a running count above it: who's coming, how many seats they take, and who still owes you an answer. It's a wedding guest list template for Google Sheets with no account behind it and no trial — the free .xlsx download is the product, and it opens in Google Sheets, Excel or LibreOffice.

What the guest list template tracks

The Guest list tab gives each guest a row: name, group (Family, Friends, Work and any you add, from a dropdown), the number of extra guests they bring, the seats that takes, an RSVP, a table and whether the gift has arrived. Four figures sit above the table and read the whole list: guests on the list, seats confirmed, awaiting reply and declined. The Lists tab is the editable source of the dropdowns — your guest groups, the RSVP options (Yes, No, No reply) and the gift toggle.

How the wedding spreadsheet counts seats and RSVPs

Seats is the column you never fill in: for each named guest the sheet counts one plus their extra guests, so a couple with two children reads four without arithmetic on your part. The headline totals follow from there — confirmed seats sum the Seats of everyone whose RSVP is Yes, awaiting reply counts the No-reply rows, declined counts the No rows. Colour rules make the table readable at a glance: a Yes turns the row soft green, a No fades it red, a No-reply sits amber. Twelve sample guests arrive across all three RSVP states on purpose, so the counts and the formatting show themselves before your own names go in.

How to build the guest list in Google Sheets

1. Adjust your guest groups on the Lists tab if you want different names.
2. Add each guest and set how many extra guests they bring — Seats works the rest out.
3. Mark the RSVP from the dropdown: confirmed turns green, declined red, no reply amber.
4. Assign a table and tick the gift when it arrives.
5. Read the totals up top for guests, confirmed seats and who still hasn't replied.

A guest list template in twelve languages

Wedding lists aren't all written in English, so GUESTORA ships in twelve language editions — each a separate .xlsx with column labels, groups, RSVP options and date formats translated, formulas untouched. Download the one that matches your page language; the opening guide covers getting any of them into Google Sheets.

Counting heads is the first job of any gathering; once the numbers settle, SHOPLIX turns them into a shopping list for the catering side. Both belong to the broader set of wedding and event templates under home and life templates for Google Sheets.