Free Excel template · Excel for students

Free Excel GPA calculator template

For high school and college students who want to know their GPA now and what it takes to reach a goal. Type each class, its credits and your letter grade; the template looks up the grade points from a scale you can edit, works out this term's GPA weighted by credits, combines it with your previous GPA, and tells you the term GPA you would need next term to hit your target.

cellwise-gpa-calculator-template.xlsxExcel workbook · 4.4 KB · works in Excel, Google Sheets, Numbers and LibreOffice · no signup

Download free template

Preview and try it

This is the template's sheet, calculated by the same engine as the Cellwise app. Change any number to see the formulas react before you download.

	A	B	C	D	E	G	H
1	GPA calculator
2
3	Course	Credits	Grade	Points	Quality points	Grade	Points
4	Biology 101	4	B+	3.3	13.2	A+	4
5	Calculus I	4	B	3	12	A	4
6	English Composition	3	A-	3.7	11.1	A-	3.7
7	Intro to Sociology	3	A	4	12	B+	3.3
8	Spanish II	3	B+	3.3	9.9	B	3
9	First-Year Seminar	1	P	Not counted		B-	2.7
10						C+	2.3
11						C	2
12						C-	1.7
13	Credits that count toward GPA	17				D+	1.3
14	Quality points	58.2				D	1
15	Term GPA	3.42				F	0
16
17	GPA credits before this term	45				Edit this scale to match your school. Grades not on the scale (P, W, I) show Not counted and are left out of GPA.
18	GPA before this term	3.21
19	Cumulative GPA	3.27
20

How the formulas work

Grade points from your school's scale

D4=IF(C4="","",IFNA(XLOOKUP(C4,$G$4:$G$15,$H$4:$H$15),"Not counted"))

XLOOKUP finds the letter in the scale (G4:G15) and returns its points. A grade that is not on the scale, like P for pass or W for withdrawn, shows Not counted and is left out of GPA, which is how most schools treat them. If a real letter shows Not counted, check for a typo or a stray space.

Credits that count, and quality points

B13=SUMIF(D4:D11,">=0",B4:B11)

Only rows with a number in Points count toward GPA credits, so the 1-credit pass/fail seminar is skipped. Quality points in column E are credits times points, and B14 adds them up.

Term GPA weighted by credits

B15=IF(B13=0,"",ROUND(B14/B13,2))

Quality points divided by GPA credits. In the sample, 58.2 quality points over 17 credits gives 3.42. Averaging the points column instead would treat a 1-credit class the same as a 4-credit one.

Cumulative GPA

B19=IF(B17+B13=0,"",ROUND((B17*B18+B14)/(B17+B13),2))

Your earlier GPA times its credits gives your earlier quality points. Add this term's, then divide by all credits. Use the GPA credits from your transcript, not total credits earned, because pass/fail and transfer credits often do not count toward GPA.

The GPA you need next term

B23=ROUND((B21*(B17+B13+B22)-(B17*B18+B14))/B22,2)

Target GPA times all the credits you will have after next term, minus the quality points you already have, divided by next term's credits. The sample needs 3.94 to move a 3.27 cumulative GPA up to 3.40 with 15 credits. A24 tells you if that is above the top of your scale.

Make it yours

Your school's scale may differ: some give A+ 4.3, some have no plus or minus grades, and many high schools add points for honors, AP or IB classes. Edit G4:H15 to match your handbook.
Weighted high school GPA: add a column for the bonus (for example 0.5 or 1 for AP, if your school does that) and add it to Points before multiplying by credits.
Retaken a course? Schools handle it differently (replace, average or count both). Enter it the way your registrar does, usually only the newer grade.
This shows an estimate. Your official GPA is the one on your transcript.

FAQ

How do I calculate GPA in Excel?

Look up the grade points for each letter, multiply by the credits, add those up and divide by the total credits: =SUMPRODUCT(credits,points)/SUM(credits). This template does every step, including skipping pass/fail classes.

How do I calculate cumulative GPA?

Multiply your old GPA by its credits to get old quality points, add this term's quality points, and divide by the old credits plus this term's credits. Do not average the two GPAs unless both terms had exactly the same credits.

Why is my GPA different from my school's?

Usually the scale (A+ and minus grades), how repeated or pass/fail courses are handled, or extra weight for honors and AP classes. Change the scale in G4:H15 and the credits to match your school's rules.

Functions used

Related guides

More free templates

Updated November 2, 2026