Free for teachers
Gradebook template generator
Tell Sparky how many classes you teach and how you weight grades. Sparky builds the gradebook as a spreadsheet with the formulas already in it, ready to download as an Excel or CSV file.
Used by 250,000+ teachers, and built to FERPA, COPPA and GDPR standards.
How the gradebook template generator works
Say what you teach
Type one line, such as "a gradebook for my 4 class periods". Add how you weight homework, quizzes and tests, or attach a roster or an old gradebook as an Excel or CSV file.
Check the sheet beside the chat
The gradebook opens in a spreadsheet next to the chat, with a tab for each class. Type in scores and the averages update. Ask for changes in plain words, like "add a column for Quiz 4".
Download it
Press Download for an Excel file with the formulas still working, or a CSV file of the values. Or press Open in Google Sheets to save a copy to your Google Drive.
What you can put in a gradebook
Weighted averages
Give the weights, such as homework 20%, quizzes 30% and tests 50%, and Sparky writes the formula that averages each student's grade.
Letter grades
A column that turns each average into a letter on your school's grading scale.
A tab for each class
One tab per period or subject, each with its own students and assignments. Add, rename or reorder tabs yourself.
Formulas you can check
Click a cell to see its formula in the formula bar. Every average and letter grade is a formula you can read and change.
Your own roster or gradebook
Attach an Excel or CSV file, and Sparky makes a new sheet from it with its tabs and formulas.
Changes in plain words
Ask Sparky to add a column, change a weight or add a class average row. Sparky edits the same sheet and keeps the earlier version.
Ways teachers use it
Standards-based grading
A row per student and a column per standard, with each score from 1 to 4.
Missing work
A list of assignments by student, with a count of what is missing and the date each one was due.
Grade calculator
A grading chart like an EZ Grader: each row shows a number wrong with its percent and letter grade.
Last year's gradebook
Attach the spreadsheet you already use and ask Sparky to fix broken formulas or set it up for a new term.
Data privacy
Safe to use with student work
What happens to the files you upload and what your students write in Flint.
Not used to train AI
Student data in Flint is never used to train AI models.
Not shared
Flint does not share student data, or any other user data, with third parties.
Kept separate
Each school's data is kept apart from every other school's, and the AI providers Flint runs on can't reach it.
Signed agreements, on request
Flint signs a data processing agreement with any school that needs one, written to US state law and EU GDPR.
What teachers say about Flint
"Flint AI has become essential to my daily routine. I rely on it for differentiating instruction, writing comments, planning lessons, managing recess duty schedules, and developing rubrics."
Beonka Caldwell
4th Grade Teacher at The Kinkaid School
"Flint makes it easier for teachers to personalize lessons and save time on routine tasks. Students get to use AI more as a study partner - not just for answers, but for guiding their thinking and building confidence."
Somkid Leewan
Educational Technology Specialist
"By partnering with AI for aspects of grading, I can provide richer, more personalized feedback while maintaining consistent standards across all submissions, giving students the thorough attention and detailed guidance their work deserves."
Christa Forster
English Lit and Composition Teacher at The Kinkaid School
Frequently asked questions
Is there a free gradebook template?
Yes. Sparky makes a gradebook for your classes for free, and the Excel file you download is yours to keep.
How do I create a gradebook in Excel?
Ask Sparky for one, then press Download and choose Excel (.xlsx). The averages and letter grades stay formulas in the file, so they update in Excel when you type in new scores. Choose CSV (.csv) instead for the values without formulas, with one file per tab.
How do I build a gradebook in Google Sheets?
Press Open in Google Sheets in Flint's spreadsheet panel. Flint saves a copy to your Google Drive and opens it in Google Sheets.
Can I start from my roster or the gradebook I already have?
Yes. Attach an Excel (.xlsx) or CSV file in the chat and ask Sparky to work from it. Sparky makes a new Flint spreadsheet from your file, with its tabs and formulas, and adds to that. For a Google Sheet, download it as an Excel file first: a Sheet brought in from Google Drive arrives as a PDF, which Sparky can read but can't turn into a spreadsheet.
Can I change the gradebook after Sparky makes it?
Yes. Type scores and formulas straight into the cells, add rows, columns and tabs, or ask Sparky in the chat, such as "add a column for Quiz 4". Your typing saves as you go, and each change Sparky makes saves a new version and keeps the old one.
Can Sparky make a worksheet instead of a spreadsheet?
Yes. For a printable page of questions for students, use the AI worksheet generator. Ask for a spreadsheet when you need rows and columns that add up, such as grades, a grading chart or a missing work list.
Doesn't Flint already have a gradebook?
Each class in Flint has a Gradebook that fills in from graded Flint activities, with grade weights and a CSV download. Make a spreadsheet gradebook for everything else: paper tests, labs and work graded outside Flint.
Explore more tools
See all tools ->
AI worksheet grader
Attach a student's worksheet as a photo or a file. Sparky marks each answer, explains each mistake and drafts a score for you to check.
AI essay grader
Share a student's essay and your rubric. Sparky comments on the sentences that matter and drafts a score for each row of your rubric.
Report card comment generator
Give Sparky a few words about each student, or your gradebook export, and get a report card comment for each one.
