In this article:

Free Medication Schedule Template for Google Sheets (2024)

December 5, 2024

In this article, we will show you how to use our medication tracker in Google Sheets. Read on to learn more!

google sheets medication tracker

Free Medication Schedule Template

You can make a copy of our medication tracker in Google Sheets for free. Don't request for permission to edit, simply go to File > Make a copy.

google sheets medication tracker template

How to Use Our Medication Schedule Template on Google Sheets

Below, we explain how to use our medication tracker using Google Sheets.

1. Enter Time of Day

In the Time of Day column, specify when you need to take each dose (e.g., “Morning, Noon, Evening” or “Afternoon, Evening”).

medication tracker template in google sheets

2. Fill in Frequency

In the Frequency column, write how often you need to take the medication (e.g., “3 times/day” or “Once daily”).

medication tracker template on google sheets

3. Add Medication Name

In the Medication Name column, enter the name of your medication (e.g., “Metformin”).

medication tracker template with google sheets

4. Input Dosage

In the Dosage column, fill in the dosage with the appropriate units (e.g., “500 mg”).

5. Enter Start and End Dates

In the Start Date column, type the date you will begin taking the medication (e.g., “2024-10-25”). In the End Date column, enter the last date you will take the medication or write “Ongoing” for long-term medications.

6. Add Notes

In the Notes column, include any additional information, such as “Take with food” or “Avoid taking on an empty stomach.”

Feel free to customize this layout based on your specific needs!

We hope you now know how to use the medication list template with Google Sheets. If you enjoyed this article, you might also want to check out our free Google Sheets chores template and weekly planner template in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->