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:

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)

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

  1. One polite reminder — a short email or message a few days before the deadline, with the event date and what you still need.
  2. Call the people who matter most — close family, speakers, VIP clients, or anyone with a known allergy.
  3. 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.
  4. 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

  1. Filter to accepted guests only (plus confirmed plus-ones).
  2. Include name, meal choice, dietary note and allergen flags (and table number if seating is done).
  3. Add a one-line headcount: attending adults/children, day vs evening if relevant.
  4. Send by the written deadline; confirm receipt.
  5. 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

NeedExcel (.xlsx)Google Sheets
Working offline / weak venue Wi-FiStrongNeeds a connection (or offline mode set up first)
Sharing with a co-organiser or PAOneDrive / email copiesShare a link; both edit live
Drop-downs for RSVP / meal / dietData Validation → ListData → Data validation → Dropdown
Highlight awaiting-reply rowsConditional formattingConditional formatting
Form → sheet workflowPaste from CSV exportLink 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 ReedFamilyDayAcceptedChicken——
Sam ReedFamilyDayAcceptedVegetarianMilk (allergy)—
Jordan LeeWorkEveningAcceptedBuffetPeanuts (allergy)Step-free
Casey MorganFriendsDayAwaiting reply———
Riley ChenFriendsDayDeclined———

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)

  1. 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.
  2. Drop-downs: data-validate RSVP, Day/evening, Adult/child and Meal against short lists on a Lists sheet.
  3. 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.
  4. Caterer view: filter Accepted + (Diet not blank OR any allergen = Y), or a FILTER formula on a Caterer sheet.
  5. Conditional format Awaiting reply in amber so chases are obvious.
  6. 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

OptionBest whenWhat you get
DIY (free)You are happy with COUNTIF and drop-downs and have time before the RSVP deadlineBlank 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 eventGuests (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 checkAttendees (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 togetherSeven 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

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.