FREE EXCEL TEMPLATE
Gradebook
template for Excel.
Enter points, get grades. Weight homework, quizzes, projects and exams the way your syllabus does, and the gradebook works out every student's percentage, letter grade and missing work.
Free · No sign-up · Download blank XLSX · Example XLSX
- Weighted categories
- Letter grades
- Missing-work flags
INSIDE THE WORKBOOK
Every sheet
has one job.
Mint cells are where you type. White cells calculate. Instructions inside the file explain each field.
- Gradebook
- Up to 20 assignments with category, points and date; up to 40 students with category percentages, overall, letter grade and missing count.
- Summary
- Class average, grade distribution, average by category and assignment, and the students who need attention.
- Setup
- Class details, category weights and your grading scale.
WHY IT HELPS
Built around
the real task.
Weighted category grades, letter grades and missing-work flags for a class.
Weights that match your syllabus
Give each category a weight. Overall grades use only categories that have marks so far, so early grades are not distorted.
Blank is not zero
Leave a cell empty for work not yet in: it is shaded once the due date passes and counted as missing, but it does not pull the grade down.
The class at a glance
See the distribution of letter grades, averages by assignment and the five students with the lowest overall grade.
GETTING STARTED
Three steps
to your own version.
Open the example to see how it works, or start blank with your own records.
Set up
Enter the class, category weights and the grading scale on Setup.
Add assignments
Fill in the name, category, maximum points and date for each assignment.
Enter marks
Type points earned for each student. Grades and the summary update instantly.
QUESTIONS
Before you begin.
Short answers about how the workbook behaves.
What if my weights do not add up to 100%?
The overall grade divides by the weights in use, so it still works. Setup shows the total so you can check it.
How do I record work that will never be handed in?
Enter 0. A blank means not submitted yet; 0 means it counts.
Can I change the letter grade cut-offs?
Yes. Edit the minimum percentage for each letter on Setup.
Is it safe to store student data?
The file stays on your device while you edit in ExcelCraft. Store it according to your school's data policy.
How do I keep my changes?
Use Download XLSX or PDF in the editor before closing the tab. Nothing is saved to a server automatically, and your workbook never leaves your device while you edit.
Will it work in Excel and Google Sheets?
The files use standard XLSX formulas without macros, pivot tables or external links. They are checked with the ExcelCraft engine; compatibility with every Excel or Google Sheets version is not guaranteed. Review formulas, charts and formatting in your app before relying on important figures.
Can I change the currency?
Amounts use a $ number format. Change the cell format to your currency; the formulas do not convert between currencies.
EXCELCRAFT PRO · EARLY ACCESS
Need the whole workflow?
Try Pro.
Pro workbooks cover whole workflows: purchasing to receiving, journal to balance sheet, tasks to portfolio health. Pro is planned to include AI credits for editing through chat. Pro downloads and the AI assistant are not available yet.
- Every Pro workbook as it is released, with dashboards, checks and instructions
- Planned: monthly AI credits for editing spreadsheets through chat
- Planned launch pricing; final terms are not set
$8/ month
or $60 / year · planned launch price
No payment today. We email you once when Pro opens.
How Pro worksRELATED
Works well with.
Separate workbooks for neighbouring jobs. Records do not sync between files.
Your workbook stays in this browser while you edit. Use Download in the editor to keep your work, and review important figures in the saved copy. How local files are handled.
Original ExcelCraft workbook design, formulas and fictional sample data · CC0. Management tool only; not tax, legal or accounting advice.