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.
| Column | What goes in it | Source |
|---|---|---|
| Medicine name | Brand and generic name for prescriptions, samples included; name and active ingredients for over-the-counter products | FDA, AHRQ |
| Strength | The strength printed on the label, such as 20 mg | AHRQ |
| How much | The dose you actually take, such as "40 mg; use two 20 mg pills" | FDA |
| How and when | Directions such as "take by mouth with food" and the time of day, such as "at bedtime" | FDA |
| Morning, noon, evening, bedtime | The amount at each time of day, so one column shows what is due at that hour | AHRQ |
| What it looks like | Form, shape, color, size and markings | FDA |
| Why I take it and notes | The reason, special directions, any tests it needs and their dates, storage if not room temperature | FDA |
| Who prescribed it | Name and contact for the doctor, nurse or pharmacist who told you to use it | FDA |
| Start and stop dates | When 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
- FDA: My Medicine Record (Form FDA 3664), with How to Use My Medicine Record instructionsMy Medicine Record columns: brand and generic name for prescriptions, name and active ingredients for OTC products; what it looks like; how much; how to use and when to use; start and stop dates; why I'm using it and notes; who told me to use it and how to contact them.
- FDA: My Medicine Record (Form FDA 3664), with How to Use My Medicine Record instructionsEnter all prescription medicines, including samples, and all over-the-counter medicines and dietary supplements (vitamins, minerals and herbals), whether used all the time or only some of the time.
- AHRQ: How To Create a My Medicines List (content last reviewed October 2022)Write one medicine in each row; write both the brand name and the generic name; enter the strength (e.g., 20 mg) and the instructions for when, how and how much, including special instructions such as taking it with food.
- AHRQ: How To Create a My Medicines List (content last reviewed October 2022)Enter your name, allergies and emergency contact at the top, and update the date at the top so you remember when you last made changes.
- FDA: My Medicine Record (Form FDA 3664), with How to Use My Medicine Record instructionsHow Much: if your dose differs from the dose the medicine comes in, note the number you use, for example "40 mg; use two 20 mg pills".
- FDA: My Medicine Record (Form FDA 3664), with How to Use My Medicine Record instructionsHow to Use / When to Use: for example "swallow with water; do not chew" or "take by mouth with food", and the time or time of day, such as "10:00 pm" or "at bedtime".
- AHRQ: How To Create a My Medicines List (content last reviewed October 2022)In the last four columns, write the amount you take at each time of day (morning, noon, evening, bedtime), so you can look down a column to see what to take at that time.
- FDA: My Medicine Record (Form FDA 3664), with How to Use My Medicine Record instructionsWhat it Looks Like: form (pill, tablet, capsule, liquid, injection, cream, drops and so on) and shape, color, size, scoring or other markings.
- FDA: My Medicine Record (Form FDA 3664), with How to Use My Medicine Record instructionsWhy I'm Using / Notes: the reason, special directions such as with or without food, tests needed to check it is working and their dates, and how to store it if not at room temperature.
- FDA: My Medicine Record (Form FDA 3664), with How to Use My Medicine Record instructionsWho Told Me to Use / How to Contact: name and contact information of the doctor, nurse or pharmacist who prescribed it or told you to use it.
- FDA: My Medicine Record (Form FDA 3664), with How to Use My Medicine Record instructionsStart / Stop Dates: the date you started; the date to stop if it is for a set period; "when needed" for something used only sometimes.
- AHRQ: How To Create a My Medicines List (content last reviewed October 2022)AHRQ's list uses three charts: medicines taken every day; medicines taken regularly but not every day (with a When column for the days and times); and medicines taken only when needed.
- FDA: My Medicine Record (Form FDA 3664), with How to Use My Medicine Record instructionsThe form has a page for personal contacts (you, an emergency contact, your primary care physician, your pharmacy), allergic reactions or other problems with any medicine, dietary supplement, food, skin cleaner or medical tape, and medical conditions and operations.
- FDA: My Medicine Record (Form FDA 3664), with How to Use My Medicine Record instructionsReview the record and update it when you stop or start a medicine or dietary supplement, make a change in anything you use, or visit your doctor, pharmacist or other health professional.
- AHRQ: How To Create a My Medicines List (content last reviewed October 2022)Update the list every time you start, stop or change a medicine; print the new list and throw out the old one so you have the most updated copy.
- HHS ODPHP MyHealthfinder: Use Medicines SafelyPay attention to the color and shape of your pills; if they look different when you get a refill, ask your pharmacist to double-check that you have the right medicine.
- FDA: My Medicine Record (Form FDA 3664), with How to Use My Medicine Record instructionsSave My Medicine Record on your computer and type into the fields, or print it and fill it in by pencil.
- AHRQ: How To Create a My Medicines List (content last reviewed October 2022)Save the My Medicines List to your computer so that you can easily make changes and won't need to enter the same information again.
- FDA: Create and Keep a Medication List for Your Health (Consumer Update, content current as of 01/08/2025)The best medication list is the one that is easy for you to create, maintain and remember to share; options include a simple paper list, an app, a downloadable form, or a template from your health care provider.
- FDA: My Medicine Record (Form FDA 3664), with How to Use My Medicine Record instructionsPrint and share the record with your doctors, pharmacists or other health professionals at all your visits; keep a printed copy with you; it is a good idea to give a copy to a friend or loved one.
- FDA: Create and Keep a Medication List for Your Health (Consumer Update, content current as of 01/08/2025)Keep a copy with you, for example a phone picture, an app, or a physical copy kept with your health insurance card; share your list with a trusted relative, friend or caregiver, including anyone who may accompany you at appointments or speak for you in an emergency.
- National Institute on Aging: Taking Medicines Safely as You AgeShow the list to all your health care providers, including physical therapists and dentists; if you cannot use one pharmacy, share your list with the pharmacist at each location when you drop off a prescription.
- MedlinePlus: Taking multiple medicines safelyDiscuss the list with your provider each time you have an appointment; ask whether you still need all of the medicines and whether any dosages should change; give all of your providers a copy; bring the list if you have a hospital stay.
- WHO: 5 Moments for Medication Safety (WHO/HIS/SDS/2019.4)WHO's Reviewing my medication questions: Do I keep a list of all my medications? How long should I take each medication? Am I taking any medications I no longer need? Does a health professional check my medications regularly? How often should my medications be reviewed?
- WHO: 5 Moments for Medication Safety (WHO/HIS/SDS/2019.4)WHO's Starting a medication questions include: What is the name of this medication and what is it for? and How should I store this medication?
- MedlinePlus: Taking multiple medicines safelyPeople who take medicines prescribed by more than one provider are more likely to have problems, because one provider may not know about medicines another provider has given you.
Triangle