AI School Timetable Maker: Free Step-by-Step Guide [2026]

How do I make a school timetable with AI? [Quick Answer]

To create a school timetable with AI in 5 steps:

1. Choose a free AI tool (ChatGPT, Claude, Copilot, or Gemini).
2. Write a prompt with your constraints (subjects, teachers, time slots, rooms, breaks).
3. Iterate on the output to fix double-bookings and refine.
4. Export the final schedule as a downloadable .xlsx file with real Excel datetime values for StartDate / EndDate (not text).
5. Import the .xlsx into your school’s Microsoft 365 system via the Virto Calendar App (institutions) — or into Google Calendar / Virto Shared Calendar for individual teachers and tutors.

Best free AI tools for school timetables in 2026: ChatGPT (free tier), Claude (free tier), Microsoft Copilot in M365, and Google Gemini. For dedicated school scheduling: aSc TimeTables, TimeTabler, and Edval (paid).

Running Microsoft 365?

Skip to How to Import an AI-Generated Schedule into Microsoft 365 below to see how the Virto Calendar App turns your .xlsx file into a shared institutional calendar (free for 30 days).

Creating a school or college timetable used to mean wrestling with spreadsheets and color-coded printouts. In 2026, a free AI chatbot can produce a workable first draft in minutes. This step-by-step guide shows how to make a school timetable with AI (ChatGPT, Claude, Copilot, or Gemini), then import it into Microsoft 365, Teams, or a free shared calendar.

Best AI Timetable Maker Tools for Schools (Free) [2026]

There are two categories of AI tools for school timetables: general-purpose AI chatbots that can be prompted to generate schedules (free), and specialized scheduling software with built-in AI optimization (mostly paid). For most schools, the free general-purpose tools are surprisingly capable when paired with the right prompts.

Comparison of the best free and paid AI timetable maker tools in 2026.

For a school or college without budget for dedicated scheduling software, the workflow ChatGPT/Claude → .xlsx → Microsoft 365 (Virto Calendar App) or Google Workspace is fully free for the AI generation step and surprisingly effective. The next section walks through this exact workflow.

Generated an .xlsx with AI? Import it into Virto Calendar App.

Once your AI tool has produced a schedule, import the .xlsx into the Virto Calendar App for Microsoft 365 and Teams to share it with staff, students, and parents — see the step-by-step demo further down.

How to Make a School Timetable with AI (Step-by-Step)

While specialized scheduling software offers powerful features, budget constraints often push schools to explore more accessible alternatives. Free AI chatbots like ChatGPT, Claude, Copilot, and Gemini can be surprisingly effective for creating, managing, and optimizing school schedules — provided you treat them as a collaborator and iterate on the output.

Considerations for prompting AI to build a schedule

• Be specific: Define your constraints clearly — the number of classes, periods, available rooms, teacher availability, and special requirements like lunch breaks or recess.
• Provide context: Mention grade levels, subject requirements, electives, and any desired balancing of class difficulty or teacher workloads.
• Iterate and refine: Don’t expect perfection on the first try. Review the schedule, point out conflicts, and re-prompt.
• Keep the human in the loop: AI is a tool, not a replacement. Review the final schedule for feasibility, fairness, and fit with your school’s values.

Step 1 — Write the initial prompt

Begin with a detailed prompt. The more information you give the AI, the closer the first draft will be. Here is an example used for a high-school grade 9 schedule:

“Please create a high school schedule for 2 groups in grade 9 for the month of September 2026. The school day starts at 8:30 AM and ends at 4 PM, with registration from 8:30–8:55 and classes starting at 9:00. Periods are 40–60 minutes with 5-minute breaks, a 15-minute break after 2 periods, and 60 minutes for lunch. Each period typically consists of two consecutive lessons of the same subject. Subjects taught this semester: Drama (Ms. Hart), French (Mr. Dubois), Maths (Mr. Thompson), History (Dr. Collins), Geography (Mr. Rivers), English (Ms. Bennett), Music (Ms. Hart), IT (Mr. Lewis), PE (Coach Jordan), Art and Design (Ms. Morgan), Literature (Ms. Bennett), Chemistry (Dr. Carter), Biology (Dr. Carter), Physics (Dr. Mitchell). Rooms: 2 Science Labs, 1 Gym, 2 Computer Rooms, 1 Drama Studio. Drama, Music, and Art and Design are electives offered as the last classes of the day.”

