Google Sheets · Excel · 6 tabs · A1c estimate · no macros
Blood Sugar & A1c Tracker Spreadsheet
Log one line a day — get your A1c estimate and doctor report.
€14.90 · instant download · Excel and Google Sheets · no subscription · use it forever.
What this is
A Google Sheets / Excel tracker for daily blood glucose readings, with an estimated A1c and a print-ready clinician summary.
A blood glucose tracking system in Excel and Google Sheets: a daily log, a medication log, a live dashboard, and a printable clinician report.
What you get
- 6 tabs: SETUP · GLUCOSE LOG · MEDICATION LOG · DASHBOARD · CLINICIAN REPORT · README
- Auto A1c estimate — Mean glucose to estimated A1c, corrected live
- High / low flags — 180+ turns red, 70- turns amber automatically
- Doctor report — One printable page for your next appointment
- Log columns: Date, Fasting (mg/dL), Post-meal (mg/dL), Carbs (g), Medication taken, Energy 1-5, Notes
The tabs
Setup
Name, targets, type, medication
Glucose Log
Fasting, post-meal, carbs, energy, notes
Medication Log
Every dose change with dates
Dashboard
Averages, A1c estimate, in-range %
Clinician Report
One-page printout
README
How to use it, what colours mean
The columns you log
Date · Fasting (mg/dL) · Post-meal (mg/dL) · Carbs (g) · Medication taken · Energy 1-5 · Notes
What the dashboard works out for you
- Days logged
- Readings logged
- Average fasting
- Average post-meal
- Estimated A1c (ADAG)
- High readings (180+)
- Low readings (70 or less)
- Readings in range (70-180)
- % of readings in range
- Average carbs per day
- Days medication taken
- Average energy (1-5)
- Days tracked so far
What a filled-in week looks like
The GLUCOSE LOG with 34 days of sample data
| Date | Fasting | Post-meal | In range |
|---|---|---|---|
| 2026-08-04 | 118 | 164 | yes |
| 2026-08-05 | 96 | 138 | yes |
| 2026-08-06 | 172 | 204 | no |
| 2026-08-07 | 104 | 129 | yes |
| 2026-08-08 | 88 | 142 | yes |
A few seconds a day
1 — Log the reading
Fasting + 2-hour post-meal
2 — Watch the dashboard
Averages, A1c, in-range %
3 — Print the report
Take it to your appointment
Who it is for
Type 1 & Type 2
Anyone logging readings daily and wanting the pattern, not the pile of paper.
Appointment-ready
Walk in with a one-page report instead of a notebook.
Data people
Real formulas in a real spreadsheet you own forever.
Carers & family
Track a parent's or partner's readings in one shared file.
Prediabetes
Catch the drift early — the in-range % is the number that moves.
How to use it
What this is
A blood glucose tracking system in Excel and Google Sheets: a daily log, a medication log, a live dashboard, and a printable clinician report.
1. SETUP
Name, date of birth, tracker start date, glucose unit, your target fasting and post-meal values, diabetes type and current medication.
2. GLUCOSE LOG
One row a day: date, fasting reading, 2-hour post-meal reading, carbs, whether you took medication, energy 1-5, notes. Leave a line blank if you skipped a day.
3. DASHBOARD
Days logged, readings logged, average fasting, average post-meal, estimated A1c from mean glucose (ADAG), high readings, low readings, readings in range, % in range, average carbs and average energy.
4. REPORT
Print this page and hand it over. It states the date range, totals, averages, out-of-range counts and your current medication.
Files included
Filled sample workbook (so you can see it working), the blank workbook to type into, and this quick-start guide as a PDF.
Works with
- Excel and Google Sheets (instructions included)
- Print as PDF for a paper copy
Before you buy: Not medical advice. This workbook records and summarises what you enter; it does not diagnose, treat or replace your care team.
Get it
€14.90, instant download from the ChurchillCraft shop on Etsy. No subscription, no account, no macros — the file is yours and it keeps working.