Skip to content
Symptom Tracker cover: a sample sheet with entries logged, average severity and highest severity and a bar chart, beside the Dashboard and Symptom log tabs

Symptom Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Style
Modern
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

This symptom tracker helps you spot patterns between symptoms, sleep, food and activity, and bring a clear record to a doctor. The Symptom log tab keeps one line per entry, with the date, time, the symptom from a list, a severity from 1 to 10, possible triggers, what helped and a Raise at visit box. The Dashboard counts entries, shows the average and highest severity and charts the average severity for each symptom.

The sample entries cover about four weeks, so the counts and averages are filled in. Use the same symptom name each time so entries group together, and decide on your own severity scale, such as 1 for barely noticeable and 10 for the worst you have felt. Rows with a severity of 8 or more are highlighted red. Note the trigger you suspect, but treat it as a guess until a doctor has looked at the pattern.

Useful for

  • Preparing notes for a doctor's visit
  • Looking for triggers behind headaches or poor sleep
  • Comparing how severe a symptom was over time

What's included

  • 3 tabs: Dashboard, Symptom log, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Symptom log: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Symptom log tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How should I rate severity?

Choose a scale you can apply consistently. A common approach is 1 for barely noticeable, 5 for getting in the way and 10 for the worst you have felt. Write the scale in a note on the sheet so you and your doctor read it the same way.

What should I do about a serious symptom?

Do not rely on this tracker for urgent problems. Contact your doctor about symptoms that are new, severe or getting worse. In an emergency, call your local emergency number straight away.

Does a trigger I note mean it caused the symptom?

Not necessarily. The trigger column records what you noticed at the time, such as a skipped lunch or a long screen day. Repeated entries can suggest a pattern, but only a clinician can judge the cause.

  • #fitness-tracker
  • #symptom-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More fitness tracker templates

See all 16

Also in Business operations

All business operations templates
Get this template

Preparing your template…