Pic. 1 — Claude’s response to the initial timetable prompt

Step 2 — Refine to fix conflicts

Most first drafts contain at least one conflict. In our test, Claude double-booked Ms. Hart for both Group A and Group B at the same time, and didn’t include exact dates. Common refinements you’ll need to ask for:

• Teacher availability — no teacher scheduled in two places at once.
• Specific time slots — precise dates and times for every class.
• Periods and breaks — double periods per subject, plus 5-minute, 15-minute, and lunch breaks.

Step 3 — Export as Excel (.xlsx)

Once the schedule passes your hard rules, ask the AI for the final output as a downloadable .xlsx file. The exact instruction that works for ChatGPT and Claude:

“Export this schedule as a downloadable .xlsx file with columns: Title, StartDate, EndDate, Subject, Teacher, Room. StartDate and EndDate must be real Excel datetime values (not text). Subject should be a short category (e.g., Maths, Science, English) so it can be used as a Choice field for color-coding in SharePoint.”

All four mainstream tools handle this directly: ChatGPT (Advanced Data Analysis), Microsoft Copilot in M365, Claude (file artifacts), and Gemini all return a downloadable .xlsx with proper datetime cells. If a tool only renders the table inline, copy it into Excel, format StartDate / EndDate as Date & Time, and save the workbook as .xlsx before uploading to SharePoint.

Step 4 — Share or import the schedule

Once you have the .xlsx, you have two options. Print and distribute it, or import it into your school’s calendar so staff and students see the schedule in the same place they already work. We cover the Microsoft 365 import in the Virto Calendar App demo section below.

AI College Schedule Maker (University & Higher Ed)

College and university scheduling differs from K–12 in scale and flexibility — multiple campuses, student-driven course selection, professor availability windows, and rotating classroom resources. AI helps in three main scenarios.

For administrators — generate department schedules

Use an AI tool to draft section assignments across professors and rooms based on enrollment data. Sample prompt:

“Create a fall semester schedule for the Computer Science department at a 5,000-student university. Constraints: 12 professors, 8 courses (CS101, CS201, CS301, CS401, CS450, CS500, CS510, CS600), 3 lecture halls (capacity 200, 100, 50), 2 lab rooms (capacity 30 each). Each course meets twice weekly for 75 minutes. CS101 (3 sections) and CS201 (2 sections) are required for all CS majors. Avoid scheduling required courses concurrently. Output as a downloadable .xlsx file with columns: Title, StartDate, EndDate, Subject (use ‘Computer Science’ for all rows so it works as a Choice field for color-coding later), course_code, section, professor, room. StartDate and EndDate must be real Excel datetime values (not text).”

For students — personal course schedule planner

Students can use AI to optimize their personal schedule from a course catalog. Sample prompt:

“I need to take MATH201, ENGL202, PHYS300, HIST101 this semester. I prefer mornings, no Friday classes, and at least 30 minutes between classes for transit. Here are the section options [paste]. Suggest the optimal schedule and export as an .xlsx file with Title, StartDate, EndDate, Subject (Math / English / Physics / History) so I can import it into my calendar.”

For full enterprise scheduling

For complex multi-campus institutions, AI-powered scheduling SaaS like Civitas Learning, Ad Astra, CollegeNET, and Jenzabar offer integrated AI optimization with enrollment data, student-information-system sync, and registrar workflows. See our full college scheduling software comparison for a side-by-side breakdown.

Pic. 4 — Example college department schedule generated by AI

Understanding School Scheduling Basics

School scheduling is the process of organizing classes, teachers, rooms, and resources into a coherent weekly timetable. The goal is a balanced schedule that meets educational needs and respects teacher and room constraints. Five components typically have to fit together: a class timetable defining when each class runs, teacher assignments to subjects and groups, room allocation, shared-resource management (labs, sports facilities), and extracurricular activities.

Common challenges

• Limited resources: Not enough classrooms or qualified teachers for the desired schedule.
• Balancing teaching load: Distributing periods evenly while respecting subject specializations.
• Schedule conflicts: Avoiding teacher double-bookings, student overlaps, and room clashes.
• Mixing academics and extracurriculars: Sports, music, and clubs need protected slots without disrupting core classes.
• Individual needs: Students with special educational needs (SEN) may require tailored schedules.

