Medication Tracker Spreadsheet Google Sheets Excel, Medication Log and Refill Tracker, Printable Medication List for Caregivers

MEDICATION TRACKER FOR GOOGLE SHEETS AND EXCEL

A medication tracker for anyone who takes or gives several medicines. List each medicine and when it's taken, and it shows who gave each dose, when each one runs out, when to order, and a dated list for the doctor.
Room for 40 medicines (current and past) and two years of daily log.

📊 WHAT IT DOES

✓ Meds: every medicine with pills per dose and a ✓ under Morning, Midday, Evening or Bedtime. Weekly doses and as-needed medicines too.
✓ Meds: what it's for, who prescribed it, when it started, and when and why it stopped. A dose change is a new line.
✓ Refills: type how many you picked up and when. Left now, Runs out and Order by fill in, moved back to your pharmacy day.
✓ Refills: notes say what to do: Order now, Runs out before earliest refill, No refills left, Rx expires, Prior auth ends, or a pill count that doesn't match.
✓ Log: one line a day. Initials of who gave it in each time slot, x for skipped, r for refused.
✓ Log: as-needed medicines by time: how many times today and the last time. The next time shows only if you typed a rule from the label.
✓ Med list: one page for the doctor and the ER, with allergies, contacts, current medicines, the pill box by time of day, and medicines stopped in the last 12 months.
✓ Med list: dated with the last change, so you always know how old the list is.

📂 WHAT'S INSIDE: 5 TABS AND 1 CHART

✓ Start here: please read, the person, times of day, order days ahead, pharmacy day and the Log start date
✓ Meds: every medicine, five cards and the status column
✓ Refills: four cards, run-out and order dates, coming orders and days of supply
✓ Log: four cards and one line a day
✓ Med list: the printable page for the doctor

📝 HOW IT WORKS

1. Open the PDF and click the link to make your own copy in Google Sheets. Or open the Excel file.
2. On Meds, add each medicine: name, pills per dose and ✓ under each time of day.
3. On Refills, type how many you picked up and when. Set the Log start date on Start here.
4. Each day, type initials in the time slot on Log. Print Med list after any change.

📥 WHAT YOU GET

✓ Google Sheets version (the link is in the PDF)
✓ Excel version (.xlsx) for desktop Excel 2016 or newer and Microsoft 365, on Windows or Mac
✓ A filled example to look around, and a blank copy for your own
✓ A PDF guide with screenshots, the links and the first steps
✓ A video guide for this planner (the link is in the PDF)

💻 GOOD TO KNOW

✓ Works with a free Google account. No app, no ads, no subscription.
✓ It does not send reminders. Keep your phone alarm or a pill box with a timer.
✓ Supply and order dates are estimates from the numbers you type.
✓ One person per file. Make a copy for another person.
✓ Type only in the lighter input cells. Formulas are protected: Google Sheets warns you before you change one.
✓ Best on a computer for setup. The Google Sheets app works for a quick check on your phone.
✓ The Excel version may look slightly different from the photos (fonts, colors, charts). The photos show Google Sheets. Links between tabs work in Google Sheets.
✓ English only. Not made for Apple Numbers.
✓ Free updates for life.

This is a digital download. Nothing will be shipped. Because it is a digital file, it can't be returned, but if anything is unclear, message me and I will help you set it up.
This tracker is a log and a list, not medical advice. It does not tell you what, when or how much to take. Follow your prescriber, pharmacist and the label.