Skip to content
GPA Calculator cover: a sample sheet, beside the Term GPA and Goal GPA tabs

GPA Calculator

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Style
Modern
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

The GPA Calculator suits high school and college students who want their grade point average without doing the sums by hand. The Term GPA tab covers each course along with its credit hours and letter grade, converts each grade into grade points and totals the quality points. The Goal GPA tab takes your credits so far, current GPA and target, then works out the average you need in the rest of the term.

Use the grade scale from your school, since the points for plus and minus grades vary between institutions. Start with your current GPA and total credits from your transcript, then try a few target GPAs to see which are realistic. Treat the results as planning figures, and check your school's rules on repeats and withdrawals with the registrar.

Useful for

  • Working out a semester GPA before grades are final
  • Planning the grades needed to reach a scholarship GPA
  • Comparing two course loads by their credit hours

What's included

  • 3 tabs: Term GPA, Goal GPA, How to use
  • Term GPA: a ready-to-fill form
  • Goal GPA: a ready-to-fill form
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Term GPA tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How is a GPA calculated?

Multiply each course's grade points by its credit hours, add those quality points together and divide by the total credit hours. On the usual scale a B is 3.0 points, so a 4-credit course with a B adds 12 quality points.

What if my school uses a different grading scale?

Each school sets its own points for plus and minus grades, so use the scale in your handbook rather than the sample one. Change the grade points in the formula column to match it, and the GPA will update for every course.

How do I find the grade I need to reach my target?

On the Goal GPA tab, enter your credits earned, current GPA, this term's credits and your target. The average needed shows the grade points per credit you need this term. If it is above 4.0, that target is not reachable on the usual scale.

  • #grade-tracker
  • #gpa-calculator
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More grade tracker templates

See all 8

Also in Careers

All careers templates
Get this template

Preparing your template…