Softwiro
Free Excel template

GPA Calculator for Excel (Weighted and Unweighted, by Term)

Type each course once (term, name, type, credits, letter grade) and this workbook works out your unweighted GPA, your weighted GPA with honors, AP and IB bonus points, the GPA of every term and the cumulative GPA after each term. A goal planner tells you what GPA you need in your remaining credits to reach a target. The sample student has 31 courses over five terms; clear them and enter your own. The letter scale and the bonus points are cells you edit, so it follows your school's rules instead of a fixed formula.

Excel file (.xlsx) · 29 KB · 6 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

Example from the sheet

Example from the “Courses” tab, with the numbers and formulas that are in the file.
TermCourseTypeCreditsGradeGrade pointsWeighted pointsStatus
Fall 2024English 9Honors0.5B+3.33.8Counted
Fall 2024GeometryRegular0.5A4.04.0Counted
Fall 2024BiologyHonors0.5A-3.74.2Counted
Fall 2024World HistoryRegular0.5B3.03.0Counted
Fall 2024Spanish IRegular0.5A4.04.0Counted
Fall 2024Physical EducationRegular0.3PPass, credit only
Spring 2025English 9Honors0.5A-3.74.2Counted
Spring 2025Algebra IIHonors0.5B3.03.5Counted

Example from the “Courses” tab, with the numbers and formulas that are in the file.

What is inside

  • Setup: Student, school and class, honor-roll cut-offs, the target GPA, your list of terms, the letter scale with grade points (13 grades with plus and minus) and the bonus points for each course type.
  • Courses: One row per course: term, name, type, credits and letter grade. Grey columns show grade points, bonus, weighted points, quality points, credits earned and a status (Counted, In progress, Pass credit only, Not in GPA).
  • Terms: Credits, term GPA and weighted GPA, cumulative credits, cumulative GPA and weighted GPA after each term, and the change from the previous term.
  • Summary: Cumulative unweighted and weighted GPA, credits counted and earned, honor-roll level, best term, the goal planner, the grade spread and GPA by course type, with 3 charts.

The file opens on a start tab (“Start here”) that explains how to use it.

What makes it different

A lot of Excel GPA sheets only average a column of grade points. This one weights by credits, adds course-type bonuses only to passing grades, keeps P, W and incomplete grades out of the GPA, shows courses still in progress without distorting anything, and tells you what you need to reach a target. Unused rows stay blank instead of showing errors.

How do you calculate weighted and unweighted GPA in Excel?

Unweighted GPA uses the plain grade points for each letter (A = 4.0, B = 3.0 and so on). For each course the sheet multiplies the credits by the grade points to get quality points, adds them up and divides by the total credits. Weighted GPA does the same after adding a bonus to the grade points of harder courses.

In the sample, the bonus is 0.5 for Honors and 1.0 for AP, IB or dual enrollment. The sample student's cumulative unweighted GPA is 3.40 and the weighted GPA is 3.67 over 11.0 credits, so the advanced courses add 0.27. For example, an AP US History grade of B+ (3.3) counts as 4.3 in the weighted GPA. These bonus points are examples; many schools use different numbers or cap the weighted GPA, so check your school or district policy and change the Setup cells.

How do I calculate cumulative GPA by semester?

The Terms sheet totals quality points and credits for each term, then keeps a running total. Cumulative GPA after a term is all the quality points so far divided by all the credits so far, which is not the same as averaging the term GPAs when the terms have different credit loads.

In the sample, Fall 2024 has a term GPA of 3.60 and Spring 2026 has 3.12, so the term GPA fell over the four graded terms. Fall 2026 is still in progress, so it shows as In progress and is left out until you enter grades.

What GPA do I need to reach my target?

Type a target cumulative GPA and the credits you still have to take on Setup. The Summary sheet shows the unweighted GPA you must average in those credits, the highest final GPA still possible and a verdict: Already secured, Reachable or Out of reach. With a target of 3.50 and 4.0 credits to go, the sample student needs a 3.79 average, which is reachable but demanding.

