Try the sheet here, on the example
The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.
Example from the sheet
| Show group | Show instructor | Leave both blank to see every session. Pick a group, an instructor or both to see one week. | |||
|---|---|---|---|---|---|
| Time | Mon | Tue | Wed | Thu | Fri |
| 0 | |||||
| 0 | |||||
| 0 | MATH 201 | PSYC 101 | MATH 201 | PSYC 101 | |
| 0 | MATH 201 | PSYC 101 | MATH 201 | PSYC 101 | |
| 0 | MATH 201 | PSYC 101 | MATH 201 | PSYC 101 | |
| 0 | ENGL 101 | ENGL 101 | |||
| 0 | ENGL 101 | CS 110 | 2 sessions | CS 110 | |
| 0 | ENGL 101 | CS 110 | 2 sessions | CS 110 | |
| 1 | CS 110 | ART 105 | CS 110 | ||
| 1 | |||||
| 1 | CHEM 220 | CHEM 220 | CHEM 220L | ||
| 1 | CHEM 220 | CHEM 220 | CHEM 220L | ||
| 1 | CHEM 220 | HIST 150 | CHEM 220 | HIST 150 | CHEM 220L |
| 1 | HIST 150 | HIST 150 | CHEM 220L | ||
| 1 | HIST 150 | HIST 150 | CHEM 220L | ||
| 1 | CHEM 220L | ||||
| 1 | |||||
| 1 | |||||
| 1 | |||||
| 1 | |||||
| 1 | |||||
| 1 | |||||
| 1 | |||||
| 1 | |||||
| 1 | |||||
| 1 |
Example from the “Weekly Grid” tab, with the numbers and formulas that are in the file.
What is inside
- Weekly Grid: The timetable itself: times down the side, Monday to Sunday across the top, each session coloured by course. Pick a group or an instructor at the top to see only their week. Print it on one landscape page.
- Sessions: One row per weekly meeting: course, day, start, end, and an optional room and group. A Check column says Group clash, Room double-booked or Instructor double-booked, and flags missing times. Room for 200 sessions.
- Courses: Your list of courses with title, instructor, usual room and the hours a week each should get. It shows how many sessions and hours are scheduled and marks a course Short, OK or Over.
- Summary: Sessions and hours per week, sessions with a problem, the busiest day, weekdays with no class, the earliest start and latest finish, with two charts: class hours per day, and scheduled against required hours by course.
- Settings: School or student name, term, the time your day starts and how many minutes one grid row covers (15, 30 or 60).
The file opens on a start tab (“Start here”) that explains how to use it.
What makes it different
Most free class schedule templates are a blank grid you colour by hand, so a clash only shows up when you notice it. Here you type the times once and the grid fills itself, and the sheet checks every session against the others for the same group, room and instructor. In the sample, a college student's week adds up to 20.00 hours over 14 sessions, and the two sessions that overlap on Wednesday are flagged so you can see the warning work.
How do I make a class schedule in Excel?
List your courses first, with the room and instructor for each. Then add a row for every weekly meeting with its day, start time and end time. In this template the grid is built from those rows, so you never move a block by hand: change a time on the Sessions sheet and the timetable updates.
Choose how fine the grid is on Settings. A 30-minute row suits most colleges; 15 minutes fits a short break between periods, and 60 minutes keeps a school day compact. A class that runs 9:00 to 10:15 fills the 9:00, 9:30 and 10:00 rows.
How do I avoid clashes in a class schedule?
Two things go wrong in a timetable: the same group is booked into two places at once, or a room or teacher is used twice. The Check column looks at each session against all the others on the same day and names the problem. In the sample, ENGL 101 on Wednesday runs 10:30 to 11:45 and ART 105 starts at 11:00, so both rows read Group clash and the grid shows 2 sessions in red.
Sessions of different groups at the same time are not a clash unless they share a room or an instructor, so a school can run Year 7A and Year 7B in parallel. Leave the Group column blank for a personal schedule and every overlap is flagged.
Can I make a timetable for a whole school or just for me?
Both. For yourself, leave Group blank and the sheet treats everything as one schedule. For a school, type a group name such as Year 7A on each session, fill the instructor on the course, and use the Show group and Show instructor boxes on the Weekly Grid to print one timetable per class or per teacher. For a plan of your exams as well, see the exam schedule template, and for what to do between classes the weekly study routine.
How to use it
- On Settings type the school or student name, the term, the time your day starts and the length of one timetable row (15, 30 or 60 minutes).
- On Courses list each course with its title, instructor, usual room and the hours a week it should get.
- On Sessions add one row for every weekly meeting: pick the course and the day, then type the start and end time. Leave Room blank to use the course room.
- A school with several classes can fill the Group column (Year 7A, Year 7B). Leave it blank for a single personal schedule.
- The Check column tells you when two sessions of the same group overlap, or when a room or an instructor is booked twice at the same time.
- Open Weekly Grid to see and print the timetable. Pick a group or an instructor at the top to see only their week.
- Open Summary for the hours per day, hours per course and the courses that have too few or too many hours.
Before you start:
- Capacity: 30 courses and 200 weekly sessions.
- Type times as 9:00 or 14:30. The grid starts at the time you set on Settings and shows 26 rows of the length you choose.
- A session fills every grid row it touches. If it starts at 9:10, it appears from the 9:00 row.
- The sample is a college student with one deliberate clash (ART 105 overlaps ENGL 101 on Wednesday) so you can see the warnings work. Delete that row to clear them.
- Two sessions of different groups at the same time are fine. They are only a problem if they share a room or an instructor.
- The Summary charts show the first 12 courses on your list.
Still running this on Excel?
This sheet holds the numbers of one class, typed in by one teacher. In the School Performance Management Platform, each student's grades, attendance and teacher notes come together, and reports reach parents.
| In this sheet | In School Performance Management Platform |
|---|---|
| Every teacher has a sheet, and the administration collects the files. | One dashboard for students, teachers and classes, with exam results tracking and a comparison of performance across terms. |
| A student's decline shows up in the end-of-term result. | AI analyzes the student's grades, attendance and teacher notes, warns early about a possible decline, and suggests a development plan that the teacher decides on. |
| The parent learns about the problem late. | Regular reports to parents on the student's level, teacher notes and the attendance record, plus direct contact with the school through the app. |
| Attendance lives in a notebook or a sheet per class. | Attendance, absence and lateness are recorded for each student and turned into attendance reports and rates that the administration follows for each class. |
Frequently asked questions
Is this class schedule template free?
Yes. Download it, change it and share it. There is nothing to sign up for to open the file.
Does it work in Google Sheets and LibreOffice?
Yes. It uses ordinary formulas such as COUNTIFS, SUMIFS and INDEX, so it works in Excel 2016 and later, LibreOffice and Google Sheets.
How many classes can it hold?
30 courses and 200 weekly sessions. The grid shows 26 rows of the length you choose, for example 08:00 to 21:00 with 30-minute rows.
Why does the grid say 2 sessions?
Two sessions in the view overlap at that time. Look at the Check column on the Sessions sheet to see which rows and why, then change one time or day. If you filter by group or instructor, only their sessions are counted.
Can I show Saturday and Sunday?
Yes. The grid has all seven days. A day with no sessions stays empty, so a Monday to Friday week looks like a Monday to Friday week.
Is the template free?
Yes, with no sign-up and no email address. Use it, edit it and share it as you like.
Does it work in Google Sheets and on mobile?
The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.
What is the difference between the white and the gray cells?
You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.
Can I use the sheet from an AI assistant?
Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html
All the templates in this group: Excel templates for teachers: gradebook, lesson planning and follow-up
More free templates for: Schools and students
More free templates
- Gradebook Template for Excel (Weighted Categories, Letter Grades)
- Quran Hifz Tracker Template for Excel (Sabaq, Sabqi, Manzil)
- College Application Tracker Spreadsheet for Excel (Deadlines, Checklist, Aid)
- GPA Calculator for Excel (Weighted and Unweighted, by Term)
- Lesson Plan Template for Excel with Curriculum Tracker
- Donation Tracker Spreadsheet for Nonprofits (Excel)
- Expiry Date Tracker for Excel (Inventory)
- HOA Dues Tracking Spreadsheet for Excel
- HOA Budget Template for Excel
- Car Rental Booking Tracker for Excel
- Employee Leave Tracker Template for Excel