In this article:

Free GPA Calculator in Google Sheets Template (2024 Update)

GPA Calculator Google Sheets Template

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

google sheets tax calculator

Select File > Make a copy.

google sheets income tax calculator

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.

gpa calculator google sheets template

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."

gpa calculator spreadsheet google sheets

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.

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started