Spaced Repetition Google Sheets Template (Free Setup Guide)

6 min read · FlashDeck

A spaced repetition Google Sheets template needs just four things: the question, the answer, how many times in a row you've remembered it, and the date you last reviewed it. From those, one formula calculates the next review date, and a second tab shows only what's due today. Below is the full build, column by column, with formulas you can paste straight in.

If you'd rather skip the spreadsheet and still get a daily "what's due" list built from your class notes, FlashDeck does that part for you: Build my study plan.

What the spaced repetition spreadsheet needs to track

Spaced repetition means you review each item at growing gaps: tomorrow, then in a few days, then in a week, then longer. Miss it, and it resets to tomorrow. (If you're wondering why this is worth the setup, see spaced repetition vs cramming.)

To run that schedule, your spaced repetition tracker has to know:

• What you're reviewing (question and answer)
• Which step each card is on (how many correct reviews in a row)
• When you last reviewed it
• When it's due next (calculated, never typed)

That's it. Everything else is optional polish.

Column-by-column setup for your spaced repetition template

Create a new Google Sheet. Rename the first tab to Cards. Put these headers in row 1:

Make "Step" a dropdown

Select column D, then go to Data → Data validation and add a dropdown with the values 0, 1, 2, 3, 4. This stops typos from breaking your formulas.

Quick date entry

When you review a card, click its cell in column E and press Ctrl + ; (Cmd + ; on Mac) to drop in today's date.

Formulas for the next review date

This is the heart of any spaced repetition schedule template. We'll use five steps:

Next review (column F)

In F2, paste:

=IF(E2="","",E2+CHOOSE(D2+1,1,3,7,14,30))

CHOOSE picks the gap that matches the step. Step 0 picks the first value (1 day), step 4 picks the fifth (30 days). Drag the formula down the column. Format column F as a date (Format → Number → Date).

Want to change the gaps later? Just edit the five numbers.

Status (column G)

In G2, paste:

=IF(E2="","New",IF(F2<=TODAY(),"Due","Later"))

Drag it down. New cards say New, cards due today or overdue say Due, and the rest say Later.

Color the due cards

Select A2:G, go to Format → Conditional formatting, choose Custom formula is, and enter:

=$G2="Due"

Pick a highlight color. Now due rows jump out at you.

The update rules (this is the part you do by hand)

After you answer a card:

• Got it right: raise Step by 1 (stop at 4) and set Last reviewed to today.
• Got it wrong: set Step back to 0 and set Last reviewed to today.

The formulas take care of the new date.

Daily view of what is due

Scrolling a 300-row sheet every morning gets old fast. Add a second tab called Today and put this in A1:

=FILTER(Cards!A2:C, Cards!G2:G<>"Later", Cards!A2:A<>"")

That lists every New or Due card with its subject. Want only one class? Add a condition:

=FILTER(Cards!A2:C, Cards!G2:G<>"Later", Cards!C2:C="AP Bio U2")

Tip: hide column B on the Today tab (or narrow it) so you can't peek at answers. Say your answer out loud first, then check.

Using it with Excel or Notion

• Spaced repetition Excel template: the same CHOOSE, TODAY and IF formulas work in Excel. FILTER works in Excel 365 and Excel for the web.
• Spaced repetition Notion template: make a database with a Date property for Last reviewed, a Number property for Step, and a Formula property that uses dateAdd to calculate the next date. Then add a filtered view for due items.
• Spaced repetition template PDF: a printable version can only show a fixed calendar (review on day 1, 3, 7, 14, 30). It can't react when you miss something, which is the whole point.

Where spreadsheets fall short

The sheet works. Plenty of students use one for a few weeks. Here's where it tends to break:

1. Typing every card takes forever. A single lecture can have 20–40 facts. Copying each into two cells is slow, and slow means you skip it.
2. Updating is manual. Every card you review means two edits. At 40 cards a day, that's 80 edits.
3. It's easy to cheat. The answer is right there in the next column.
4. It's awkward on your phone. Tiny cells, no big buttons.
5. One missed day hurts. Nothing reminds you, so the Due pile quietly grows.

This is usually the moment the sheet gets abandoned: you're spending more time on data entry than on remembering. FlashDeck does the same schedule without the cells. Paste your notes or upload slides as a PDF (up to 30,000 characters or 20 pages), it writes one card per fact from only what you pasted, and each day it shows just the cards that are due. Tap Knew it or Missed it and the next date is set for you. Build my study plan

If you do stick with the spreadsheet, keep your cards small. Our guide on what to put on the front and back of flashcards will help your sheet stay quick to review.

Get the schedule without the setup

If you've read this far, you know how the spaced repetition Google Sheets template works under the hood. FlashDeck runs that same logic with two buttons: paste a unit of notes, delete any cards you don't want, and your first review list is ready in about a minute. After that, it's roughly 10 minutes a day of only what's due.

Build my study plan

FAQ

Is there a free spaced repetition Google Sheets template I can copy?

You can build one free in about 15 minutes with the columns and formulas above. Building it yourself also means you understand it, so you can change the review gaps whenever you want.

Why is spaced repetition better than cramming?

Cramming packs every review into one session, so facts are fresh for a day and then fade. Spacing makes you recall things after they start to slip, which keeps them for weeks. The full comparison is in our post on spaced repetition vs cramming.

What intervals should a spaced repetition schedule template use?

A simple set is 1, 3, 7, 14 and 30 days. If your exam is close, shrink them. If you're studying for something months away, you can add longer steps like 60 or 90 days.

Can I make a spaced repetition schedule template in Excel instead?

Yes. The same formulas work, and Excel 365 supports FILTER for the daily view. Older versions of Excel can use a filter on the Status column instead.

How many cards can a spreadsheet handle?

Google Sheets can hold far more cards than you'll ever write. The real limit is your patience with manual updates, which usually runs out somewhere past a few dozen reviews a day.