Guides › How to set up a GLP-1 dose log in Excel or Google Sheets · Updated 30 Oct 2026

How to set up a GLP-1 dose log in Excel or Google Sheets

This guide is about keeping records, not medical advice. Your dose, schedule and injection technique are set by your prescriber and the patient leaflet; bring questions to them.

A dose log answers three questions at a glance: what did I take, when, and when is the next one due. You can build one in about fifteen minutes. Here is how.

The columns

Start a sheet called Doses with these columns: Date, Time, Medication, Dose (exactly as written on your prescription), Site (for injections) and Notes. Turn the range into a table with Ctrl+T in Excel so new rows pick up the formulas automatically.

Next dose due

Put your interval in days in a settings cell, say Settings!B2: 7 for a weekly injection, 1 for a daily pill. Then, on a dashboard sheet:

=MAX(Doses!A:A)+Settings!B2

Format the cell as a date. Next to it, the number of days left:

=MAX(Doses!A:A)+Settings!B2-TODAY()

A missed-dose flag

Use conditional formatting on the "days left" cell: red when it is below 0. That is all you need; don't let the sheet decide what to do about a missed dose. The patient leaflet and your prescriber tell you that.

Dose changes

When your prescriber changes the dose, add a row with the new dose and write the reason in Notes ("step-up as planned", "kept at same dose"). Months later, that single column tells the story better than your memory will.

Keep it boring

The best log is one you fill in every time, in under ten seconds. Pin the sheet on your phone's home screen in the Google Sheets app, or keep the file in a folder you open anyway.

Rather start with a ready-made file?

If you would rather not build it, our GLP-1 Tracker has the dose plan, dose log with next-dose reminder, weight charts, daily log, injection-site rotation and a doctor-visit summary ready to go. Your data stays in your own file.