Wedding Guest List Tracker: Columns, RSVP Formulas and Requests

Wedding Guest List Tracker: Track RSVPs, Meals and Guest Requests in One Place

Set up the wedding guest list tracker

Use one spreadsheet with one row per person, not per household. Plus ones and children get their own rows too, so every count and meal total comes out right without extra math. Google Sheets and Excel both work. These columns cover the questions you will be asked between the save the dates and the thank you notes:

A. Name: the guest's full name.
B. Household: the invitation they belong to, such as The Patel family, so one envelope maps to several rows.
C. Side: bride, groom, partner's name or both.
D. Group: family, college friends, work. Useful for seating.
E. RSVP: Invited, Yes, No or No reply.
F. Plus one of: the name of the guest they come with, if any.
G. Meal: the choice from the RSVP card, such as Chicken, Fish or Vegan.
H. Dietary needs and allergies: only what the caterer needs to act on.
I. Table: a number, filled in when you build the seating chart.
J. Requests: a short line, such as step free entrance or arrives Saturday.
K. Mailing address: used for the invitation and again for the thank you card.
L. Email or phone: for chasing late RSVPs.
M. Thank you sent: Yes or No.

Make the RSVP and Meal columns dropdowns so nobody types "yes!" or "veg". In Google Sheets, select the column, click Insert, then Dropdown, and enter the options, as Google's dropdown help shows. A dropdown keeps the formulas below accurate.

Vendors and gifts belong in their own sheets. A wedding vendor tracker holds quotes and contracts, and registry gifts need their own list for thank you notes.

Count RSVPs and meals with simple formulas

Put a small summary block at the top or on a second tab. With guests in rows 2 to 300 and the columns above, these formulas work in both Google Sheets and Excel:

Total invited: =COUNTA(A2:A300)
Attending: =COUNTIF(E2:E300,"Yes")
Declined: =COUNTIF(E2:E300,"No")
Still to answer: =COUNTIF(E2:E300,"No reply")
Confirmed vegan meals: =COUNTIFS(E2:E300,"Yes",G2:G300,"Vegan")
Confirmed guests at table 5: =COUNTIFS(E2:E300,"Yes",I2:I300,5)

COUNTIF counts the cells in a range that match one condition, and COUNTIFS checks several ranges at once. The syntax is in Google's COUNTIF help, Google's COUNTIFS help and Microsoft's COUNTIF help. Count meals only among guests who said Yes, because the caterer needs confirmed numbers.

Share the guest list without losing control

Give edit access only to the people who change the list, usually you, your partner and your planner. In Google Sheets, click Share, add their email and choose Editor, Commenter or Viewer, per Google's sharing help. Parents who want to suggest names fit Commenter: they can comment but cannot edit.

Use filter views when several people work in the sheet. A filter view lets you sort or filter for your own view, such as "No reply" guests only, without changing what others see. Click Data, then Create filter view, as Google's sort and filter help describes.

Vendors rarely need the whole list. Send the caterer a count and the dietary column, and the venue the table numbers. That keeps addresses and family notes inside the tracker.

Give Telegram one clear job

A guest spreadsheet is for structured facts: names, contact details, RSVP status, meal selection, table assignment and gifts. Requests arrive as sentences and often do not fit those columns:

Sebastian became vegan after submitting his RSVP.
Marcus can attend Saturday but not Friday.
Grandma needs a route without stairs.
Two relatives should not sit together.
Your father-in-law requested a particular recording of a song.

A single notes column quickly becomes unreadable. Let Telegram preserve original conversations and loose details while the spreadsheet remains the operational record. This division is especially useful when wedding plans are saved everywhere.

Send every request to Saved Messages

Use one destination regardless of where the request arrived:

Forward Telegram messages.
Screenshot iMessage or Instagram requests and attach them.
Write a short note immediately after a phone call.
Forward voice notes and add a written caption.

The destination matters more than the original channel. You should not need to remember which app Aunt Lisa used when the caterer asks about Sebastian's meal.

Put the guest's name in every caption

Use ordinary language and include the person affected, the request, the next action and any relevant deadline or source:

Aunt Lisa says Sebastian is vegan. Confirm his meal with the caterer.
Marcus arrives Saturday morning and needs the ceremony time.
Grandma uses a walker. Ask the venue about the path beside the arbor.
Do not seat Nina with Uncle Ron. Request came from Mom.

Names and concrete descriptions are stronger retrieval clues than labels such as food, travel or important, especially when you cannot remember the exact words used. Preserve the original message, but caption it in language you expect to search.

Review requests at planning checkpoints

A single inbox works only when it is reviewed before real decisions. Search Saved Messages before:

Sending final dietary information to the caterer
Locking the seating chart
Confirming airport or hotel transport
Walking the venue for accessibility
Finalizing music with the DJ
Sharing the wedding-day schedule

Search names and concrete words such as vegan, allergy, walker, flight, ride, Saturday, seat, song and toast. You can also work through the guest list household by household. A child's bedtime might affect transport, dinner timing and seating even if it was not filed under any of them.

Handle screenshots and voice notes carefully

Never save an attachment without a short note. You do not need a full transcription. Capture the guest's name, what they need and what you must do next. This prevents Telegram from becoming another unusable archive, like an unmanaged screenshot collection or bookmark graveyard.

Keep sensitive details limited

Wedding requests may contain allergies, health needs, family conflicts and travel plans. Record only what is necessary to act:

Grandma needs a step-free entrance is usually enough.
Keep Nina and Ron at different tables may be enough without the private argument.

Share operational details only with the people who need them. The caterer needs the meal restriction; the venue coordinator may need the mobility requirement; other guests usually do not.

When Telegram is enough

Saved Messages is enough when you consistently forward every request, add a clear caption and transfer final decisions into the proper planning document.

It becomes less effective when screenshots are uncaptioned, several private chats compete as inboxes or Telegram is expected to replace the guest spreadsheet.

If relevant material also lives in articles, PDFs and other saved sources, dEssence can complement the workflow by searching saved material by meaning. Capture is available through the Chrome extension, Telegram bot and web app at dessence.ai. It should not become the only record of confirmed attendance, meals or seating.

Keep the system simple: Telegram preserves messy incoming asks; the spreadsheet holds the decisions planners and vendors will use.

Frequently asked questions

What should a wedding guest list tracker include?

One row per guest with name, household, side, group, RSVP, plus one, meal, dietary needs, table, requests, mailing address, contact and a thank you column.

How do I count RSVPs in Google Sheets?

Use =COUNTIF(E2:E300,"Yes") for guests attending, with the RSVP column in E. Swap "Yes" for "No" or "No reply" to count the rest, and use COUNTIFS to count meals among guests who said Yes.

Should the guest list be one row per household or per person?

Per person. Add a Household column to group rows for invitations, and every headcount, meal total and table count stays correct.

Should Telegram replace the guest spreadsheet?

No. It preserves conversations and attachments; the spreadsheet remains the current operational record.

Do I need to transcribe every voice note?

No. Add the guest's name, the need and your next action.

How often should I review the inbox?

At planning checkpoints, before the related decisions are locked.