Skip to content
Study Habit Tracker cover: a sample sheet with study hours, sessions and average minutes per session and a bar chart, beside the Dashboard and Sessions tabs

Study Habit Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

This tracker is for students who want to see where their study time really goes. The Sessions tab logs each session on its own row, with the date, subject, method (practice problems, flashcards, past quizzes, reading notes or teaching it aloud), minutes, a focus score rated 1 to 5 and the topic covered. The Dashboard totals study hours, averages session length and focus, and charts minutes by subject and by method. The Week plan grid marks one planned session per subject on each weekday.

Score your focus straight after each session, while you still remember how it went. Check the method chart before a test, and if most minutes went to reading, add quizzes and practice problems. Adjust the week plan each Sunday so every subject gets a session, even a short one, before the next exam.

Useful for

  • Balancing five subjects across a school week
  • Seeing which study methods take up the most time
  • Building a timed plan for midterm exams

What's included

  • 4 tabs: Dashboard, Sessions, Week plan, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Sessions: a table
  • Week plan: a grid
  • 2 charts 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 Sessions 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 long should a study session be?

There is no fixed answer. Many students work well in blocks of 25 to 50 minutes with a short break, but pick a length you can keep up. The Dashboard shows your average minutes per session, so you can see whether you are staying with the work.

What counts as a good focus score?

Give a 5 only when you stayed on task for the whole session. A 3 means the session drifted at times, and a 1 means mostly distraction. Use the same standard every time, so the average focus figure means something.

Does the tracker work for group study?

Yes. Log your own minutes and methods, and note the group session in the Topic covered column. The totals then reflect your study time, not the whole group's. Ask one person to keep the shared copy tidy.

  • #habit-tracker
  • #study-habit-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…