Free Digital SAT study resource

Free SAT Error Log Template for Google Sheets

Use one row for every missed or guessed question. This SAT error log template keeps the question context, root cause, corrected approach, next action, and review date in one place.

The Google button opens a copy prompt in a new tab. The CSV is available if you prefer Excel, Numbers, or another spreadsheet app.

Template preview

Record the reason, not only the wrong answer.

A useful SAT mistake log shows the decision that failed and the behavior that should replace it. These Math and Reading and Writing examples demonstrate the level of detail to aim for.

Math example

Linear equations: careless arithmetic

Root cause
Dropped a negative sign while combining terms.
Correct approach
Keep every sign visible until the final line.
Next action
Redo three sign-error problems, then retest this question.
Upload this mistake for diagnosis

Reading and Writing example

Transitions: strategy issue

Root cause
Chose by tone without naming the logical relationship.
Correct approach
Identify contrast, cause, example, or continuation before checking choices.
Next action
Complete five transition questions and label each relationship.
Review Reading and Writing mistakes
Two completed SAT error log example rows
Source Section Topic Error type Why I missed it Correct approach Next action Review date Status
Bluebook Test 3, M2 Q18 Math Linear equations Careless arithmetic Dropped a negative sign while combining terms Keep every sign visible until the final line Redo 3 sign-error problems August 19 Review again
Question Bank, M1 Q12 Reading and Writing Transitions Strategy issue Chose by tone without naming the logical relationship Identify contrast, cause, example, or continuation first Complete 5 transition questions and label the relationship August 21 New

What the columns mean

Seven fields turn a list into a review system.

Keep each entry short. Every field should help you decide what to do before the mistake repeats.

1. Question context

Record the source, section, module, question number, and topic so you can find the problem again.

2. Error type

Use a small set of labels: concept gap, interpretation, process, careless error, strategy, or timing.

3. Root cause

Name the exact step or decision that changed the result. Avoid vague notes such as “I was careless.”

4. Correct approach

Write the method in one or two sentences, focusing on the step that should replace the failed one.

5. Next action

Choose one concrete task: redo the problem, complete a short skill set, or apply a checking routine.

6–7. Review date and status

Schedule the next check and mark the row new, review again, or secure based on your retest.

Google Sheets setup

Make your own Google Sheet in one click.

Use the copy link for the fastest setup, or download the portable CSV for Excel, Numbers, and other spreadsheet apps.

1

Copy the Google Sheet

Open the template and choose Make a copy. Your private copy is saved in your own Google Drive.

2

Keep the two examples

Use the completed Math and Reading and Writing rows as a model for specific, useful diagnoses.

3

Add your first mistake

Record the source and your own diagnosis. Do not paste copyrighted official question text into a public sheet.

What to log

Include wrong answers and correct guesses.

A correct guess can hide the same weakness as a wrong answer. Add any question you could not explain, solved with an unreliable shortcut, or answered after running out of time.

  • Every missed question
  • Correct answers based on guessing
  • Questions that took much longer than expected
  • Problems you cannot explain without the answer key

Weekly review

Look for patterns before adding more practice.

Sort by topic and error type once a week. If the same root cause appears three times, treat it as one pattern to fix rather than three unrelated questions.

  • Count the most common error type
  • Choose one pattern for the next study block
  • Redo one old question without notes
  • Update the status only after a successful retest

FAQ

SAT error log template questions

What is an SAT error log?

An SAT error log is a record of missed and uncertain questions. It groups mistakes by topic and cause, then assigns a correction and review action so the same pattern is less likely to repeat.

Can I use this SAT error log template in Google Sheets?

Yes. Choose Copy the Google Sheet and confirm Make a copy. Google creates a private copy in your Drive with the headings and two completed examples.

Should I log guessed questions that were correct?

Yes. A correct guess can hide a comprehension, strategy, or timing issue. Log it if you could not reproduce or explain the method confidently.

How often should I review my SAT error log?

Add entries after each practice session. Review recurring patterns once a week, then revisit the selected questions before your next timed test.

Prefer automatic diagnosis?

Turn a photo of your SAT Math work into a structured mistake entry.

The photo is analyzed for the current review and discarded. Save the structured result only when you choose to.

Try the photo review