The Best Free Spreadsheets For Teachers [Updated]
by TeachThought Staff
Summary: These spreadsheets for teachers include spreadsheets to calculate grades, spreadsheets to track attendance, a spreadsheet for class schedules, and more.
Spreadsheets aren’t exactly the most progressive, compelling, innovative, or gee-whiz-cool teaching resources around, but the right spreadsheet and template at the right time can come in handy. That they’re free, usable across Microsoft Excel, Google Sheets, Apple Numbers, and other open-source spreadsheet platforms doesn’t hurt.
So below we’ve gathered 19 of the best–and free–‘general education’ spreadsheet templates for teachers. We’ve linked to the Microsoft Excel file in each case (Still the standard for spreadsheet creation and function), but they can be exported to other platforms (often with a few font substitutions or other minor changes).
See also 104 Organizations That Offer Student Discounts
For more templates, resources. frameworks, models, and more, follow TeachThought on Pinterest.
19 Free Excel Spreadsheet Templates For Teachers
1. Teacher’s Gradebook Template Spreadsheet (Points-Based)
Teachers can track students’ grades with this accessible grade book template. Just enter each assignment, quiz, and test along with the total available points for each, and as you enter each student’s scores the average, letter grade, and GPA will be calculated for you. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.
2. Teacher’s Gradebook Template Spreadsheet (Percentage-Based)
Track your students’ grades with this accessible grade book based on percentages. Record each assignment, quiz, and test along with its percentage of the total grade, and as you enter student scores, the letter grade and GPA will be calculated automatically. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.
3. Weekly Attendance Record Spreadsheet
Track weekly attendance for up to 30 students with this report template. Present, tardy, unexcused, and excused are listed as options for each day of the week. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.
4. A Back-To-School Checklist Spreadsheet
Exactly what it sounds like–a back-to-school checklist useful for teachers, parents, students, etc. Simple and shareable, to boot. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes. (We included two alternatives below if the first doesn’t fit your needs.)
Download Alternative Back-To-School Checklist Template
Download Yet Another Alternative Back-To-School Checklist Template
5. Student Randomizer
Conquer classroom management with this student randomizer. This accessible template is fully customizable to fit your school’s needs. Includes instructions.
6. Group Assignment Task List Spreadsheet
Set goals, list group members, assign tasks, and more–get everyone on the same page for group tasks, projects, etc. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.
7. Ice Breakers Collection & Organizing Template
Just a simple spreadsheet for organizing ice breakers, but really could be used to organize class discussion strategies, team-building games, etc. Export it to Google Sheets, print, or use locally and track changes.
8. Multiplication Table (1-10) Spreadsheet
This is fairly narrow in its usefulness (for younger students learning very early multiplication), but it does exactly what it says it does. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.
9. School Team/Club Budget Spreadsheet
Set your club’s budget or goal for the year and track revenue and expenses. See at a glance which revenue streams and costs are high or low with this visually enhanced accessible template. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.
10. Student Hall Pass Spreadsheet
Teachers can use this template to log when students use the hall pass to leave the classroom. This spreadsheet keeps track of student name, destination, departure time, and return time. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.
11. Class Roster Template Spreadsheet
Teachers can use this accessible template to keep track of all the pertinent information about their students including emergency contact and medical info. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.
12. Homeschooling Progress Record Template
While not for K-12 in-school teachers, this spreadsheet template tracks a student’s homeschooling progress with this accessible record template composed of nine subjects with room for five assignments each. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.
13. General Semester Overview & Course List Template
Stay on top of your class schedule and assignments with this functional semester calendar. This four-month calendar highlights due dates in an at-a-glance view and more.
Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.
14. Standard Graph Paper Template
Print out your own graph paper with this accessible template for Excel. Useful for graphing equations, drawing charts, or plotting layouts.
15. Library Book Checkout Sheet
More for librarians and elementary school classrooms where there’s an in-class library of books, this template allows you to keep track of books or other resources from your lending library with this accessible checkout sheet.
List the borrower’s name, contact information, book title, date borrowed, and date returned. The number of days until the book is returned is automatically calculated, and a red warning displays for books about to become overdue. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.
16. Teaching Idea Planner
Plan a classroom project from start to finish with this accessible template by listing the steps you need to take, which tasks are assigned to various team members, task status, and project resources. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.
17. Class Schedule Spreadsheet Template
Keep your weekly class schedule up to date with this handy accessible template. Enter the start time and time interval for your schedule, and time slots will be created automatically. Color code as desired, and even block out time to study.
18. A General Household Monthly Budget Spreadsheet
Teachers have lives and living is expensive. With this Microsoft Excel spreadsheet template, you can track monthly income and expenses for your household with this accessible budget template, which allows for projected and actual amounts. Enter a category for each expense and use the handy filtering buttons to focus in on specific types of expenses. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.
19. Another Monthly Budget Spreadsheet Template
Compare your estimated monthly income and expenses with the actual values using this accessible budget template. The differences, as well as your monthly balance, are calculated automatically.
20+ Excel Spreadsheet Templates For Teachers