A simple worked example

Imagine four lessons to schedule: Math (Mr. Turing, grade 9), Chemistry (Ms. Curie, grade 9), French (Ms. Curie, grade 10), and History (Mr. Jones, grade 10). You have two rooms and two time slots (8:30–9:30 and 9:30–10:30). The solution: Room A runs Math then Chemistry for grade 9; Room B runs French then History for grade 10. No teacher is double-booked, no student has two classes at once, and both rooms are fully used. Even a four-lesson example shows how quickly real timetabling becomes a constraint-satisfaction problem — exactly the kind of problem AI is good at.

Pic. 5 — Example classroom school time table chart (4 lessons across 2 rooms)

Hybrid & Online School Timetables

Since the pandemic, many institutions, particularly in higher education, have adopted hybrid models that combine in-person and online learning. Common patterns include flipped classrooms (new material online, discussion in person), blended learning (face-to-face plus online modules), and rotating schedules (alternating in-person and online weeks). Good hybrid schedules are intentional, not bolt-on: every online activity should add something the in-person session can’t, and vice versa.

How to combine online and offline classes effectively

• Purposeful integration: Use online time for what it does best (asynchronous practice, simulations) and reserve in-person time for discussion, labs, and assessment.
• Clear communication: Publish a single source of truth schedule and assignment list. Students should never have to guess what is online vs. in person.
• Buffer time: Build in setup and transition windows so students can log in or move between classrooms without losing instructional time.
• Teacher training: Make sure staff are confident with the online platform and have IT support on call.

Benefits and challenges (in brief)

Benefits: Personalized learning pathways, broader access to resources, and stronger engagement when interactive online elements are well chosen. Challenges: Time management and focus, digital equity (not every student has equal device or internet access), and added workload for teachers designing two parallel experiences.

How to Import an AI-Generated Schedule into Microsoft 365

If your school runs on Microsoft 365, the .xlsx file from Step 3 becomes a fully shared, color-coded institutional calendar in three stages: prepare the workbook, push it to SharePoint, and add it as a data source in the Virto Calendar App.

Stage 1 — Prepare your .xlsx file

1. Confirm the workbook has Title, StartDate, EndDate, and a Subject column clearly named (Teacher and Room columns are typical extras).
2. Confirm StartDate and EndDate cells are formatted as Excel Date & Time values (not text).
3. Confirm Subject has a small set of repeated values (e.g., Maths, Science, English, PE, Drama) — this is what lets SharePoint treat it as a Choice field and unlocks color-coding in the Virto Calendar App.
4. Open the workbook briefly in Excel if you want to sanity-check the cells before upload.

Stage 2 — Import the file as a SharePoint list

1. Navigate to your desired SharePoint site.
2. Click New → List → From Excel.
3. Upload your .xlsx file — the StartDate and EndDate cells carry their Date & Time formatting from Excel straight into SharePoint.
4. On the preview / mapping screen, set column types: Title → Single line of text; StartDate / EndDate → Date and Time; Subject → Choice (with values like Maths, Science, English, PE, Drama); Teacher and Room → Single line of text. Setting Subject as Choice here is what unlocks color-coding in the Virto Calendar App.

Pic. 6 — Setting column types on the SharePoint From Excel import: StartDate / EndDate as Date and Time; Subject as Choice (which is what enables color-coding in Virto Calendar App).

5. Name the list and click Create.
6. Verify the data: open the list and make sure every row landed correctly.

Why .xlsx and not CSV?

SharePoint’s “From Excel” import reads column types from the workbook itself. In an .xlsx, StartDate and EndDate are real datetime cells and Subject (with its repeated values) can be promoted to Choice — so SharePoint creates the right column types automatically, including the one that unlocks color-coding. In a CSV every value arrives as plain text, dates can’t be placed on the calendar, and Subject stays as text (no color-coding). If your AI tool returns CSV, take five seconds before uploading: open it in Excel and use File → Save As → Excel Workbook (.xlsx).

Stage 3 — Add the list as a data source in Virto Calendar App

1. Open the Virto Calendar App and click the Add new calendar icon.

Pic. 7 — Creating a new calendar in Virto Calendar App (settings panel).

2. In the Available calendars tab, choose Create new SharePoint data source.

