Skip to main content

How to set up a medication tracking spreadsheet

How do I set up a medication tracking spreadsheet?

A medication tracking spreadsheet works best with one row per medicine and one column for each detail you would otherwise try to remember: brand and generic name, strength, how much, how and when you take it, why, who prescribed it, start and stop dates, and what it looks like. Those columns come from FDA's My Medicine Record and AHRQ's My Medicines List. Prescriptions, over-the-counter medicines and supplements all get a row. Your name, allergies, emergency contact and a last-updated date go at the top.

Columns for a medication tracking spreadsheet
ColumnWhat goes in itSource
Medicine nameBrand and generic name for prescriptions, samples included; name and active ingredients for over-the-counter productsFDA, AHRQ
StrengthThe strength printed on the label, such as 20 mgAHRQ
How muchThe dose you actually take, such as "40 mg; use two 20 mg pills"FDA
How and whenDirections such as "take by mouth with food" and the time of day, such as "at bedtime"FDA
Morning, noon, evening, bedtimeThe amount at each time of day, so one column shows what is due at that hourAHRQ
What it looks likeForm, shape, color, size and markingsFDA
Why I take it and notesThe reason, special directions, any tests it needs and their dates, storage if not room temperatureFDA
Who prescribed itName and contact for the doctor, nurse or pharmacist who told you to use itFDA
Start and stop datesWhen it started, when it should stop if it is for a set time, or "when needed"FDA

This is not clinical evidence and not medical advice. It does not replace your care team. Discuss anything here with your clinician before you act on it. Product questions are on the FAQ.

Made by Triangle.

When bottles come from three prescribers and two pharmacies, a medication tracking spreadsheet keeps the whole list in one place. Below are the columns and tabs to set up, built from FDA and AHRQ templates, plus when to update it, how to share it, and how to use it at the next appointment.

Should daily, weekly and as-needed medicines go on separate tabs?

AHRQ's My Medicines List splits them into three charts: medicines you take every day, medicines you take regularly but not every day, and medicines you take only when needed. The middle chart has a When column for the days and times, such as Monday, Wednesday and Saturday mornings. In a spreadsheet, those three charts become three tabs. FDA's form adds a separate page for the details that are not one medicine: your contacts (an emergency contact, your primary care physician, your pharmacy), allergic reactions or other problems with any medicine, supplement, food, skin cleaner or medical tape, and your medical conditions and operations. That works as a fourth tab.

When should I update the spreadsheet?

The spreadsheet needs attention on three kinds of days, per the FDA form's instructions: a medicine or supplement starts or stops, anything you use changes, or you see a doctor, pharmacist or other health professional. AHRQ adds two habits: change the date at the top every time you edit, and print the new version and throw out the old one so you have the most up-to-date copy whenever you need it. Refills are worth a glance too. HHS suggests paying attention to the color and shape of your pills, and asking your pharmacist to double-check if they look different after a refill. A What it looks like column makes that check quick. When a medicine stops, you can fill in its stop date instead of deleting the row, so the history stays visible.

Is a spreadsheet better than a paper list or an app?

FDA's view is that the best medication list is the one that is easy for you to create, keep up and remember to share, whether that is a paper list, an app, a downloadable form, or a template from your provider. AHRQ notes that saving the list on a computer lets you make changes without entering the same information again. FDA's own form is built to be typed on a computer or printed and filled in by pencil. A file saved on one computer stays there, so FDA's advice on carrying a copy, in the next answer, still applies.

How do I share the spreadsheet with doctors and caregivers?

FDA's form says to print and share the record with your doctors, pharmacists and other health professionals at all your visits, keep a printed copy with you, and give a copy to a friend or loved one. FDA's consumer guidance adds a phone picture, an app, or a paper copy kept with your insurance card, and sharing with anyone who may come to appointments with you or speak for you in an emergency. The dentist and the physical therapist belong on the share list too, according to the National Institute on Aging. So does every pharmacy counter: with prescriptions filled in two places, NIA says to hand your list to the pharmacist at each location when you drop one off. MedlinePlus notes that when medicines come from more than one provider, one provider may not know what another has given you.

How do I use the spreadsheet at an appointment?

MedlinePlus suggests discussing the list with your provider at each appointment, asking whether you still need every medicine on it and whether any dose should change, and giving every provider a copy. It also says to bring the list if you have a hospital stay. You can add a Questions column for this. WHO's 5 Moments for Medication Safety gives good prompts for it, including whether you are taking any medications you no longer need, how long you should take each one, and how often your medications should be reviewed. For a new prescription, WHO's starting questions cover what the medication is for and how to store it, which map straight onto the Why and Notes columns. For what belongs on the list itself, the guide on keeping a medication list across doctors goes field by field.

How does Triangle track medications?

A spreadsheet only knows what you type into it. Triangle keeps track of every medicine and every change: what you take now and what you have stopped, with doses, history and your own notes. Records can come in by upload or scan, by importing them from Epic MyChart, or by asking Triangle to request them for you, and your medicines sit beside your lab trends and wearable readings over time, each linked to its source. You can invite family or a caregiver as a viewer or a manager and remove anyone at any time. Triangle also turns your file into questions for your next appointment, such as whether any of your medicines should change. It does not diagnose, treat or prescribe; your care team makes the decisions.

See how Triangle tracks every medicine and every change →

Sources

For you, or someone you love

Ask this about your own records.

Triangle brings your medical records, genetic results and wearables into one place that you control, with your records organised by condition. Ask about your own file in plain language, and walk into every appointment knowing what to ask.

Start your 7-day free trial

Then $9 a month. Cancel anytime.

  • Every record in one place

    Requested from your hospitals and clinics through the national networks, next to your genetic results and wearables. Add scans and anything on paper.

  • Read in plain words

    Reports explained as they come in, organised by condition, with lab values you can follow over time.

  • Ready for every appointment

    Ask about your own file, and walk in knowing what to ask your doctors.

  • Your people, in the loop

    Share one profile with the family helping you, and with your doctors.