TL;DR: The most useful wedding guest list template tracks 11 columns: name, plus-one, relationship, side, address, email, phone, RSVP status, meal choice, table number, and notes. You can build it in Google Sheets, Excel, or Notion in about 15 minutes, or use a prebuilt version and skip straight to filling in names.

Direct answer

A wedding guest list template is a spreadsheet (or database) with one row per invited guest and the columns you need to send invitations, track RSVPs, seat people, and mail thank-you notes. You only need one — built well — from engagement through the week after the wedding.

The template must do four jobs:

1. Collect addresses for save-the-dates and invitations.
2. Track RSVPs (attending, declined, no response, plus-ones confirmed).
3. Feed the seating chart (table number, meal choice, dietary notes).
4. Power thank-you notes (gift received, note sent).

If a column doesn't serve one of those jobs, cut it.

Practical sections

The 11-column master template

Copy this structure into any spreadsheet tool:

Add two more if you want a single source of truth through thank-yous: Gift received and Thank-you sent (date).

Three template variations by wedding size

• Under 50 guests. Use the 11-column template as-is. One tab. No formulas needed.
• 50–150 guests. Add a summary tab with live counts: total invited, confirmed yes, confirmed no, pending, plus-ones, meal totals. Use COUNTIF on the status and meal columns.
• 150+ guests. Split into two tabs: Master list (contact and RSVP data) and Day-of list (name, table, meal, allergies) so your caterer and planner get a clean export.

Google Sheets vs. Excel vs. Notion

• Google Sheets — best default. Free, shareable, works on phones, easy to give your partner or MOH edit access. Use this unless you have a reason not to.
• Excel — better if you already track everything in Microsoft 365 or your family is sharing it offline.
• Notion — best if you want filtered views (by RSVP status, by side, by table) without writing formulas. Slower to enter addresses in bulk.

Common mistakes the template should prevent

• One row for "The Smiths." Give every adult their own row. Otherwise you can't track individual RSVPs or meal choices.
• No separate party/household column. You'll need this to send one invitation per household while still counting four RSVPs.
• Free-text RSVP status. Use a dropdown with four values only: Yes, No, Pending, Maybe. Anything else breaks your counts.
• Merging seating into the main list too early. Leave the table column blank until RSVPs are 80% in.

How to use it through the year

1. Brain-dump every possible name with your partner and both sets of parents. Don't filter yet.
2. Categorize by relationship and tier (A-list, B-list) in the Notes column.
3. Cut to your budget cap using the guide below — every added guest typically costs $150–$300 in food, drink, and rentals.
4. Lock addresses before save-the-dates (about 6–8 months out).
5. Update RSVP status weekly once invitations go out.
6. Export the day-of view two weeks before the wedding for your caterer, planner, and calligrapher.

Build your list in minutes

If you'd rather not set up columns and formulas yourself, our generator creates a pre-filled template and pulls addresses, RSVPs, and seating into one place automatically.

Try the Wedding Guest List Generator

Related pages

• Wedding Guest List Generator
• Wedding Guest List Guide
• Wedding Guest List Etiquette
• Wedding Guest List Examples
• Guest List for a 25-Guest Wedding
• Wedding Budget Guide

FAQ

What columns should a wedding guest list template have?

At minimum: full name, party/household, side, relationship, plus-one, mailing address, email, RSVP status, meal choice, table number, and notes. Add gift received and thank-you sent if you want one document to carry you from engagement through the week after the wedding.

Should couples be on one row or two?

Two rows, grouped by a shared party or household ID. This lets you send one invitation per household while still tracking each person's RSVP, meal choice, and dietary notes individually — which your caterer will require.

Is Google Sheets or Excel better for a guest list?

Google Sheets is better for almost every couple because it's free, updates live across devices, and lets you share editing access with your partner, parents, or MOH. Use Excel only if your family already collaborates in Microsoft 365.

How do I track plus-ones in the template?

Use a dedicated Plus-one column with three values: Yes, No, or TBD. When a guest confirms a plus-one's name, add them as their own row under the same party/household ID so they count toward meals and seating.

How far in advance should I build the template?

Start it the month you get engaged, before you set a venue. Your guest count drives the venue size and roughly 40–50% of your total budget, so you need a rough number before you can book anything meaningful.

Can I use the same template for save-the-dates, invitations, and thank-yous?

Yes — that's the point of building it once with the right columns. A well-structured template is the single source of truth you'll sort and filter for each mailing, rather than rebuilding a list three separate times.

How do I handle B-list guests in the template?

Add a Tier column with values A and B. Only send B-list invitations as A-list declines come in, and keep B-list save-the-dates off your first mailing. Target sending B-list invitations at least 6 weeks before the wedding so RSVPs still arrive in time.

Get started

Skip the setup and start with a ready-made guest list template that tracks RSVPs, meals, and seating in one place. create_free_account