Dietary Restrictions Spreadsheet Template (Free Google Sheet)
Every event planner has lived this: the catering deadline is tomorrow and the dietary info is scattered across a 90-message Slack thread. This template gives dietary restrictions a permanent home — collected once, reused for every event.
What’s inside
- An allergy and preference matrix — names down the side, common restrictions across the top (gluten, dairy, nuts, vegetarian, vegan, halal, kosher, other)
- A free-text notes column for severity and cross-contamination flags
- A caterer-ready export tab that summarizes counts per restriction — exactly the format venues ask for
- A “last confirmed” date column so you know when info has gone stale
How to use it
- Click Get the template and make a copy.
- Add your team and send everyone the link once (or collect via a short form and paste in).
- Before each event, share the export tab with your caterer — counts, not names.
- Re-confirm entries older than 12 months; preferences change.
Tips
- Treat severity seriously: an allergy is not a preference. The notes column exists for “anaphylactic — separate prep required.”
- Share names internally only on a need-to-know basis; caterers usually just need counts.
Related templates
- Event RSVP Tracker
- Catering Comparison Sheet
- T-Shirt Size Collection Sheet
The real problem isn’t tracking dietary info — it’s asking for it again every single event. TeamRally’s Preference Vault stores it once and attaches it to every RSVP automatically — join the waitlist.