Which columns the spreadsheet needs
- Date: the day you studied
- Minutes: how long you studied; a rough whole number is fine
- Skill: which one of Listening, Speaking, Reading, Writing, Vocabulary, Grammar, or Pronunciation
- Content: what you did, such as "extensive listening to a podcast" or "recorded monologue"
- Category: optional, such as intensive listening, extensive listening, or exam prep
- Note: optional, for takeaways or problems
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 planNext steps
- Download the study log template (CSV, opens in Excel)
- Open the online app and import your spreadsheet under "Settings → Data"
- How to make an Spanish study plan
- See membership plans
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
- How to make an Spanish study plan: 5 steps to a weekly schedule you can stick to
- Spaced repetition schedule: six reviews at intervals of 1, 2, 4, 7, 15, 30 days
- 30 minutes, 1 hour, or 2 hours a day: how to plan your daily Spanish study routine
- Spanish study log template: what to record and how (free download)