Quick Answer
To calculate GPA in Excel or Google Sheets: build a table with course name, credit hours, and letter grade. Use VLOOKUP to convert each letter grade into grade points, multiply grade points by credit hours to get quality points, then divide total quality points by total credit hours.
The formulas are the same in both platforms. This guide includes a free ready-to-use Google Sheets template, a downloadable Excel file, the full formula reference, and a walkthrough from empty sheet to calculated GPA.
Jump to a Section
Free GPA Spreadsheet Templates
Two options. Both free. Both include the pre-built grade conversion table, the VLOOKUP lookup, quality point calculation, and GPA formula — so you can enter grades and get a result without building anything from scratch.
🚀 Google Sheets Template
Copy it to your Google Drive and start entering grades. Works for semester and cumulative GPA.
📋 Copy Template to Google Drive
No sign-up required · Click the link to make a copy
📥 Download Excel GPA Calculator
Professional Excel workbook with 4.0 and 5.0 scale support, semester tracking, Target GPA Planner, and a grade distribution summary.
📥 Download Excel GPA Calculator
Excel 2007+ · No sign-up required · Includes both 4.0 and 5.0 scales
📌 What each template includes:
- Pre-built grade conversion table (A through F, with plus/minus grades)
- VLOOKUP formulas that convert letter grades automatically
- Quality point calculation (grade points × credit hours)
- Automatic semester GPA and cumulative GPA
- Color-coded sections for easy navigation
- Excel version also includes: 4.0 and 5.0 scale support, Target GPA Planner, grade distribution breakdown
Step 1: Set Up Your Spreadsheet
Open Google Sheets or Microsoft Excel and create a new blank spreadsheet. You’ll build five columns and a small lookup table.
1.1 Create the column headers
In row 1, enter these five headers:
| Column | Header | What goes in it |
|---|---|---|
| A | Course Name | The course name (optional) |
| B | Credit Hours | Number of credits for the course |
| C | Letter Grade | The grade received (A, B+, C, etc.) |
| D | Grade Points | Formula auto-converts from Column C |
| E | Quality Points | Formula = Grade Points × Credit Hours |
1.2 Build the grade conversion table
In a separate area of the sheet — say columns G and H, starting at row 2 — paste your institution’s official grade scale. On the standard US 4.0 scale:
| G: Letter Grade | H: Grade Points |
|---|---|
| A | 4.0 |
| A− | 3.7 |
| B+ | 3.3 |
| B | 3.0 |
| B− | 2.7 |
| C+ | 2.3 |
| C | 2.0 |
| C− | 1.7 |
| D+ | 1.3 |
| D | 1.0 |
| D− | 0.7 |
| F | 0.0 |
If your institution doesn’t use plus/minus grades, or uses different values, edit this table before proceeding. The VLOOKUP formulas below reference whatever values you put here. For a common mapping from letters to percentages, see College Board BigFuture.
Step 2: Convert Letter Grades to Grade Points with VLOOKUP
Rather than typing grade points for every row, let VLOOKUP do it. Paste this formula into cell D2 and copy it down for every course:
Excel & Google Sheets Formula
=VLOOKUP(C2, $G$2:$H$13, 2, FALSE)
Replace C2 with the cell containing the letter grade.
How the formula works
- C2 — the cell holding the letter grade to convert
- $G$2:$H$13 — the range containing your grade conversion table. The dollar signs lock the reference so it doesn’t shift when you copy the formula down.
- 2 — the column number within that range containing the grade points (column H is the second column in the G:H range)
- FALSE — requires an exact match on the letter grade
Critical: the dollar signs around $G$2:$H$13 are what make this formula work when copied. Without them, the range shifts row by row and returns the wrong grade points. If you see a wrong result, this is almost always why.
Newer alternative: Microsoft now recommends XLOOKUP as VLOOKUP’s modern replacement — it works in any direction and defaults to an exact match. VLOOKUP still works fine for this and is more widely compatible with older spreadsheet software, so this guide sticks with it.
Step 3: Calculate Quality Points
Quality points are the weighted value of each course — grade points multiplied by credit hours. This is what makes GPA a weighted average instead of a simple one.
Excel & Google Sheets Formula
=D2 * B2
D2 = Grade Points · B2 = Credit Hours
Paste this into cell E2 and copy it down. A 4.0 (A) in a 3-credit course produces 12.0 quality points. A 3.0 (B) in a 4-credit course also produces 12.0 quality points — same total, different route.
Step 4: Calculate the GPA
Two SUM formulas plus one division. Place these in cells below your data — for a table with courses in rows 2–5:
Total Credit Hours
=SUM(B2:B5)
Total Quality Points
=SUM(E2:E5)
Final GPA Formula
=SUM(E2:E5) / SUM(B2:B5)
Total Quality Points ÷ Total Credit Hours
Divide by total credit hours, not by the number of courses. Those give different answers unless every course happens to carry the same credits. For the manual walkthrough of the formula itself, see How to Calculate GPA.
Full Example: A Filled-In Spreadsheet
Here is what your spreadsheet should look like once all the formulas are in place. Five courses, columns A through E:
| A: Course | B: Credits | C: Grade | D: Grade Points | E: Quality Points |
|---|---|---|---|---|
| Calculus I | 4 | A | 4.0 | 16.0 |
| Biology | 3 | B+ | 3.3 | 9.9 |
| Philosophy | 3 | A− | 3.7 | 11.1 |
| Statistics | 4 | B | 3.0 | 12.0 |
| Art History | 2 | A | 4.0 | 8.0 |
| Totals | 16 | 57.0 |
Calculated GPA
57.0 ÷ 16 = 3.56
Notice that Calculus I and Art History both earned an A, but Calculus contributed 16.0 quality points while Art History contributed only 8.0. The four-credit course has twice the impact. This is why the SUM(E)/SUM(B) formula in Step 4 divides by credits, not by course count.
The SUMPRODUCT Method (One Formula for the Whole GPA)
Everything in Steps 3 and 4 can be replaced with a single formula. SUMPRODUCT multiplies each pair of cells row by row, sums the results, and lets you divide by total credits in the same expression. No intermediate Quality Points column required.
SUMPRODUCT Formula
=SUMPRODUCT(D2:D6, B2:B6) / SUM(B2:B6)
Using the five-course example above.
This returns 57.0 ÷ 16 = 3.56 — same answer as the manual method, calculated in one cell.
Important for excluded courses: if your transcript contains W (withdrawal), P (pass), AU (audit), or NG (no grade reported) rows, either delete those rows entirely or set their credit hours to 0. Their credits will otherwise inflate the denominator and lower your GPA incorrectly.
Formula Reference Sheet
Every formula used in this guide, ready to copy. Cell references assume course data starts in row 2 and runs through row 6.
| Purpose | Formula | Where it goes |
|---|---|---|
| Grade Points (VLOOKUP) | =VLOOKUP(C2, $G$2:$H$13, 2, FALSE) | Column D, every row |
| Quality Points | =D2 * B2 | Column E, every row |
| Total Credit Hours | =SUM(B2:B6) | Any empty cell below data |
| Total Quality Points | =SUM(E2:E6) | Any empty cell below data |
| GPA (two-step) | =SUM(E2:E6) / SUM(B2:B6) | Final GPA cell |
| GPA (SUMPRODUCT, one cell) | =SUMPRODUCT(D2:D6, B2:B6) / SUM(B2:B6) | Final GPA cell |
Adjusting the ranges: if you have more than five courses, extend B2:B6 and E2:E6 (and D2:D6 for SUMPRODUCT) to cover the full range. Copy the formulas in D and E down as far as your data extends.
Target GPA Planner
The spreadsheet tells you your current GPA. The next question — what grades you need next semester to reach a target GPA — has its own interactive tool, so this page doesn’t duplicate it.
🎯 Use the Target GPA Planner
Enter your current cumulative GPA, credits earned, credits remaining, and target GPA. The tool returns the minimum GPA you need in your remaining credits — no spreadsheet required.
If the result the planner gives you is above 4.0 (or 5.0 on a weighted scale), the target isn’t mathematically possible with your current numbers — you may need to retake courses under a grade-replacement policy or adjust your timeline.
Common Spreadsheet Mistakes
Four errors account for nearly every broken GPA spreadsheet.
Missing dollar signs in VLOOKUP
Writing G2:H13 instead of $G$2:$H$13 causes the lookup range to shift as the formula is copied down. The first row will work; every row after it returns wrong values or an error.
Dividing by course count
Using =SUM(E2:E6)/5 instead of /SUM(B2:B6) breaks the weighted average. A 3-credit course and a 4-credit course must not count equally.
Wrong grade-point scale
The conversion table must match your institution’s actual scale. If your school doesn’t award A−, or uses a 4.3 scale for A+, edit the table before the formulas reference it.
Leaving W, P, and AU rows in the ranges
Withdrawals, pass grades, and audits should not count toward GPA. If they stay in the credit-hour SUM, they inflate the denominator and lower the result.
❓Frequently Asked Questions
How do I calculate semester GPA in Google Sheets?
The formulas are the same as in Excel. Add a “Semester” column to your table, then use SUMIFS to total credits and quality points for a specific term. For a single-semester sheet, just include only that term’s courses in the SUM ranges.
Can I calculate cumulative GPA in Excel?
Yes. Include every course from every semester in the same SUM ranges. The GPA formula is identical for cumulative and semester GPA — the only difference is which courses you include. Combine all quality points and all credit hours from every term, then divide once.
How do I add weighted GPA support to the spreadsheet?
Add a “Weight” column. Set 0.0 for regular courses and 1.0 for AP/IB/Honors courses. Then change the Quality Points formula to =(D2 + F2) * B2, where F2 is the weight. On a 5.0 scale, an A in an AP course becomes (4.0 + 1.0) × credits. The Excel template linked above includes this feature pre-built.
Should I use VLOOKUP or SUMPRODUCT?
Both, at different stages. VLOOKUP converts letter grades to grade points — you need it either way, unless you type the grade points manually. SUMPRODUCT replaces the two-step quality-points-then-divide process with a single formula. Most templates use VLOOKUP for conversion and SUMPRODUCT or SUM for the final calculation.
Why is VLOOKUP returning #N/A?
Nearly always one of three things: (1) the letter grade in the cell has a trailing space or different character than in the lookup table (e.g., A- vs A– — an en-dash vs a hyphen); (2) the lookup value has a different case (VLOOKUP is case-insensitive but exact-match; a matches A); (3) the letter grade doesn’t exist in your conversion table at all. Check the conversion table first.
Does this work in LibreOffice or Numbers?
Yes. VLOOKUP and SUMPRODUCT are standard functions supported in both LibreOffice Calc and Apple Numbers with the same syntax. The Excel template linked at the top of this page will also open in LibreOffice, though some formatting may not render exactly the same.
Next Steps
Once your spreadsheet is set up, GPA calculation becomes a one-time task. Change any grade or credit value and the result updates instantly — which is why the spreadsheet method beats manual calculation for tracking your GPA over a full degree.
🚀
Copy Google Sheets Template
Ready in one click
📥
Download Excel Workbook
With 4.0 and 5.0 scale support
Prefer to understand the underlying math before touching a spreadsheet? See How to Calculate GPA for the formula walkthrough with a full worked transcript.
Christian Chinonso is the founder of LearnViaHub, with 6+ years of research experience in international education — including GPA systems, scholarships, student financing, and study-abroad guidance — for students worldwide.