Guides › Injection site rotation log: a simple spreadsheet method · Updated 30 Oct 2026

Injection site rotation log: a simple spreadsheet method

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.

Patient leaflets for injectable medicines usually tell you to rotate injection sites. Remembering which one you used last week is the hard part. A small log fixes that.

Your list of sites

On a sheet called Sites, list the sites your leaflet or nurse names, in the order you want to rotate. For example: Abdomen left, Abdomen right, Thigh left, Thigh right. Keep it to what you were told; this sheet does not decide where you may inject.

The log

In your dose log, add a Site column with a dropdown linked to that list (Data → Data validation → List from a range). No typing, no spelling variations.

Which site is next?

If you follow a fixed order, this gives the next one:

=INDEX(Sites!A2:A5, MOD(MATCH(last_site, Sites!A2:A5, 0), 4)+1)

Replace last_site with a cell that holds the most recent entry, e.g. =INDEX(Doses!E:E, COUNTA(Doses!E:E)), and 4 with the number of sites.

How often was each site used?

=COUNTIFS(Doses!E:E, A2, Doses!A:A, ">="&TODAY()-56)

That counts each site over the last eight weeks. If one number is much higher than the others, you have drifted into a habit.

Notes column

Write down anything you want to mention at your next appointment, like redness that lasted. Your clinician decides what it means.

Rather start with a ready-made file?

The GLP-1 Tracker includes an injection-site rotation sheet linked to the dose log. Your data stays in your own file.