Quick answer
A spreadsheet is enough for a small list. Set it up once with these columns and formulas.
| If you have | Use | Why |
|---|---|---|
| Under about 40 guests, one function | A spreadsheet | Free and simple |
| 50+ guests or several functions | Consider a platform | Saves hours of chasing |
| Anytime | Copy the header row below | Start in a minute |
The columns to use
| Column | Header | What goes in it |
|---|---|---|
| A | Household | Family or household name |
| B | Guests | Names, comma-separated |
| C | Side | Bride / Groom / Both |
| D | Phone | WhatsApp number with country code |
| E | Invited to | Functions, e.g. Mehendi, Wedding, Reception |
| F | Invited | Number of people invited |
| G | RSVP | Yes / No / Maybe / Pending |
| H | Attending | Number actually coming |
| I | Meal | Veg / Non-veg / Jain |
| J | Table or room | Seating or stay |
| K | Notes | Allergies, 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 want | Formula (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
- Sort by RSVP so Pending sits on top.
- Message the pending households (templates here).
- Update rows the same day a reply arrives; stale sheets cause the errors.
- Send the caterer the “confirmed” total, with veg and non-veg split, only after the deadline.
Signs you have outgrown the sheet
- More than about 50 households
- Several functions with different guest lists
- Two or more people editing, and the versions disagree
- You spend more time chasing than planning
- Guests keep asking for the venue details again
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).