Pic. 8 — Creating a new SharePoint data source in Virto Calendar App.

3. Select your newly created SharePoint list and fill in Name, Site URL, and Time Zone.
4. Map the fields: Title → Title, Start → StartDate, End → EndDate.

Pic. 9 — Mapping fields in Virto Calendar App.

5. For color-coding by Subject, set Category field → Subject (the Choice column you set in Stage 2). Each Subject value will get its own color in the calendar — Maths in one color, Science in another, and so on.

Pic. 10 — Color-coding by Subject in Virto Calendar App.

6. Choose which fields to show in tooltips (Teacher and Room are typical).
7. Click Save — the schedule renders as a visual calendar accessible in SharePoint pages, Outlook, and Microsoft Teams.

Pic. 11 — Final imported schedule rendered in Virto Calendar App, color-coded by Subject.

No SharePoint? Use Virto Shared Calendar (Free for Teachers)

Not every individual teacher or tutor has a SharePoint site to work with. For lightweight use — a private tutor, a small class, or a teacher running a single after-school club — try the Virto Shared Calendar. It runs inside Microsoft Teams and Outlook, supports anonymous sharing, real-time sync across devices, and granular permissions, with a free tier of up to 15 entries — enough for a typical weekly schedule. You can paste AI-generated events directly, tag them by class or group, and share a link with students and parents.

Free for teachers: Virto Shared Calendar (free for 15 entries)

Virto Shared Calendar offers a free tier (up to 15 entries) for individual teachers, tutors, and small classes — no SharePoint required. Perfect for sharing a weekly timetable with students and parents.

School Time Table Kaise Banaye? (Guide for Indian Schools)

Indian school timetables follow similar logic to international ones, but with specific local needs: morning assembly, prayer time, separate periods for Hindi or a regional language alongside English, and physical training (PT) periods. The same AI workflow applies — write a prompt with your constraints, iterate, then export as .xlsx.

Sample prompt for an Indian CBSE school:

“Make a Class 9 timetable for an Indian CBSE school. School day: 8:00 AM to 2:00 PM. Morning assembly: 8:00–8:20. Periods: 40 minutes each. Subjects: English, Hindi, Mathematics, Science, Social Science, Sanskrit, PT, Computer Science. Lunch break: 11:20–11:50. Each subject minimum 5 periods/week, PT minimum 2 periods/week. No same subject in two consecutive periods. Export as a downloadable .xlsx file with columns Title, StartDate, EndDate, Subject, Teacher, Room. StartDate and EndDate must be real Excel datetime values.”

The same workflow applies: prompt the AI, review for conflicts, export as .xlsx, and import it into Microsoft 365 (Virto Calendar App) or Google Workspace so students and parents can see the timetable. ChatGPT, Claude, and Gemini all handle Hinglish prompts and can produce CBSE/ICSE-aligned timetables.

Success Stories: AI in Action in Schools

Three institutions illustrate how AI is already changing day-to-day operations in education — from retention to scheduling.

Nova Southeastern University — AI-driven retention

Nova Southeastern University (NSU) in Florida used Aible, an AI platform, to analyze academic history, demographics, financial aid, and engagement data to predict which students were most at risk of dropping out. Within 15 days of deployment, NSU achieved a 17% reduction in student attrition by enabling early, targeted intervention. (See reference [1].)

University of Murcia — AI student-services chatbot

The University of Murcia in Spain deployed “Lola,” an AI chatbot trained on campus information, academic programs, and student services. Lola handled 38,708 questions from 4,609 students with a 91% accuracy rate, freeing admin staff for higher-value work and giving students 24/7 access to answers. (See reference [2].)

Texas A&M-San Antonio — AI-enabled scheduling

Texas A&M-San Antonio implemented Civitas Learning’s AI-powered scheduling and registration software. Students enter their courses, preferred class times, and constraints (work, commute) and the AI generates feasible schedule options. The result: a smoother orientation, fewer registration errors, and advisors freed up for academic and career conversations rather than schedule mechanics. (See reference [3].)

Frequently Asked Questions

How do I make a school timetable with AI?

Choose a free AI tool (ChatGPT, Claude, Copilot, or Gemini), write a detailed prompt with your constraints (subjects, teachers, rooms, time slots, breaks), iterate on the output to fix conflicts, export as a downloadable .xlsx file with real Excel datetime values for StartDate / EndDate, and import the file into your school’s calendar system. The full step-by-step workflow is described above.

