Symptom Tracker Excel & Google Sheets, Chronic Illness Pain Journal, Daily Symptom Frequency Template, Medication and Trigger Log

Symptom Tracker Spreadsheet | Correlation Analyzer | Google Sheets & Excel 365

Take control of your health data with this fully automated Symptom Tracker Spreadsheet, designed to help you identify patterns, triggers, and correlations between your symptoms, triggers, and medications over time. Whether you are managing chronic illness, migraines, anxiety, hormonal symptoms, or medication side effects, this tracker gives you clear, visual insights based on your daily data.

This spreadsheet works on a 0–10 rating scale, is fully customizable, and includes an advanced Symptom Analyzer Dashboard that automatically calculates correlations for any selected symptom, trigger, or medication.

Available in Google Sheets and Excel 365.

How It Works:
Step 1: Enter your start date and set up your personal list of:
🔸 Symptoms
🔸Triggers
🔸Medications

You can add extra columns at any time. The dashboards automatically adjust.

Step 2
Log your data daily: Rate symptoms and triggers from 0 to 10
Enter medication quantity taken that day,

Step 3
The spreadsheet automatically color-codes your entries, making fluctuations and trends easy to spot at a glance.

Step 4
Compare any symptom with any trigger or medication
Select any custom date range
Instantly view correlation scores, averages, and visual charts

Key Features:
✔️ 0–10 Scale Symptom Tracking
Log symptom intensity, trigger exposure, and medication usage in a consistent and easy-to-use format.
✔️ Automatic Color Coding
Visual heatmap-style coloring helps you quickly identify high and low intensity days.
✔️ Correlation Analyzer Dashboard

Analyze relationships between:
Symptoms vs Triggers
Symptoms vs Medications
Triggers vs Medications


Correlation scores update automatically based on your selected data.
✔️ Custom Date Range Analysis
Analyze daily fluctuations for any period, short term or long term.
✔️ Fully Customizable Columns
Add or remove symptoms, triggers, or medications at any time. No setup limitations.
✔️ Checkbox-Based Charts
Simply check a box to add or remove symptoms, triggers, or medications from the charts.
✔️ Unlimited Time Use
Designed for long-term tracking with no preset limits.

Who This Is For:
Chronic illness management
Migraine and headache tracking
Anxiety, stress, and mental health tracking
Hormonal cycle symptom tracking
Medication and side effect monitoring
Anyone wanting data-driven health insights

Compatibility
✔️ Google Sheets
✔️ Excel 365 only
Not compatible with older Excel versions.

Important Notes
This is a digital download, no physical product will be shipped
For personal use only!
This spreadsheet is not a medical device and does not provide medical advice


Why You Will Love It
Instead of guessing what affects your symptoms, this spreadsheet helps you see the patterns clearly. With automated analysis, clean visuals, and complete flexibility, you can make informed decisions and have better, data-backed conversations with healthcare professionals.

This product is copyrighted by RainbowSheets Studio. Redistributing or reselling this spreadsheet with or without modification is strictly prohibited.