Plan a Fitness Class Schedule With AI and Real Data
Your attendance sheet already knows which classes to keep, move, or merge. How to have AI read it, and why you should change one slot at a time.
To plan a fitness class schedule with AI, export attendance for each class slot over the last two to three months, then ask the AI to rank the slots by how full they run and to suggest keep, move, or merge for each one. Then change one slot at a time and watch it for a month. The timetable is a hypothesis about when your members want to train, and your attendance sheet is the evidence.
Most studio timetables are inherited. A class sits at 6:30 on Tuesday because it sat there three years ago. Nobody argues with it until the room is half empty and the instructor is quietly discouraged. AI will not fix that by magic. What it does well is read a messy spreadsheet and surface patterns you have not had time to look for.
Step 1: Export the right data
You need one row per class session, not a summary. Pull these columns from your booking system:
Date and day of week
Start time
Class type (yoga, spin, strength, and so on)
Instructor (a first name or initial is enough)
Capacity
Booked, attended, and late cancellations or no-shows
Waitlist length, if you track it
Leave out member names, emails, and payment information. You are analyzing the classes, not the people, and nothing about the analysis needs personal details. If your export includes them, delete those columns before pasting anything anywhere.
Step 2: Ask for the fill-rate picture first
Do not start with "make me a new timetable". Start with description, so you can check the AI's reading of the data.
Here is attendance data for our studio for the last 12 weeks (CSV below).
1. Calculate the average attended divided by capacity for every combination of weekday and start time.
2. List the five fullest and five emptiest slots.
3. Show which class types do best at which times.
4. Flag any slot where the waitlist was above zero on more than half of the weeks.
Show your working in a table. Do not recommend changes yet.Check two or three numbers by hand against the raw sheet. If the AI's average for Thursday 18:00 does not match yours, stop and fix the paste before going further. Spreadsheet functions are the safer way to compute the figures, so you can also ask the AI for a formula and run it yourself.
Step 3: Ask for options, with reasons
Now ask for recommendations, with the rules of your studio stated.
Using the fill rates above, suggest changes to the timetable. Rules: instructors have fixed availability (below), no more than two classes in a row for one instructor, the room needs 15 minutes between classes, and I will change at most two slots per month.
For each suggestion, give the evidence from the data and one risk. Rank by expected benefit.The two-slots-per-month rule stops the AI from rebuilding your whole week, which would make any result impossible to read.
Step 4: Read the data with a skeptic's eye
Three traps catch people here:
Seasonality. Twelve weeks that include a school holiday or a heat wave can mislead. Note unusual weeks and ask the AI to compare with and without them.
Small samples. A slot that ran four times may look great or terrible by chance. Treat anything under about eight sessions as a hint, not a verdict.
Cause versus coincidence. A full Saturday class may be popular because of the instructor, not the time. Ask which instructor taught each full slot before you move a class.
Step 5: Trial one change at a time
Pick the best suggestion, such as moving an under-filled 7:00 class to 7:30, and keep everything else fixed for four weeks. Record the same columns. After four weeks, compare the new slot's fill rate to its old one. If it improved, keep it and pick the next change. If it did not, you have learned something cheaply.
Tell members before changing a slot, and keep the old time visible for a few weeks so regulars are not caught out. A change that fills the room but upsets your most loyal members is not an improvement.
Use the schedule to fix other problems
Once the timetable is sound, ideas from how to reduce no-shows with AI scheduling can lift attendance on the classes that are booked but empty. If instructor cover is the real constraint, how to schedule staff shifts with AI applies the same approach to people instead of rooms. For tools that suit a studio more broadly, see AI tools for gyms and fitness studios, and when a quiet slot needs a push, how to use AI to plan a seasonal promotion helps with the offer. The general overview sits in AI for small business.
Staffing the classes is a separate scheduling problem, covered in how to use AI to write a staff rota.
FAQ
Can AI build my class timetable for me?
It can analyze your attendance data and suggest changes. You decide which to try, because you know your instructors, your room, and your members.
How much data do I need?
Two to three months of session-level attendance is a reasonable starting point. More helps if your classes are seasonal.
Is it safe to paste member data into an AI tool?
Avoid it. Remove names, emails, and payment details first. Class-level numbers are enough for scheduling analysis.
How often should I change the timetable?
Small changes, one or two slots at a time, every month or so. Big overhauls make it hard to tell what worked.
How did this land?
About the author

Developer Advocate
Steve builds something with Swarmz every week and writes up what worked, what broke, and what he'd do differently. Tutorials and hands-on guides are his lane.


