Skip to content
The title slide and first slides of the Study Planner template

Study Planner

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

The Study Planner helps students plan revision across several subjects. The Subjects tab sets a weekly hour target and a confidence rating for each subject. The Sessions tab is a log of study sessions with the topic, hours and whether practice was done. The Exams tab counts the days left to each paper.

The Dashboard compares the target and the hours studied for each subject, with a chart. It comes with sample data for six subjects. Make a copy, replace the sample rows and add your own exam dates. Totals, dropdowns and the chart update on their own.

Useful for

  • Planning revision across GCSE or A-level style subjects
  • Checking that weak subjects get enough study time each week
  • Counting down to a set of mock or final exams

What's included

  • 5 tabs: Dashboard, Subjects, Sessions, Exams, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Subjects: a table
  • Sessions: a table
  • Exams: 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 Subjects 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

Is this Study Planner template free?

Yes. Download the template and use it at no cost. You do not need to sign up to open it.

Does it work in Excel?

Yes. Download the .xlsx file and open it in Microsoft Excel. The days-left counts and the chart work in both Excel and Google Sheets.

Does the days-left count update each day?

Yes. It uses today's date, so the number of days to each exam goes down as the date moves on.

  • #study-planner
  • #study-planner
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Careers

All careers templates
Get this template

Preparing your template…