GPA Calculator Spreadsheet: Term & Cumulative GPA + Target Planner

Work out your term and cumulative GPA, and see what average you'd need on your remaining credits to reach a target. Uses a 4.0 letter scale by default, which you can edit to match your school.

★ WHAT YOU GET

• 1 spreadsheet (.xlsx) with 5 tabs: Start here, Summary, Grade scale, Courses (150 rows), Target planner

• Editable grade scale (A+ to F, plus P / W / I that don't count). An unknown grade is flagged

• Courses: term, course, credits, grade, quality points, with an override for courses that shouldn't count

• Summary: credits, quality points and GPA for up to 12 terms, plus running cumulative GPA

• Target planner: target GPA + planned credits = the average you need (with a note if it isn't reachable)

★ COMPATIBILITY

Made for Google Sheets (free Google account; upload the .xlsx to Google Drive, then open it with Google Sheets), Microsoft Excel 2010 or later, and LibreOffice Calc. Formulas were checked for Google Sheets and Excel compatibility (standard functions only, no macros, no add-ins) and tested in LibreOffice Calc. Unzip the download first (double-click on most computers). Best used on a computer or tablet. Enter dates as real dates (e.g. 3/15/2027 or 15/03/2027).

★ GOOD TO KNOW

• Schools calculate GPA differently (repeats, weighting, plus/minus rules). Your official transcript is the final word.

• Example courses are included. Delete them before you start.

★ Personal use only: for your own studies. Please don't share, resell or redistribute the files.

★ Digital download: nothing physical is shipped. You get one .zip file; unzip it to get the files.

★ 14-day promise: if a file is faulty or not as described, contact me within 14 days and I'll fix it or refund you.

Made with the help of AI tools (drafting text, layouts and formulas); I chose the content and reviewed and edited every file.