What is the best free AI timetable maker?

For most schools, ChatGPT (free tier) and Claude (free tier) are the most capable free AI tools for generating timetables. Schools on Microsoft 365 should also try Copilot, and Google Workspace schools should try Gemini. For dedicated scheduling software with AI, aSc TimeTables offers a free trial.

How do I make a college schedule with AI?

For administrators: prompt an AI tool with department, professors, courses, rooms, and enrollment constraints. For students: prompt with required courses, section options, and personal preferences (e.g., “no Friday classes”). The AI generates an optimized schedule that can be exported as a downloadable .xlsx file and imported into the institution’s calendar system.

Can AI generate a school timetable for free?

Yes. ChatGPT, Claude, Microsoft Copilot, and Google Gemini all offer free tiers capable of generating school and college timetables. The free tools work well for schools up to ~500 students with standard constraints. Larger institutions with thousands of students and complex multi-campus needs may benefit from dedicated paid software.

How do I make a school time table for teachers?

Include teacher-specific constraints in your AI prompt: who teaches what, availability windows, maximum periods per day, preferred classrooms, and any specializations. The AI ensures no teacher is double-booked. After generating, share the schedule by exporting as a downloadable .xlsx file and importing it into Microsoft 365 (via the Virto Calendar App) or Google Workspace so each teacher sees their personalized view.

How do I import an AI-generated schedule into Microsoft Teams?

Ask the AI to export the schedule as a downloadable .xlsx file with columns Title, StartDate, EndDate, Subject, Teacher, Room (StartDate and EndDate as real Excel datetime values, not text; Subject as a short category like Maths / Science / English so it can be promoted to a Choice column). In SharePoint, use New → List → From Excel and upload the file — set StartDate / EndDate to Date and Time, set Subject to Choice (this is what enables color-coding), and everything else to Single line of text. Then add the list as a data source in the Virto Calendar App, mapping Title → Title, Start → StartDate, End → EndDate, and Category → Subject for color-coding. The schedule renders as a visual calendar accessible in SharePoint pages, Outlook, and Microsoft Teams. The Virto Calendar App is free for a 30-day trial. Full step-by-step workflow with screenshots is in this article above.

School time table kaise banaye? (How to make a school timetable in an Indian context)

Indian schools can use the same AI workflow as international schools, but include India-specific elements in the prompt: morning assembly, Hindi/regional language periods, PT (physical training), and the typical 8:00 AM–2:00 PM school day. ChatGPT, Claude, and Gemini all handle Hinglish prompts and can generate CBSE/ICSE-aligned timetables. Export as a downloadable .xlsx file and import into Microsoft 365 or Google Workspace.

Conclusion

AI dramatically reduces the time and complexity of school timetabling — automating repetitive work, optimizing resource use, and accommodating constraints in a way that manual scheduling can’t match. The result is more balanced, more adaptable schedules that fit the realities of a modern school or college.

Pair AI with the right calendar tool to close the loop. For Microsoft 365 and Teams schools, the Virto Calendar App (free 30-day trial) and Virto Calendar App for Microsoft Teams unify your AI-generated .xlsx into a single view for staff and students. For individual teachers and tutors, the Virto Shared Calendar free tier (up to 15 entries) is the easiest way to share a weekly schedule.

Ready to put your AI schedule into action?

Try the Virto Calendar App free for 30 days, or book a quick demo to see how Microsoft 365, Teams, and SharePoint can serve as the home for your AI-generated timetable.

Further reading

• The Ultimate Guide to Education Scheduling Software in 2026
• Classroom Scheduling Software: Features & Comparison Guide
• Best Calendars for College Students: The Expert Guide 2026
• AI Tools for School Schedules and Timetables: Prompts & Guide
• Virto Calendar Overlay App for Microsoft 365
• Virto Calendar App for Microsoft Teams | Try for free
• Virto Calendar Web Part for SharePoint | Try now
• Virto Calendar App for Schools, Colleges & Universities

References

1. Nova Southeastern University’s Use of Aible — Case Study
2. University of Murcia’s Use of Lola — Case Study
3. Texas A&M-San Antonio’s Use of Civitas — Case Study