Skip Navigation

Spreadsheet

Medication & Appointment Tracker — Medication List, Dose Schedule, Refill & Appointment Organizer (Excel + Google Sheets)

A medication and appointment tracker to organize medications, doses, refills, and upcoming appointments in one file you own (Excel + Google Sheets).

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

What you'll love

  • A Medications tab — every dose, when it's taken, what it's for, and the prescriber, with a dropdown for the schedule (a record you keep, not medical advice)
  • A Dose Schedule that maps the whole day — morning, midday, evening, bedtime, and as-needed — so a fill-in helper can keep the routine straight
  • Refill tracking with a color-coded status you set — last filled, days' supply, and the refill-by date, so a prescription doesn't run out on a weekend
  • An Appointments tab — what's coming up, the questions to ask before, and what each visit decided, with a color-coded status
  • An At-a-Glance page a paramedic or fill-in helper can act on — conditions, allergies, the primary doctor, the pharmacy, who to call, and where the medication list is
  • Providers & Pharmacies — every doctor, specialist, and pharmacy with direct numbers, so a question or a refill doesn't start with a search
  • One safety rule throughout — it records the care and WHERE documents live, never pharmacy- or patient-portal logins or full insurance member numbers, so it's safe to share
  • An 8-tab workbook (works in Excel, Google Sheets, and LibreOffice) + a Start Here guide, an Organizing guide, and printable pages · evergreen · instant download · a file you own

Keep medications and appointments straight, in one place you own

Medications and appointments are the part of someone’s care that changes most often and scatters the fastest — a pill list on the fridge, an inhaler in a coat pocket, an appointment card in a purse, a refill due that nobody’s watching. The Medication & Appointment Tracker pulls all of it into one calm, findable place: what’s taken, when, what’s running low, and what’s coming up. Whether you’re keeping track for a parent, a partner, or yourself, it gets that knowledge out of a few heads and a few drawers and onto the page.

Every medication, in one place

The Medications tab holds every current medication — name, dose, when it’s taken, what it’s for, and the prescriber — with a dropdown for the schedule. Bring a photo of it to every appointment and to the ER; it’s often the first thing clinicians ask for. The Dose Schedule then maps the same medications across the day — morning, midday, evening, bedtime, and as-needed — so a fill-in helper can keep the routine straight without re-reading the whole list. It’s a record you keep, not medical advice.

Stay ahead of every refill

Running out on a weekend is the avoidable emergency. The Refills tab is a little arithmetic that helps prevent it: last-filled date plus days’ supply tells you roughly when to reorder — you note the refill-by date a week ahead — and a color-coded status you set (Auto-refill, OK, Refill soon, Overdue) tells you at a glance what needs attention. The status word is always shown, so it reads clearly with or without color.

Appointments, with the questions to ask

The Appointments tab keeps what’s coming up, the reason, how they’ll get there, the questions to ask before the visit, and what each past visit decided — with a color-coded status. The At-a-Glance page is the summary a paramedic or a fill-in helper needs in the first five minutes: conditions, allergies, the primary doctor, the pharmacy, who to call, and where the full medication list and the advance directive are kept. And Providers & Pharmacies keeps every doctor, specialist, and pharmacy with direct numbers, so a question or a refill doesn’t start with a search.

One rule that keeps it safe to share

A medication tracker gets shared by its nature — a family member, a neighbor, a fill-in helper may all open it. So it’s built on a single rule that runs through every tab: it records the care and where documents live — never pharmacy- or patient-portal logins, PINs, or full insurance member numbers. (The Rx number printed on the bottle is fine — it only refills a prescription.) Real logins belong in a password manager the family shares. The tracker is a record of care, not a set of keys.

Own it, don’t rent it

For something this personal, the file should be yours. Unlike a subscription medication app, it doesn’t live on a company’s server, can’t be locked behind a lapsed payment, and won’t vanish if the service shuts down. You decide where it’s stored and which family members can see it. It’s the middle ground between a blank spreadsheet and a rented app: real structure, on a file you keep.

It opens in Excel, Google Sheets, and LibreOffice (the Google Sheets version is a one-click “Make a copy,” no import), and prints to paper if you’d rather fill it in by hand. A finishable Start Here Checklist counts what’s done, so the whole thing feels finite, not endless. Pair it with the Caregiver / Aging-Parent Care Binder for the whole-care picture.

Try the free version first

Not ready for the full tracker? The free Med List starter is a one-page printable — current medications and doses — for the fridge or a bag. It’s a real taste of what the full tracker organizes.

An honest note

This is a record-organizing workbook for keeping medications and appointments straight. It is not medical advice, a diagnosis, a treatment plan, or a prescription, and it does not set or change any dose — read every dose off the bottle and always defer to the prescribing doctor and pharmacist. Where it mentions an advance directive, it only records where the signed document is kept. The workbook ships pre-filled with a clearly fictional example you overwrite with your own. Not affiliated with or endorsed by any pharmacy, insurer, or hospital.

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): why a medication tracker, the one rule that keeps it safe to share, and how to fill it without overwhelm
  • 01 — The Medication & Appointment Tracker (.xlsx, 8 tabs): Read Me, Start Here Checklist, At-a-Glance, Medications, Dose Schedule, Refills, Appointments, Providers & Pharmacies — pre-filled with a clearly fictional example; opens in Excel, Google Sheets, or LibreOffice
  • 02 — Organizing Medications & Appointments Guide (PDF): the brown-bag method for an accurate medication list, mapping the day, refill math, and walking into a visit ready
  • 03 — Printable Pages (PDF): an at-a-glance front sheet, a medications page, a dose schedule, a refill tracker, and an appointment log 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-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

$18.95 USD
Buy now

Pairs well with

From the Guides

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