Skip to content
Sleep Tracker cover: a sample sheet with nights logged, average hours and nights under 7 hours and a pie chart, beside the Dashboard, Nights and Wind-down tabs

Sleep Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

This sleep log suits anyone who wants a clearer picture of their nights, from shift workers to students. The Nights tab gives every night a row holding bedtime, wake time, an automatic Hours asleep figure and a How I felt list. The Dashboard shows nights logged, average hours, nights under seven hours and rested mornings, with a pie chart of nights by how they felt. A Wind-down grid tracks five evening habits across the week.

Hours are calculated from bedtime and wake time, and a night that crosses midnight is handled without extra steps. Start with the sample nights, then clear them and add your own. The Wind-down grid works best when you change a single habit at once and watch over a fortnight which change makes a difference.

Useful for

  • Checking whether a run of late work nights is cutting into sleep
  • Testing a new bedtime routine over two weeks
  • Bringing a sleep diary to a doctor's appointment

What's included

  • 4 tabs: Dashboard, Nights, Wind-down, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Nights: a table
  • Wind-down: a grid
  • 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 Nights 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

How many hours of sleep do adults need?

Health agencies commonly suggest about seven hours or more a night for adults, but individual needs differ. Use the average on the Dashboard as a starting point. Ask your doctor if you feel sleepy during the day or your sleep worries you.

Why does the hours figure show a decimal?

The hours come from the two times, rounded to one decimal place, so a seven-and-a-half-hour night shows as 7.5. A bedtime after midnight also works, because the formula handles the change of day.

Can I record naps as well?

Not in the Nights tab, because each row is one night. Keep daytime naps in a separate copy or in the Note column. Leaving naps out of the table stops them from pulling down the average for your nights.

  • #habit-tracker
  • #sleep-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More habit tracker templates

See all 15

Also in Business operations

All business operations templates
Get this template

Preparing your template…