GPA Calculator Spreadsheet: Weighted Semester GPA

GPA Calculator Spreadsheet: Weighted Grades to a Semester GPA, Formula Included

GPA calculator spreadsheet: work out a semester GPA from course grades and credits, use your school's scale, and check the result against its policy.

By · Editorial policy

Published · 7 min read

A GPA calculator spreadsheet with course grades, credits, and quality points laid out for a semester calculation

You checked three grades in the portal, found a fourth in your email, and now the semester average looks off. The trouble may be the credits. If one class is worth four credits and another is worth two, a plain average gives them equal weight. Ultimate Student Planner is a Google Sheets and Excel planner by Cosmo Suite at ultimatestudentplanner.site.

A GPA calculator spreadsheet can make the arithmetic visible. You enter a grade point value for each course, multiply it by the course credits, and divide the total quality points by the included credits. The hard part is choosing the right grade scale and course rules. Those come from your school.

The Short List

  • Use grade points from your registrar, not a scale copied from another campus.
  • Multiply each course's points by its credits, then divide total quality points by included credits.
  • Keep excluded courses, repeats, and pass or fail marks consistent with school policy.

This overview of the Ultimate Student Planner shows the broader semester setup around grades, classes, and due dates.

What does a GPA calculator spreadsheet calculate?

A GPA calculator spreadsheet estimates a grade point average from course grades and credits. Each letter grade maps to a number called grade points. Multiply those points by the course credits to get quality points, then divide the quality-point total by the credits included in the calculation.

The University of Maryland Registrar describes its GPA calculation this way: multiply a course's attempted credits by its quality points, add the quality points, add the included attempted credits, and divide the first total by the second. Its grade table assigns A 4.0, A- 3.7, B+ 3.3, and other values. Those are Maryland's values, not a universal scale.

People use “weighted GPA” in two ways. In a college calculation, credits can weight each course. A four-credit course then counts twice as much as a two-credit course with the same grade points. Some high schools use “weighted GPA” to mean bonus points for honors or advanced classes. That is a separate policy. The worked example below uses credit weighting only.

A sample semester, class by class

The table uses Maryland's published grade points for illustration. The courses and grades are fictional. The arithmetic is simple enough to check on paper before you build a formula.

A sample GPA calculator spreadsheet showing four courses, letter grades, credit hours, and quality points

Course Grade Grade points Credits Quality points
Biology A- 3.7 3 11.1
Chemistry B+ 3.3 4 13.2
History B 3.0 3 9.0
Seminar A 4.0 2 8.0
Total 12 41.3

Divide 41.3 quality points by 12 credits. The unrounded result is 3.4417, or 3.44 when rounded to two decimal places. The four-credit chemistry course contributes more to the average than the two-credit seminar because it carries more credits.

If you averaged the four grade-point values directly, you'd get 3.50. That treats every course equally. A credit-weighted calculation gives a different answer because the courses have different credit values.

Build the GPA formula in Google Sheets or Excel

A spreadsheet layout connects course grade points and credits to quality points and a semester GPA

Put one course per row. For a simple layout, use column A for the course, B for grade points, C for credits, and D for quality points. In D2, multiply B2 by C2, then copy that formula down the course rows.

To calculate the semester GPA directly from the example rows, use:

=SUMPRODUCT(B2:B5,C2:C5)/SUM(C2:C5)

SUMPRODUCT multiplies the matching values in the grade-point and credit ranges, then adds those products. SUM adds the credits. Google Sheets and Excel both document this function for corresponding ranges. Keep the two ranges the same size; a mismatched end row can return an error in Excel.

For a longer course list, add an “Include?” column with 1 for courses counted in this estimate and 0 for the rest. If that column is D, use =SUMPRODUCT(B2:B10,C2:C10,D2:D10)/SUMPRODUCT(C2:C10,D2:D10). The first calculation includes quality points only when the flag is 1. The second includes those credits under the same condition. Make sure at least one included course has credits, or the formula will divide by zero.

Write a reason beside every 0, such as “pass mark” or “not graded yet,” and compare it with your school's policy. A blank grade entered as zero can lower the result by accident. Leaving the course out of both the points and credit totals keeps the estimate from treating an unfinished course like a failing grade.

This version assumes every listed course belongs in the calculation. To leave one out, remove it from both ranges or use an include column like the one above. For example, the University of Maryland says its GPA excludes several marks such as pass, satisfactory, withdrawal, and no grade reported. Its repeat-course rules can also affect the result. Other schools can handle those cases differently.

When you have a grade-point lookup table, add a grade column and use a lookup formula to return the school's value for each letter. Keep the scale in its own small table so you can check it against the current catalog. A direct number in the example is easier to inspect, while a lookup is easier to maintain across many classes.

