Skip Navigation

Spreadsheet

Food & Symptom Journal — Elimination-Diet Tracker That Ranks Your Trigger Suspects & Makes a Doctor-Ready Summary (Excel + Google Sheets)

A food and symptom journal that ranks your watched foods by how often a symptom followed a meal containing them. Excel & Google Sheets.

Click to enlarge the image / Click × or press ESC to close

What you'll love

  • Most food diaries leave you two lists to compare in your head — this one does the comparing, checking every meal you log against every symptom you log
  • You set the reaction window — how many hours after eating a symptom still counts as "following" a meal — plus a minimum severity, and every flag, count, and rank reads from those two numbers
  • A Suspect Foods tab that ranks what you're watching — how many meals each food was in, how many were followed by a symptom, the resulting rate, and a plain-language verdict
  • An honest three-meal floor — a food needs at least three logged meals before the journal will say anything about it at all, so one unlucky dinner never becomes a "finding"
  • A Symptom Log that works backward too — log an episode and see how many meals fall inside the window before it, and what the closest one was
  • An Elimination Plan that works out your phase end dates, which phase today falls in, and the days left — plus a Reintroduction Log that checks your symptom log for the reaction itself
  • A live Dashboard with your overall share of meals followed — the baseline every food's rate has to beat — foods by reaction rate, and which symptoms come up most
  • A one-page Appointment Summary computed from your log — the period, the settings, the counts, and your top five suspects with their meal counts, plus room for your questions
  • A 10-tab workbook (Excel, Google Sheets & LibreOffice) + a Start Here guide, a Finding Your Patterns guide, and printable pages · evergreen · instant download · a file you own

You have been told to keep a food diary. So you keep one, and three weeks later you have two lists — what you ate, and how you felt — and no practical way to line them up. The pattern, if there is one, is buried somewhere in the handwriting.

This journal does the lining up for you. You set a reaction window — how many hours after eating a symptom still counts as “following” that meal — and a minimum severity. Then every meal you log is checked against every symptom you log, automatically. The Suspect Foods tab counts, for each food you’re watching, how many meals contained it and how many of those were followed by a symptom, turns that into a reaction rate, and ranks them.

That ranking is what you bring to an appointment. Not “I think dairy might be a problem,” but “dairy was in six of my meals and a symptom followed all six; wheat was in six and followed five; caffeine was in eight and followed three.” That is a conversation a doctor or dietitian can actually use.

What makes it more than a blank spreadsheet

The window does the matching. A meal at 7:45 and a symptom at 10:30 are two hours and forty-five minutes apart — inside a six-hour window, so the meal is marked “followed” and every watched food in it gets a tally. Change the window to twelve hours and every flag, rate, and rank in the file recalculates instantly.

It refuses to overclaim. A food needs at least three logged meals before the journal will band it at all — until then it reads “Not enough data yet” rather than turning one unlucky dinner into a verdict. The Dashboard shows your overall share of meals followed as a baseline, because a food whose rate merely matches your baseline is behaving like every other meal. And the band labels never say “trigger” — the top one reads Ask about this one first, because that is the honest claim.

It runs the whole protocol. The Elimination Plan takes your phase dates and works out the end dates, which phase today falls in, and how many days are left. The Reintroduction Log takes each food you add back and checks your symptom log for a qualifying reaction inside the window — reporting the worst severity it finds, so your verdict rests on what you recorded rather than what you remember.

What you get

A 10-tab workbook that opens in Excel, Google Sheets, and LibreOffice — with a one-click “Make a copy” link for a native Google Sheet, so there is nothing to import. It arrives pre-filled with a clearly fictional worked example so you can see every calculation running before you delete it and start your own.

Three PDF guides come with it: a Start Here guide on choosing your window and reading a pattern without fooling yourself, a Finding Your Patterns how-to covering what to record for digestive symptoms, reflux, migraine, skin reactions and fatigue, and a set of printable pages for logging by hand.

