# GPA Calculator Excel: Weighted & Unweighted

> A free Excel GPA calculator: courses, credits and letter grades give unweighted and weighted GPA by term and cumulative, with a goal planner and charts.

Source: https://softwiro.com/templates/gpa-calculator
Language: English
Softwiro, softwiro.com

---

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.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-gpa-calculator.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-gpa-calculator-blank.xlsx)

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

| Term | Course | Type | Credits | Grade | Grade points | Weighted points | Status |
| --- | --- | --- | --- | --- | --- | --- | --- |
| Fall 2024 | English 9 | Honors | 0.5 | B+ | 3.3 | 3.8 | Counted |
| Fall 2024 | Geometry | Regular | 0.5 | A | 4.0 | 4.0 | Counted |
| Fall 2024 | Biology | Honors | 0.5 | A- | 3.7 | 4.2 | Counted |
| Fall 2024 | World History | Regular | 0.5 | B | 3.0 | 3.0 | Counted |
| Fall 2024 | Spanish I | Regular | 0.5 | A | 4.0 | 4.0 | Counted |
| Fall 2024 | Physical Education | Regular | 0.3 | P |  |  | Pass, credit only |
| Spring 2025 | English 9 | Honors | 0.5 | A- | 3.7 | 4.2 | Counted |
| Spring 2025 | Algebra II | Honors | 0.5 | B | 3.0 | 3.5 | Counted |

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.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-gpa-calculator.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-gpa-calculator-blank.xlsx)

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 sheet | In 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](https://softwiro.com/product/student-performance) · [Ask for a demo](https://softwiro.com/contact)

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| Grades typed in by the student or one teacher | Grades collected from all teachers into one record |
| Scale and bonus points edited by hand | School policy applied automatically to every student |
| Up to 40 courses and 8 terms per file | A full transcript for any number of students |
| Goal planner for one student | Targets and early warnings for every student |
| Printed or shared file | Reports sent to students and parents in an app |

### Extra features in the app

- Grades from every teacher flow into each student's GPA automatically.
- Transcripts and GPA reports for students and parents without retyping.
- School-wide grading policies (scale, weights, caps) applied the same way to everyone.
- Early alerts when a student's GPA falls below a threshold.
- Term-to-term comparison across classes and cohorts.
- Honor-roll lists produced for the whole school.

[Ask for your custom system](https://softwiro.com/contact)

## 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](https://softwiro.com/templates/gradebook) for teachers and [study planner](https://softwiro.com/templates/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](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](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](https://softwiro.com/templates/for-american)

More free templates for: American diploma

## More free templates

- Lesson Plan Template for Excel with Curriculum Tracker
- Donation Tracker Spreadsheet for Nonprofits (Excel)
- Expiry Date Tracker for Excel (Inventory)
- HOA Dues Tracking Spreadsheet for Excel
- HOA Budget Template for Excel
- Car Rental Booking Tracker for Excel
- Employee Leave Tracker Template for Excel
- Monthly Habit Tracker Template for Excel (With Streaks)

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
