Daily Health Tracker

About this download

A symptom and trigger tracker spreadsheet for people who log many symptoms. Rate each symptom once a day, check what happened (sleep, food, stress, weather, cycle, activity, treatments), and the workbook builds week, month and year views, compares days with and without each trigger, and prints a one-page summary to bring to your appointments.

IMPORTANT

Developed for Google Sheets. An Excel file is included for the latest Microsoft 365 (Office 365 Desktop App). Older Excel versions may not support all features.

Which one is for you? Track many symptoms and want to spot patterns: get the Symptom and Trigger Tracker. Only need a headache record for your doctor: get the Headache Diary.

⭐ 𝗗𝗘𝗠𝗢

On the fence? Watch our sample here:

https://youtu.be/aJxQY7YrJ70

Quick setup: open the Start Here PDF, make your own copy, pick your symptoms and triggers in Setup.

WHAT'S INSIDE (9 tabs)

1. Start Here: your two copy links, quick setup, color key and notes.
2. Setup: start date, severity scale (0 to 3 or 0 to 10), Simple or Full mode, theme, 60 symptom slots in 9 body-system groups (including My Own), 30 trigger slots in 6 groups (including an optional Cycle group) and up to 3 numbers of your own. Type each name once; every tab reads it.
3. Daily Log: one row per day for 366 days: a severity number for each symptom, a check box for each trigger, Flare day, mood and energy from 1 to 5, your numbers, 3 note check boxes (Saw doctor, Changed routine, Note for doctor) and a short note. Dropdowns and check boxes only; the date fills in.
4. Week View: pick any date and see that week as a grid with the severity number in every square.
5. Month Dashboard: days logged, flare days, average daily total, mood and energy, each symptom's days, average and highest, each trigger's days and a daily total chart.
6. Trigger Insights: average daily total on days with each trigger compared with days without it, the same day and the next day, Top 5 differences and a symptom by trigger grid. Patterns to discuss, not causes.
7. Year View: a 12-month calendar of daily totals with flare days marked, monthly averages and a chart.
8. Doctor Summary: pick From and To dates for a one-page summary with your top 10 symptoms, top 5 trigger patterns, averages, notes you marked for your doctor and your questions. Prints on US Letter or A4.
9. Lists (hidden): the dropdown lists behind the scenes.

Room for 60 symptoms in 9 body-system groups, 30 triggers in 6 groups, 3 numbers of your own and 366 days, one row per day.

Simple mode is the default: 10 starter symptoms and 6 starter triggers, with the other columns folded away until you want them. Full mode tracks every symptom and trigger that has a name.

Severity always shows its number, and there are 3 themes: Ocean and Indigo, Colorblind Safe and Print (black and white).

Daily entry works in the Google Sheets phone app. Dashboards and printing are easiest on a computer or tablet.

A personal record to share with your doctor. It shows patterns to discuss, not causes, and does not give medical advice or diagnose anything.

FILES INCLUDED (3 files)

START-HERE-Symptom-Trigger-Tracker.pdf: instructions and your two Google Sheets copy links (blank and sample).

Symptom-Trigger-Tracker-Sample.xlsx: the same workbook with a made-up 90-day log for a fictional person (Aug 3 to Oct 31, 2026, a few days skipped like a real log).

Please note: this is a digital download; no physical item ships.

One-time purchase for personal use.

Questions? Message me through the shop.

Not affiliated with Google or Microsoft.

𝗦𝗘𝗘 𝗔𝗟𝗦𝗢

• Family health records in one place: Medical Binder: https://www.etsy.com/listing/4537995359
• Caregivers tracking many medicines: Medication Tracker: https://www.etsy.com/listing/4519463534
• Daily health log too: Blood Pressure Log: https://www.etsy.com/listing/4605957965

Personal use only. Please do not resell, share or redistribute the files.

Designed by me, created using AI tools.

The Etsy listing is the final source for what is included. See it on Etsy.