English study log template: what to record and how (free download)

The point of a log isn't a nice-looking row of check-ins. It's to answer two questions: where did my time go, and am I improving? A six-column spreadsheet is enough to answer the first.

Updated

Which columns the spreadsheet needs

How to fill it in so you keep it up

Log it right after you study; a row should take no more than half a minute. The content doesn't need to be detailed: "listened to one podcast episode" is enough.

If you did several things in one day, add a row for each. Don't wait until the weekend to fill it all in: numbers filled in afterward are inaccurate, and the hassle makes it easy to give up.

What to look at each week

Spend five minutes each weekend on three numbers: how long you studied in total this week, how much went to each skill, and what share was output (speaking and writing).

If any skill has been at zero for two weeks in a row, schedule it first next week.

The limits of a spreadsheet, and what the online app adds

A spreadsheet keeps a clear record of your time, but for review reminders, streak counts, and level estimates you have to write the formulas yourself.

The online app does all of that for you: save your filled-in spreadsheet as CSV and import it directly, and none of your existing records are lost. SVIP can also go the other way and export online data as an Excel workbook with formulas and charts.

Turn your plan into weekly goals, log it after you study, and let the numbers show your progress.

My plan

Next steps

FAQ

Can I keep my log in a paper notebook?

Yes. What matters is logging every day and looking it over every week. The drawback of paper is that you have to add up the totals yourself, and after a while it gets hard to look back.

What if my columns are in a different order when I import?

That's fine. The import works out what each column is from the header row, and you can choose manually for any it doesn't recognize. Common ways of writing dates and durations can all be read.

Other guides