Use a student planner spreadsheet that keeps grades beside each class if your grade check is part of a larger semester plan.

Use your school's grade scale

The formula only works as well as its inputs. Start with your registrar's published grade table or academic catalog. Check whether plus and minus grades use separate values, and how the policy treats repeats, incomplete grades, pass or fail courses, withdrawals, transfer work, and zero-credit courses.

For example, Maryland lists an A- as 3.7 and a B+ as 3.3. Berkeley's registrar describes different treatment for specific marks, including how some marks enter or stay out of grade-point computations. Those examples show why a spreadsheet template should not label one scale “the college scale.” The Berkeley grade definitions are one example of a registrar's own table.

If your school publishes a separate policy for repeated courses, keep that beside your lookup table. Some policies replace an earlier grade in one calculation and keep both attempts in another. Applications can also recalculate coursework under their own rules. A class record can therefore produce more than one valid GPA, depending on the question being asked. Name the version at the top of the sheet, such as “current term estimate,” so it is not mistaken for a cumulative or application GPA.

Enter the school's values into a two-column lookup table: letter grade in one column, points in the next. Keep the values exact. If your school uses A+ as 4.0, don't change it to 4.3 unless its policy says so. If two schools use the same letter but assign different points, the calculation changes.

At high schools, ask whether the GPA is unweighted or includes course-level additions. A course bonus can change the points before the credits are applied. Your counselor or school handbook can tell you which version appears on your transcript.

How the Ultimate Student Planner handles this

The Ultimate Student Planner includes a Grades tab for weighted items, a running grade for each class, and a semester GPA on your own grading scale. It comes as a Google Sheets and Excel planner with sample and clean copies. The tab helps you keep course grades in the same semester file as your class schedule and study plan.

An illustrated student planner with a Grades tab connected to class and semester planning pages

The planner does not know your registrar's treatment of repeated courses, transfer credits, or special marks. Check those policies and enter the appropriate scale before relying on the estimate. The student planner overview explains the file and its included tabs.

Keep the estimate with your semester grade notes. For school-specific recognition rules, see this guide to dean's list requirements. Requirements differ by institution, so check your school's current page.

Check the result before you use it

Before you use the number, check these cells:

  1. Compare the grade-point lookup with your current school policy.
  2. Confirm that each course is included or excluded under the same policy.
  3. Check that grade-point and credit ranges begin and end on the same rows.
  4. Recalculate the sample by hand: 41.3 divided by 12 is about 3.44.
  5. Keep semester GPA separate from cumulative GPA unless you've included all eligible terms.

The result is an estimate for planning. Your registrar determines the GPA shown on your transcript. If a repeated course or special mark could change the answer, ask your advisor or registrar which rule applies. Recalculate after a grade or credit value changes.

For another way to keep class priorities visible through the term, use the study plan template guide. The template can help organize study sessions; this GPA calculation remains a separate grade estimate.

Sources checked November 12, 2026

Frequently asked questions

How do I calculate GPA in a spreadsheet?

Use the grade points your school assigns, multiply each course's points by its credits, add the quality points, and divide by included credits. In Sheets or Excel, SUMPRODUCT multiplies matching grade-point and credit ranges before SUM totals the credits.

Does GPA use credits as weights?

Many colleges divide quality points by attempted credits, so a course with more credits has more effect. Check your registrar's rules to see which courses and credits count.

Is a weighted GPA the same as a credit-weighted GPA?

No. In a college GPA, credits determine how much each course counts. Some high schools add points for honors or advanced courses. Use the definition and scale in your school's policy.

Can I use a 4.0 grade scale for every college?

No. Grade-point values, plus and minus grades, repeats, pass or fail marks, and excluded courses vary. Copy your own school's scale and rules.

Do pass or fail classes count in GPA?

It depends on the institution and course. Some pass marks earn credits without grade points. Check your registrar's policy before including one in the calculation.

What is the difference between semester GPA and cumulative GPA?

A semester GPA covers courses counted for one term. A cumulative GPA combines eligible coursework across terms, following the school's rules for repeats, transfers, and exclusions.

Can Google Sheets and Excel calculate GPA?

Yes. Both support SUMPRODUCT to multiply corresponding values and add the results. The formula gives an estimate; your school sets the official scale and transcript GPA.

Sources

  1. University of Maryland Registrar, GPA Calculation
  2. Google Docs Editors Help, SUMPRODUCT
  3. Microsoft Support, SUMPRODUCT function
  4. UC Berkeley Registrar, Grade Definitions

Ultimate Student Planner

Ready for the Ultimate Student Planner?

Your classes, assignments and due dates in one file. Google Sheets + Excel, your own file, pay once.

Get instant access
Ultimate Student Planner