Skip to content
Medication Tracker cover: a sample sheet with doses logged, doses taken and doses missed and a bar chart, beside the Dashboard, Medicines and Dose log tabs

Medication Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

This medication tracker is for people who take regular tablets, drops or inhalers and want a simple record. The Medicines tab lists each item with how often it is taken, the doses left and the refill date, and flags any with seven doses or fewer. On the Dose log tab each dose is a row holding the date, time of day, medicine and a Taken box. The Dashboard shows doses taken and missed, the share taken and how many refills need ordering.

The sample rows use general names such as Morning tablet and Inhaler. Rename them to match your labels, and keep the same names on both tabs so the Dashboard counts them. Update the doses left each time you open a new pack. This tracker keeps a record only. It does not replace your prescription label or your pharmacist's advice, so ask them before changing how you take anything.

Useful for

  • Keeping track of morning and evening tablets
  • Ordering refills before a pack runs out
  • Sharing a dose record with a family caregiver

What's included

  • 4 tabs: Dashboard, Medicines, Dose log, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Medicines: a table
  • Dose 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 Medicines 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 do I add another medicine to the list?

Type its name on the next blank row of the Medicines tab, then fill in how often you take it, the doses left and the refill date. Add the same name to the Medicine dropdown on the Dose log tab through Data validation, so you can log doses for it.

What does the reorder flag mean?

The Reorder soon flag appears when the doses left are seven or fewer. It is a prompt to ask your pharmacy for a refill, not a guarantee of stock. Refill rules and timing depend on your prescription, so check with your pharmacy.

What if I forget to tick a dose?

Leave the Taken box unticked so the missed count is right, and add a note. Do not take a double dose to catch up unless your prescriber says otherwise. Ask your pharmacist what to do after a missed dose.

  • #fitness-tracker
  • #medication-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…