Use it to compare targets before a semester starts. For a semester course of 0.5 credit, 4.0 credits is eight courses. Planning figures only show what is mathematically needed; they do not predict what grades you will earn.

How to use it

  1. On Setup, type the student name, list your terms in order (Fall 2026...), and check the letter scale and the bonus points for each course type (Honors, AP, IB). Change them to match your school.
  2. On Courses, add one row per course: pick the term, type the course name, choose the course type, enter the credits and pick the letter grade. Leave the grade empty while a course is in progress.
  3. The grey columns show the grade points, the weighted points and whether the course counts in the GPA. Grades that are not on the scale (P, W, I) are kept out of the GPA.
  4. Open Terms to see the GPA of every term and the cumulative GPA after each term.
  5. Open Summary for the cumulative unweighted and weighted GPA, credits, honor-roll level, the grade spread and the goal planner. Type your target GPA and the credits you still have to take on Setup.

Before you start:

  • Capacity: 40 courses, 8 terms, 13 letter grades and 6 course types. Unused rows stay blank.
  • GPA = total quality points divided by total credits, where quality points are credits multiplied by grade points. A 1-credit course counts twice as much as a half-credit course.
  • Weighted GPA adds the course-type bonus to the grade points (for example +0.5 for Honors, +1.0 for AP). The bonus is only added when the grade is worth at least the minimum on Setup (1.0 by default), so a failing grade gets no bonus.
  • Grades that are not on the letter scale, such as P (pass), W (withdrawn) or I (incomplete), are not counted in the GPA. P still earns credit; the Status column says what happened to each course.
  • Schools differ: some give A+ 4.3, some cap the weighted GPA, some round differently. Edit the scale and the bonus points to follow your own school or district policy.

Excel file (.xlsx) · 29 KB · 6 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Still running this on Excel?

This sheet holds the numbers of one class, typed in by one teacher. In the School Performance Management Platform, each student's grades, attendance and teacher notes come together, and reports reach parents.

In this sheetIn School Performance Management Platform
Every teacher has a sheet, and the administration collects the files.One dashboard for students, teachers and classes, with exam results tracking and a comparison of performance across terms.
A student's decline shows up in the end-of-term result.AI analyzes the student's grades, attendance and teacher notes, warns early about a possible decline, and suggests a development plan that the teacher decides on.
The parent learns about the problem late.Regular reports to parents on the student's level, teacher notes and the attendance record, plus direct contact with the school through the app.
Attendance lives in a notebook or a sheet per class.Attendance, absence and lateness are recorded for each student and turned into attendance reports and rates that the administration follows for each class.

See School Performance Management Platform · Ask for a demo

Frequently asked questions

Is this GPA calculator free?

Yes. It is free to download, change and share. It is a normal Excel file and also opens in Google Sheets and LibreOffice.

Can I use a different grading scale, such as A+ = 4.3 or a 5.0 scale?

Yes. The letter scale on Setup is a list of letters and grade points that you can edit or extend. Change A+ to 4.3 or any value your school uses. The goal planner takes its maximum from the highest grade point in your scale.

How are P, W and incomplete grades handled?

Any grade that is not on your scale stays out of the GPA. A P (pass) still earns its credits, shown in Credits earned. Entries such as W show the status Not in GPA so you can see what happened to the course.

Why is there no bonus on a failing grade?

On Setup you set the lowest grade points that qualify for the bonus (1.0 by default, which is a D). An F in an Honors course therefore adds nothing. Set it to 0 if your school gives the bonus on every grade.

How many courses and terms can I enter?

40 courses, 8 terms, 13 letter grades and 6 course types per file. For a longer record, save a second copy. See also gradebook template for teachers and study planner for revision.

Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html

All the templates in this group: Excel templates for the American diploma: GPA, AP and SAT

More free templates for: American diploma

More free templates

All templates · Free tools