Multi-Allergy Family Meal Planner

One child is nut-free. Another is dairy-free. You need dinner on the table in 30 minutes. This spreadsheet solves that.

Multi-Allergy Family Meal Planner

Managing one food allergy is hard. Managing four or five across different family members turns meal planning into a daily puzzle with stakes. This spreadsheet is built for families where one kid is nut-free, one is gluten-free, one can't touch dairy, and dinner still has to land at 6pm.



What's inside (13 tabs)

Per-person allergy profiles for up to six family members. List every allergen, severity rating (mild, moderate, anaphylactic), and auto-injector details.

Meal planner with automatic conflict detection. Plan a meal, the sheet flags which family members can't eat it and why.

Shared ingredient database with allergen tags. Once you mark "peanuts = John anaphylactic," every recipe containing peanuts is flagged forever.

Cross-contamination tracker for shared kitchens. Which utensils, boards, and surfaces are safe and which aren't.

Shopping list generator that only shows ingredients safe for the whole family.

Emergency protocols tab with auto-injector locations, emergency contacts, and hospital info.

Meal rotation to prevent the "same safe dinner on repeat" fatigue.

Substitution library. When a recipe calls for dairy, the sheet suggests safe alternatives (oat milk, coconut yoghurt) tested against the family's profile.

Editions

US edition (EpiPen references, FDA guidance) and UK edition (Jext/Emerade auto-injectors, 999 emergency numbers, FSA guidance, UK brands). Both included.

Three file variants: Standard, Example (pre-filled with a sample four-person family), and Creator Edition (unlocked formulas).

Works in Google Sheets and Excel. One-time purchase.

Questions? Email hello@boredtools.store