Skip to content
Blood Sugar Log cover: a sample sheet with readings logged, average reading (mg/dl) and highest reading (mg/dl) and a bar chart, beside the Dashboard tab

Blood Sugar Log

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

This blood sugar log is for people who check their levels at home and want a tidy history to hand their care team. Each check is one line on the Readings tab, recording the date, time, timing (fasting, before a meal, two hours after a meal or bedtime), the reading in mg/dL, what you were doing and notes. The Dashboard counts readings and gives the average, the highest and lowest values and the average for each timing.

Several weeks of example checks fill every figure. To use your own copy, overwrite the examples and leave the timing names unchanged so the breakdown still counts them. Write down meals, exercise and any change in routine in the notes, since those often explain a high or low reading. Your care team sets the target range, so get it before you read the averages.

Useful for

  • Sharing a week of readings with a care team
  • Comparing fasting and after-meal numbers
  • Spotting highs and lows around exercise

What's included

  • 3 tabs: Dashboard, Readings, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Readings: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Readings tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What units does the log use?

The sample readings are in mg/dL, the standard unit in the US. If your meter shows mmol/L, change the header on the Readings tab and the breakdown labels, or convert the numbers before you enter them. Stick to a single unit throughout, or the averages will mislead.

What does fasting mean on this log?

Fasting means a reading taken after you have not eaten for a set time, often first thing in the morning. Your care team will tell you how long to wait. Choose the timing that matches the reading so the averages compare like with like.

When should I contact my doctor about a reading?

Follow the instructions your doctor or care team gave you for high and low readings. Do not wait for the next appointment if a reading worries you or you have symptoms. This log is a record, not medical advice.

  • #fitness-tracker
  • #blood-sugar-log
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More fitness tracker templates

See all 16

Also in Business operations

All business operations templates
Get this template

Preparing your template…