Wedding Guest List & RSVP Tracker Spreadsheet: Columns, Formulas and When to Switch

The columns, the formulas and a weekly routine for tracking a wedding guest list in Excel or Google Sheets, and how to tell when it is time to switch.

7 min read · Updated November 2026

Quick answer

A spreadsheet is enough for a small list. Set it up once with these columns and formulas.

If you haveUseWhy
Under about 40 guests, one functionA spreadsheetFree and simple
50+ guests or several functionsConsider a platformSaves hours of chasing
AnytimeCopy the header row belowStart in a minute

The columns to use

ColumnHeaderWhat goes in it
AHouseholdFamily or household name
BGuestsNames, comma-separated
CSideBride / Groom / Both
DPhoneWhatsApp number with country code
EInvited toFunctions, e.g. Mehendi, Wedding, Reception
FInvitedNumber of people invited
GRSVPYes / No / Maybe / Pending
HAttendingNumber actually coming
IMealVeg / Non-veg / Jain
JTable or roomSeating or stay
KNotesAllergies, travel, who invited them

Count households, not individuals, as rows; one reply per household is far easier to chase.

Header row (tab-separated, paste into cell A1)

Household Guests Side Phone Invited to Invited RSVP Attending Meal Table or room Notes

Formulas worth adding

What you wantFormula (rows 2–500)
Total people invited=SUM(F2:F500)
People confirmed attending=SUMIF(G2:G500,"Yes",H2:H500)
Households still pending=COUNTIF(G2:G500,"Pending")
Households declined=COUNTIF(G2:G500,"No")
Veg meals confirmed=SUMIFS(H2:H500,G2:G500,"Yes",I2:I500,"Veg")
Reply rate=1-COUNTIF(G2:G500,"Pending")/COUNTA(A2:A500)

Add a drop-down to column G (Data → Data validation → list: Yes, No, Maybe, Pending) so spellings stay consistent, and a conditional-format rule on =$G2="Pending" to colour unanswered rows.

A weekly routine that works

  1. Sort by RSVP so Pending sits on top.
  2. Message the pending households (templates here).
  3. Update rows the same day a reply arrives; stale sheets cause the errors.
  4. Send the caterer the “confirmed” total, with veg and non-veg split, only after the deadline.

Signs you have outgrown the sheet

At that point a platform counts replies from a personal link and builds your “not replied” list for you; see Google Forms vs a platform or the guest-management comparison. eInvit’s guest list also exports to CSV, so your sheet can come with you.

Frequently asked questions

How do I make a wedding guest list in Excel?

Use one row per household with columns for names, side, phone, functions invited to, number invited, RSVP status, number attending, meal preference and notes. Copy the header row above.

How do I count confirmed guests in Google Sheets?

Use =SUMIF(G2:G500,"Yes",H2:H500), where G is the RSVP column and H the number attending.

How do I find who has not replied?

Filter the RSVP column for Pending, or colour those rows with conditional formatting.

Should I list households or individuals?

Households. It matches how invitations are sent and replies arrive, and it is easier to chase.

When should I move from a spreadsheet to an RSVP platform?

When you pass about 50 households, add more functions, or share the sheet with several people. A platform removes the manual cross-checking.

Can I import my spreadsheet into eInvit?

Yes. The guest list supports CSV import and export, including an optional “events” column to say which functions each guest is invited to (Premium Plus and above).