School & College Timetable Builder (Pro) - Google Sheets + Excel with Clash Detection, Teacher/Class/Room Views & Substitution Planner
Advanced timetable builder for Google Sheets & Excel that works with any school or college format. Build one master schedule and get auto class/teacher/room grids, 3-way clash detection, teacher workload tracking, room utilization and a substitution planner.
Build a clash-free timetable for any school or college. Set your own days, periods, times, breaks, classes, subjects, teachers and rooms — then build the whole schedule in one place and let every view and check generate itself.
- Works with any format — you define the working days (5 or 6), the number of periods, their times and where breaks/lunch fall.
- 3-way clash detection — instantly flags a teacher, a room or a class booked twice in the same day & period.
- Class, Teacher & Room views — pick one from a dropdown and its full weekly grid draws itself automatically.
- Teacher workload — periods vs max load with Over / OK / Light flags, plus free-slot counts.
- Substitution planner — log an absent teacher and see the affected class instantly, with a live 'who is free at this slot' checker.
- Dashboard — total lessons, clashes, room utilization and subject distribution with charts.
Google Sheets + Excel. Yellow cells are the only cells you fill in.
- Excel/Sheets file (.xlsx and Google Sheets link)
- All formulas pre-built and documented
- Video walkthrough tutorial (10-15 min)
- Written setup documentation (PDF)
This product is perfect for:
- Anyone who wants to be more organized
- People building positive daily habits
- Self-improvement enthusiasts
- Beginners and advanced users alike
- Remote workers and digital nomads
Customer Reviews
Excellent product! Saved me so much time. Highly recommended.
This is exactly what I was looking for. Beautiful and functional.
Great value for money. Very well organized and easy to customize.