# Free GPA Calculator in Google Sheets Template (2024 Update)

May 8, 2024

## GPA Calculator Google Sheets Template

You can get a copy of our free GPA calculator template in Google Sheets here.

Select File > Make a copy.

## GPA Calculator in Google Sheets

A GPA (Grade Point Average) Calculator in Google Sheets helps calculate a student's GPA using grades and course credit hours. The calculator then uses these inputs to compute the GPA by multiplying each course's grade points by its credit hours, summing these, and dividing by the total credit hours.

## Creating a GPA Calculator in Google Sheets

Follow the steps below to create a GPA calculator template in Google Sheets.

### 1. Input Column Headings for Course Data and Calculations

In the first row of your spreadsheet, type these headings into columns A through E: "Course Name" in A1, "Credit Hours" in B1, "Grade Received" in C1, "Grade Points" in D1, and "Weighted Points" in E1. These headings will organize your data and calculation results.

### 2. Enter Your Course Information in Designated Columns

Start filling in your course details row by row below the headings. Include the name of each course under "Course Name," the number of credit hours for the course under "Credit Hours," and the grade you received in "Grade Received."

### 3. Construct a Grade Conversion Table on a New Sheet

In your Google Sheets document, add a new sheet by clicking the "+" at the bottom. On this new sheet, create a table that converts letter grades to grade points (e.g., A=4.0, B=3.0). Label one column as "Grade" and the adjacent column as "Grade Points." Fill in the table with the appropriate values.

### 4. Implement VLOOKUP to Convert Letter Grades to Grade Points

Go back to your main "GPA Calculator" sheet. In the "Grade Points" column (D), use the VLOOKUP function to find the numeric grade point for each letter grade based on your conversion table. The formula in D2 would look something like =VLOOKUP(C2, Sheet2!\$A\$1:\$B\$5, 2, FALSE), assuming "Sheet2" is where your conversion table is.

Drag the fill handle down to apply this formula to all rows with course data.

### 5. Calculate Each Course's Weighted Points by Multiplying Credit Hours and Grade Points

In the "Weighted Points" column (E), calculate the weighted points for each course by multiplying the "Credit Hours" by the "Grade Points" for that course. The formula in E2 would be =B2*D2.

Drag this formula down the column to apply it to all your courses.

### 6. Total Your Credit Hours and Weighted Points at the List's End

At the bottom of the "Credit Hours" column (B) and the "Weighted Points" column (E), use the SUM function to total these values. For example, if your courses are listed through row 9, you would place =SUM(B2:B9) in B10 and =SUM(E2:E9) in E10.

### 7. Compute Your GPA by Dividing the Sum of Weighted Points by the Sum of Credit Hours

Divide the sum of weighted points by the sum of credit hours to find your GPA: `=SUM(E2:E9)/SUM(B2:B9.`

`‍`Place this formula below your totals in the GPA row.

### 8. Ensure Your GPA Displays with Two Decimal Places

Click on the cell containing your GPA calculation. Go to "Format" > "Number" > "Number" in the menu to set the cell to display numbers with two decimal places.

This makes your GPA easier to read and understand.

We hope that you now have a better understanding of how to create a GPA calculator in Google Sheets and use our GPA calculator Google Sheets template. If you enjoyed this article, you might also like our article on how to set up Google Sheets query coalesce or our article on how to copy and paste a drawing in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.