Want to try the idea first? The free Food & Symptom Log starter is a one-page printable — what you ate, how you felt, and how bad it was — with a worked example already filled in. No signup, no email. It records; this journal counts.

Own it, don’t rent it

What you build here is a detailed record of your own body over months. It lives in a file you own — not on a company’s server, not behind a subscription that can lapse, not in a service that can be sold or shut down. You decide where it is kept and who sees it. Keep logins out of it and it stays safe to hand to a doctor.

An important note

This is a record organizer, not medical or dietary advice — not a diagnosis, not a treatment plan, and not an allergy test. It counts correlations in your own records; it cannot tell you that a food is a trigger. Foods you eat constantly will appear before symptoms by chance, foods that travel together in the same meal cannot be separated by counting, and symptoms have many causes unrelated to food.

Elimination diets are normally run with a doctor or a registered dietitian, because removing food groups can create nutritional gaps and can make some tests — celiac testing in particular — unreliable. Use this to follow the plan you were given and to bring better records to the people helping you. Seek urgent care for any severe reaction, including trouble breathing or swelling of the face or throat.

See it in action

Play

Built to last

  • Intuitive and straightforward design
  • Employs software best practices
  • Delivered as one spreadsheet that works in Microsoft Excel, Google Sheets, and LibreOffice Calc
  • Free updates — send us a message to be notified of updates when they are available
  • Completely customizable — add rows and columns, rename headings, and adjust formulas

In the download

This digital product is delivered as a zip file containing the following items:

  • 00 — Start Here Guide (PDF): what a food diary can and can't prove, choosing your reaction window and severity cutoff, logging so the counting works, reading the suspect list without fooling yourself, and running an elimination and reintroduction
  • 01 — The Food & Symptom Journal (.xlsx, 10 tabs): Read Me, Start Here Checklist, My Settings, Food Log, Symptom Log, Suspect Foods, Elimination Plan, Reintroduction Log, Dashboard, Appointment Summary — pre-filled with a clearly fictional worked example; opens in Excel, Google Sheets, or LibreOffice
  • 02 — Finding Your Patterns Guide (PDF): what to record for digestive symptoms, reflux, headache and migraine, skin reactions, and fatigue; how reaction timing differs between them; and how to keep the record trustworthy
  • 03 — Printable Pages (PDF): a settings and watched-foods sheet, a food log grid, a symptom log grid, a reintroduction log, and an appointment-prep page with questions to ask
  • One-click Google Sheets copy — open the included link, choose Make a copy, and get a ready-made native version in your Drive (no import)
  • READ-ME-FIRST.txt — orientation, the license, and the not-medical-or-dietary-advice note

Compatibility & terms

Unless otherwise specified, this digital product is delivered as a spreadsheet (an .xlsx file) designed to work in Microsoft Excel, Google Sheets, and LibreOffice Calc . It is not guaranteed to work in any other application.

This digital product is copyrighted. It is intended for personal use only. It is strictly prohibited to reproduce, resell or share this product, in part or in full, with or without modifications. No refunds, exchanges, or cancellations. Given this is a digital product, no physical product will be delivered.

Why a workbook

Most tools force a choice between a blank spreadsheet you build from scratch and a monthly app that's overkill. Ardent Workshop is the rung in between — structure you own.

  1. Blank spreadsheet

    Free, but you build and maintain every formula, tab and layout yourself.

    • Free
    • Infinite setup
    • No structure
  2. You are here

    Ardent Workshop

    Owned, structured, connected workbooks — a one-time price, yours to keep.

    • One-time price
    • Structured & connected
    • Yours to own
  3. Generic SaaS app

    Powerful, but overkill, rented and locked-in — built for someone bigger than you.

    • Monthly rent
    • Overkill
    • Lock-in

Ready to start

Instant download · Free lifetime updates · Personal use license

$13.95 USD
Buy now

Pairs well with

From the Guides

Hand-picked reading on how to actually use a tool like this.