19 Free Spreadsheets For Teachers [Updated]

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

free excel 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.

Download

gradebook template

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.

Download

your school name

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.

back to school checklist

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

Download Alternative Back-To-School Checklist Template

Download Yet Another Alternative Back-To-School Checklist Template

student randomizer

5. Student Randomizer

Conquer classroom management with this student randomizer. This accessible template is fully customizable to fit your school’s needs. Includes instructions.

Download

group assignment to-do list

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.

Download

conversational ice breaker tracker

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.

Download

multiplication table

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.

Download

academic club budget

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.

Download

hall pass history

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.

graphic design institute class roster

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.

Download

set benchmarks

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.

Download

class list

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.

Download

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.

Download

library book checkout sheet

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.

Download

step by step idea planner

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.

Download

my class schedule fall semester

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.

Download

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.

Download

personal monthly budget

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.

Download

20+ Excel Spreadsheet Templates For Teachers