Free Study Planner Templates: A Guide to All Three CSVs

Three free study planner templates are available on this site as plain CSV files: a weekly study timetable for planning sessions and recording what actually happened, a spaced revision tracker for scheduling recall attempts by result, and a mock-test error log for turning wrong answers into repair tasks. No account is needed to download them.

This guide describes the real columns in each file, shows a filled-in example row, explains how to import them, and says when a spreadsheet stops earning its keep.

All three are listed on the study templates page, each with a download link.

What is in the weekly study timetable template?

The weekly study timetable is a seven-column CSV that gives every session a topic, a time budget and a checkable result. It is the file to start with if you have never planned in writing before.

The shipped file contains a worked Monday of four tasks on one topic, empty rows for Tuesday to Friday at 120 minutes each, a Saturday weekly review and a Sunday marked as rest or buffer. A completed row looks like this:

That row carries the most useful information in the template. Planned 40, actual 55 means your estimates are optimistic by roughly a third, and next week should be built on the larger number. The two-hour daily plan guide explains how to structure a short evening session before you fill the sheet in.

What is in the spaced revision tracker template?

The spaced revision tracker is an eight-column CSV for recording recall attempts and choosing the next review date from the result rather than from a fixed rule.

The three results mean: again, you could not produce a correct answer; hard, correct but hesitant or hint-assisted; good, correct and explainable without help. A filled row:

Two design points matter. The prompt column holds a question, not a chapter name, because "revise percentages" is not something you can pass or fail. And the file calculates nothing: you pick the next date yourself. The spaced repetition timetable guide covers how to choose those gaps, and interleaving practice covers mixing topics within a session.

What is in the mock-test error log template?

The mock-test error log is a nine-column CSV in which every row is one question, not one test. That is the idea: a score gives you nothing to act on, while a question-level cause does.

The shipped file demonstrates the outcomes across three rows, including a correct guess, the kind of hidden weakness most people never log and that reappears in the real exam. A filled row:

Separating error type from cause is what makes the log usable later. Sorting by error type shows whether your losses are mostly knowledge gaps or mostly timing, and those need different responses. The mock-test analysis guide works through a review session, and time management for speed and accuracy covers the timing category.

How do I import a CSV template into a spreadsheet?

Follow these steps once per template:

1. Download the file from the link in this article or from the study templates page. It saves as a plain .csv file.
2. In Google Sheets, open a blank spreadsheet and choose File, then Import, then Upload. Replace the current sheet and keep the comma as the separator.
3. In Excel, open the file directly. If your regional settings use a semicolon and the columns land in one cell, use Data, then From Text or CSV, and set the delimiter to comma.
4. In Apple Numbers or LibreOffice Calc, open the file directly; both detect commas without configuration.
5. Freeze the header row so column names stay visible. In Sheets this is View, then Freeze, then 1 row.
6. Delete the example rows once you have read them, and replace them with your own topics and dates.
7. Widen the prompt, cause and repair columns, or turn on text wrapping. They hold sentences, and a truncated repair task is one that will not happen.

Keep the three files as three tabs in one spreadsheet if you prefer a single document.

How do I fill in the templates in the first week?

Start with one file, not three. Fill the weekly timetable on Sunday for the week ahead, with honest rather than aspirational planned minutes, then enter actual minutes each evening.

Add the revision tracker in week two, seeded only with topics you have already studied, one row each with a real recall prompt. Add the error log the first time you sit a timed paper. Starting all three at once usually produces three abandoned files.

Which template should I start with?

Start with the weekly timetable if your problem is that study time keeps disappearing. Start with the error log if you are already practising regularly but your scores are flat, because flat scores with steady practice almost always mean the same mistakes are repeating unlogged.

Start with the revision tracker if you cover material successfully and then find it gone a month later. Picking the file that matches your actual problem matters more than completeness. If you are unsure which numbers to watch, the study progress metrics guide sets out what is worth measuring.

When does a spreadsheet stop being enough?

When maintaining it costs more than it returns. That point is not about sophistication, it is about volume and change.

At that stage, a study plan that redistributes unfinished work across your remaining days, a calendar showing what is due, and a progress view that keeps the overdue count visible take over the bookkeeping. That is what MyStudyPlanner's study plans, planner, calendar and progress tracking do. Our comparison of automated and manual planning sets out what automation does and does not solve; MyStudyPlanner is our own product, so treat it as a disclosed comparison rather than a neutral review.

Frequently Asked Questions

What free study planner templates are available here?

Three, all plain CSV files with no account required: a weekly study timetable for planning sessions and recording actual minutes, a spaced revision tracker for scheduling recall attempts by result, and a mock-test error log for turning wrong answers into specific repair tasks. Each opens in Google Sheets, Excel, Numbers or any spreadsheet application.

How do I import a CSV template into Google Sheets?

Open a blank spreadsheet, choose File, then Import, then Upload, and select the downloaded CSV. Choose to replace the current sheet and keep the comma as the separator. In Excel you can usually open the file directly, or use Data, then From Text or CSV, if your regional settings use a different list separator.

What columns does the weekly study timetable template contain?

Seven: Day, Topic, Task, Planned minutes, Actual minutes, Evidence of completion, and Status. The pairing of planned and actual minutes is the important part, because comparing the two after a week tells you whether your time estimates are realistic. Evidence of completion forces each session to end in something you can check.

Do the templates calculate review dates automatically?

No. The CSV files contain plain rows and columns with no formulas, macros or automation. You enter the next review date yourself, choosing it from the recall result you recorded. That is deliberate: the decision about when to return to a topic should follow how well you remembered it, not a fixed interval.

When is a spreadsheet no longer enough for study planning?

When maintenance costs more than it returns. Typical signals are several subjects competing for the same evenings, a syllabus too large to re-sort by hand, review dates you have stopped updating, and no reliable count of overdue work. At that point an app that redistributes missed tasks and tracks due reviews saves real time.

Can I print the study planner templates?

Yes. Open the CSV in a spreadsheet application and print from there, setting the page orientation to landscape because the revision tracker and error log are wide tables. Many people keep the weekly timetable on paper for daily use and the error log on screen, since the log is filtered and re-sorted far more often.

Your next step

Download the weekly study timetable, delete the sample Monday, and plan the next seven days with honest planned-minute figures. Enter actual minutes each evening. The gap between those two columns after one week is the most useful thing these templates will tell you.