RSVP tracker spreadsheet UK: guest list, dietary requirements and 14 allergens
An RSVP tracker spreadsheet (or guest list RSVP tracker / event RSVP Excel or Google Sheets file) is the working list where you record replies, plus-ones, meal choices, dietary requirements and the 14 major allergens UK caterers ask about — then hand them a clean summary. This UK guide works for any event: weddings, parties, corporate and Christmas parties, christenings and birthdays. It covers the columns to use, how to collect RSVPs and chase late replies, how to brief the caterer, Excel vs Sheets, a free DIY method, and how a ready tracker compares with a corporate party planner or a wedding bundle. Sample rows below are made-up. This is a planning guide, not legal, tax or food-safety advice. Wedding-only ranking and seating sync live in our wedding guest list template UK guide; this page is the event-agnostic RSVP and allergen sheet.
What columns a good RSVP tracker needs
One row per guest (or per household if you prefer, with names listed together). Useful columns for any UK event:
- Full name — as it should appear on the invite, badge or place card.
- Group / household — team, table group, family side, or who shares an invite.
- Contact — email and/or phone for digital RSVPs and chasing.
- Invite sent — yes/no and date, so you know who still needs a chase.
- RSVP response — invited, accepted, declined, awaiting reply (drop-down).
- Plus-ones — allowed? named? count them in the headcount only once confirmed.
- Day / evening — or full event vs partial (useful for weddings and long corporate days).
- Adult / child — for meal portions and pricing.
- Meal choice — once menus go out (for example main A / main B / child / buffet).
- Dietary requirements — vegetarian, vegan, halal, kosher, preference notes the kitchen needs.
- Allergens — columns or flags for the 14 major allergens (see below).
- Access needs — step-free, seating near the exit, quiet space, BSL, and similar — share only with people who need to know.
- Notes — travel home, do-not-seat-with, gift received, thank-you sent.
You can start with name, RSVP and contact, then add meal and allergen columns once the menu is set. Keep one master list that invitations, catering and seating all draw from.
How to collect RSVPs (form vs text vs card)
- Paper reply card — still common for weddings and formal dinners. Number each card or print a short code so replies match the spreadsheet row.
- Email or calendar invite — fine for office parties and client events; ask people to reply with meal choice and any dietary or allergen notes in the same message.
- Online form — Google Form, Microsoft Form or similar, with required fields for response, plus-one and allergens. Export to CSV and paste into your tracker (or link a Form to Sheets).
- Text / WhatsApp — works for small parties; copy every reply into the sheet the same day so nothing lives only in a chat thread.
Set one RSVP deadline in the invite (usually at least a week before the caterer's final-numbers date). State clearly what you need back: yes/no, plus-one name, meal choice, dietary needs and allergies.
How to chase late replies
- One polite reminder — a short email or message a few days before the deadline, with the event date and what you still need.
- Call the people who matter most — close family, speakers, VIP clients, or anyone with a known allergy.
- Decide a rule for silence — treat no-reply as declined for catering numbers, or hold a small buffer of meals if the venue allows. Write the rule down so you do not re-debate it the week before.
- Freeze the list — after the caterer's deadline, only change the sheet for drop-outs or newly reported allergies, and tell the caterer the same day.
Do not leave final numbers in a mix of inbox, paper cards and chat — the tracker is the source of truth.
Dietary requirements and the 14 major allergens
UK food businesses must be able to tell customers about the 14 major allergens in what they serve. Official guidance is on the Food Standards Agency allergen page for food businesses. Your job as the organiser is to collect clear information and pass it on accurately — not to assess medical risk. That is not legal or clinical advice.
The 14 major allergens named in the ready tracker (and commonly requested by UK caterers) are: celery, cereals containing gluten, crustaceans, eggs, fish, lupin, milk, molluscs, mustard, tree nuts, peanuts, sesame, soya and sulphites. In the Guest List, RSVP & Allergen Tracker (£4.50), you mark each with a Y and it is flagged in red; the Summary totals allergen counts and the Caterer List lists only attending guests who have dietary needs or allergies.
Separate preference (for example "no coriander") from allergy in the notes if you can, so the kitchen sees the difference. Keep medical detail off public seating boards and party WhatsApp groups.
How to hand the caterer a dietary and allergen summary
- Filter to accepted guests only (plus confirmed plus-ones).
- Include name, meal choice, dietary note and allergen flags (and table number if seating is done).
- Add a one-line headcount: attending adults/children, day vs evening if relevant.
- Send by the written deadline; confirm receipt.
- After freeze, message any drop-out or new allergy the same day.
For weddings, seating comes next — see how to write a wedding seating plan and the seating plan spreadsheet UK guide (Seating Plan & Table Planner (£4.95)). For office Christmas parties, put RSVPs on the same timeline as the Christmas party checklist UK and office Christmas party planning guides.
Excel vs Google Sheets
| Need | Excel (.xlsx) | Google Sheets |
|---|---|---|
| Working offline / weak venue Wi-Fi | Strong | Needs a connection (or offline mode set up first) |
| Sharing with a co-organiser or PA | OneDrive / email copies | Share a link; both edit live |
| Drop-downs for RSVP / meal / diet | Data Validation → List | Data → Data validation → Dropdown |
| Highlight awaiting-reply rows | Conditional formatting | Conditional formatting |
| Form → sheet workflow | Paste from CSV export | Link a Google Form directly |
A common UK workflow is to build in Excel, then upload the .xlsx to Google Drive so phones can edit. The Guest List, RSVP & Allergen Tracker (£4.50) ships as .xlsx for that reason: open in Excel 2016 or later / Microsoft 365, or File → Save as Google Sheets after upload.
Example rows (made-up)
The names and details below are made-up for an imaginary 40-guest mixed event (wedding breakfast day guests plus an evening party). They are illustrative only — not a real guest list.
| Name (example) | Group (example) | Invite (example) | RSVP (example) | Meal (example) | Diet / allergen (example) | Access (example) |
|---|---|---|---|---|---|---|
| Alex Reed | Family | Day | Accepted | Chicken | — | — |
| Sam Reed | Family | Day | Accepted | Vegetarian | Milk (allergy) | — |
| Jordan Lee | Work | Evening | Accepted | Buffet | Peanuts (allergy) | Step-free |
| Casey Morgan | Friends | Day | Awaiting reply | — | — | — |
| Riley Chen | Friends | Day | Declined | — | — | — |
In a live sheet, Casey would stay on the chase list until the deadline; Sam and Jordan would appear on the caterer summary once accepted.
How to make an RSVP tracker yourself (free DIY)
- Sheet — Guests: columns Name, Group, Email, Invite sent (date), RSVP (Invited / Accepted / Declined / Awaiting), Plus-one, Day/evening, Adult/child, Meal, Diet, then one column per allergen (or a single Allergens text field), Access needs, Notes.
- Drop-downs: data-validate RSVP, Day/evening, Adult/child and Meal against short lists on a Lists sheet.
- Summary: COUNTIF for invited / accepted / declined / awaiting; COUNTIF for day vs evening and adult vs child; COUNTIF or SUM for each meal and each allergen column.
- Caterer view: filter Accepted + (Diet not blank OR any allergen = Y), or a FILTER formula on a Caterer sheet.
- Conditional format Awaiting reply in amber so chases are obvious.
- Privacy: share only with people who need the file; do not post allergy details publicly.
Prefer not to build the Summary and Caterer List formulas yourself? The Guest List, RSVP & Allergen Tracker (£4.50) already includes drop-downs, 14 allergen flags in red, Summary totals and an auto Caterer List for up to 200 guests.
DIY vs ready tracker vs corporate planner vs wedding bundle
| Option | Best when | What you get |
|---|---|---|
| DIY (free) | You are happy with COUNTIF and drop-downs and have time before the RSVP deadline | Blank Excel or Google Sheet using the steps above |
| Guest List, RSVP & Allergen Tracker (£4.50) (£4.50) | You want guest list + RSVP + 14 allergens + Summary + Caterer List ready-made for any event | Guests (200), allergen flags, Summary, Caterer List, editable lists, Start Here |
| Corporate Event & Christmas Party Planner (£8.95) (£8.95) | You are running a staff Christmas party or company event and also need budget, timeline and an HMRC £150 check | Attendees (RSVP, +1, diets, allergies, access, table; 250), VAT-aware budget, timeline, HMRC guide check, Overview |
| UK Wedding Planner Bundle (7 templates) (£21.95) (£21.95) | You are planning a UK wedding and want the guest/allergen tracker plus budget, venue scorecard, run sheet, supplier tracker, checklist and seating plan together | Seven templates including the Guest List, RSVP & Allergen Tracker |
Office Christmas party with budget and tax check in one file? Use the Corporate Event & Christmas Party Planner (£8.95) and the office party / checklist guides. Wedding seating after RSVPs? Add the Seating Plan & Table Planner (£4.95) or the full UK Wedding Planner Bundle (7 templates) (£21.95).
What is (and is not) in the Guest List, RSVP & Allergen Tracker
- Included in the Guest List, RSVP & Allergen Tracker (£4.50): Guests sheet with drop-downs for group, day/evening, invite sent, RSVP, adult/child, meal choice and diet (room for 200 guests); all 14 major allergens (celery, gluten, crustaceans, eggs, fish, lupin, milk, molluscs, mustard, tree nuts, peanuts, sesame, soya, sulphites) marked with a Y and flagged in red; Summary (invited, attending, awaiting reply, day/evening, adults/children, meal counts, diets and allergen totals); Caterer List that fills automatically with only attending guests who have dietary needs or allergies; editable lists for groups, meals and diets; Start Here guide. Excel .xlsx / Google Sheets upload. UK edition (£ GBP, DD/MM/YYYY). Digital download for personal use or use within your own organisation. Designed with AI tools from an original brief and tested before listing.
- Not included: nothing physical is posted. It is a planning tool, not legal, tax or financial advice. Please do not resell or share the file. As a digital file, returns cannot be accepted; if something does not work as described, message the seller. It does not include a full corporate budget/timeline/HMRC check (that is the Corporate Event & Christmas Party Planner (£8.95)), and it does not include seating chart or table planner files on their own (use the Seating Plan & Table Planner (£4.95) or the UK Wedding Planner Bundle (7 templates) (£21.95) for wedding seating and the wider wedding set).
More: wedding guest list template UK · seating plan spreadsheet UK · how to write a wedding seating plan · Christmas party checklist UK · office Christmas party planning · kids birthday party checklist UK · gala and corporate seating plan UK · table seating calculator · catering quantity calculator
Free tools for this
Frequently asked questions
What is an RSVP tracker spreadsheet?
A working Excel or Google Sheets file where you list every guest, record invite sent and reply status, plus-ones, day or evening, meal choices, dietary requirements and allergens, then summarise headcounts for the caterer. It works for weddings, parties, corporate events, christenings and birthdays.
What columns should an RSVP tracker include?
Name, group or household, contact, invite sent, RSVP status, plus-ones, day/evening, adult/child, meal choice, dietary requirements, the 14 major allergen flags, access needs and notes. Add table number later if you are seating people.
How do I collect RSVPs and chase late replies?
Use reply cards, email, an online form or text — but copy every reply into one spreadsheet. Set a deadline before the caterer's final-numbers date, send one polite reminder, call the people who matter most, then treat silence with a clear rule (usually decline for catering) and freeze the list.
What are the 14 major allergens UK caterers ask about?
Celery, cereals containing gluten, crustaceans, eggs, fish, lupin, milk, molluscs, mustard, tree nuts, peanuts, sesame, soya and sulphites. Collect clear answers and pass them to the venue; see the Food Standards Agency allergen guidance for food businesses. This is not legal or medical advice.
How do I give the caterer a dietary and allergen summary?
Filter to accepted guests, include meal choice, diet notes and allergen flags (and table if known), add adult/child and day/evening headcounts, send by the written deadline and only change afterwards for drop-outs or new allergies — telling the caterer the same day.
Should I use Excel or Google Sheets for an RSVP tracker?
Either works. Excel is strong offline; Google Sheets is handy for shared editing and linking a Form. A common approach is an .xlsx template uploaded to Drive and saved as Google Sheets. Our Guest List, RSVP & Allergen Tracker ships as .xlsx for both.
DIY RSVP spreadsheet, ready tracker, corporate planner or wedding bundle?
DIY if you want to build COUNTIF yourself. The Guest List, RSVP & Allergen Tracker (£4.50) if you want allergens, Summary and Caterer List ready-made for any event. The Corporate Event & Christmas Party Planner (£8.95) if you also need budget, timeline and an HMRC £150 check. The UK Wedding Planner Bundle (£21.95) if you want the tracker plus six other wedding templates.
What is included in the Guest List, RSVP & Allergen Tracker?
Guests sheet (drop-downs, 200 guests), 14 allergen flags in red, Summary totals, auto Caterer List, editable group/meal/diet lists and a Start Here guide. Excel .xlsx for Google Sheets upload. UK edition in £ with DD/MM/YYYY dates. Digital download; not legal advice; nothing is posted.
Written with AI assistance and checked against GOV.UK guidance. General information, not financial, tax or legal advice.