# Weekly study routine Excel sheet (free) + online

> Free Excel weekly study routine: plan blocks by subject and minutes, log what you studied, and see planned vs actual hours and completion per subject.

Source: https://softwiro.com/blog/weekly-study-routine-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Weekly study routine in Excel (free): plan each day and compare with what you actually studied

Plan study blocks by subject and minutes, log what you studied, and see which subject fell short and how many hours you did this week.

10 November 2026 4 min read

## In short

- Each study block is a row: date, subject, planned and actual minutes, and the weekday appears automatically.
- The summary compares actual hours with planned hours and with the weekly target of each subject.
- "Below plan" flags a subject where you did less than the share of the plan you set.
- It summarises seven days from the date you choose; other weeks stay in the log.

You want to know how many hours you really studied this week, and which subject got less time than you planned. The free [weekly study routine sheet](https://softwiro.com/templates/weekly-study-routine) does that: you plan each day, log what you studied, and the gap between plan and reality comes out by itself.

## The problem

Many students write a nice timetable and then cannot say where the week went. The timetable says "maths, an hour and a half", but nobody logged how much of it happened, so the shortfall shows up days before the exam.

## How it works

- In Subjects enter each subject and its weekly target in hours.
- In Settings enter the first day of the week and the minimum completion rate, for example 0.8 for 80%.
- In Schedule log each block: date, subject and planned minutes. The weekday appears automatically.
- After studying enter the actual minutes and pick "yes" under done if you finished the block.
- Weekly summary shows each subject's planned and actual hours, completion rate and gap to target, and each day's planned and actual minutes.

## How the numbers are worked out

- Hours = total minutes ÷ 60 for blocks that fall in the seven days from the start date.
- Completion = actual hours ÷ planned hours.
- Gap to target = actual hours − the subject's weekly target.
- Status: "below plan" when actual is under the minimum share of planned, "below target" when you met the plan but not the target, otherwise "on track".

Open the sheet at /ar/templates/weekly-study-routine. It holds 15 subjects and 1,000 study blocks.

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: weekly study routine (1/3)](https://softwiro.com/uploads/cheatsheets/weekly-study-routine/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/weekly-study-routine/en-1.jpg)[![Cheat sheet: weekly study routine (2/3)](https://softwiro.com/uploads/cheatsheets/weekly-study-routine/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/weekly-study-routine/en-2.jpg)[![Cheat sheet: weekly study routine (3/3)](https://softwiro.com/uploads/cheatsheets/weekly-study-routine/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/weekly-study-routine/en-3.jpg)

0 downloads · 3 pages

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Questions this raises

### How do I make a weekly study routine in Excel?

Enter your subjects and a weekly target in hours, log each block with date, subject and planned minutes, and enter the actual minutes after studying. The sheet works out hours per subject and completion.

### How is it different from the study planner sheet?

The study planner tracks lessons, their status and your scores before an exam. This sheet tracks the time you spend on each subject every week.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
