School timetable guides
Prepare school timetable data with an Excel template
An Excel setup workbook is a way to collect teachers, classes, grids, and lesson requirements. It is different from a printable timetable. Use Rik Plan’s template so the importer can understand how the data is connected.
Open automatic modeDownload the right workbook
Create or select a schedule in automatic mode and choose the Excel step. Export a blank setup template for a new plan, or export the current setup to edit existing data. Keep a copy of the original workbook before making changes.
Preserve the template structure
Fill in the provided sheets and columns instead of replacing them with a visual weekly calendar. Keep identifiers and references consistent. Check that each class requirement points to the intended teacher, subject, and grid, especially when names are similar.
Import and review before applying
Upload the completed template in the Excel step. Review the staged data and validation feedback, then apply the import. Walk through the grid, teacher, and class steps afterward to verify times, availability, and weekly lesson counts.
Generate a timetable, then export it
The imported data prepares the generator; it does not itself mean the timetable is complete. Generate, review unplaced lessons, and export the result to Excel or PDF. Keep setup workbooks and finished timetable exports clearly named so colleagues use the right file.
Common questions
Can I import any spreadsheet layout?
The regular Excel importer requires the template exported by Rik Plan. For a table with different columns, use Import with AI and review the extracted teachers, classes and teaching loads. AI import prepares input data; it does not restore the placement of lessons from a finished timetable.
Is Excel required for manual scheduling?
No. You can create teachers, classes, and lesson requirements directly in manual mode. This template workflow belongs to the automatic wizard.