As of 13 August 2026, AI can only partly create a rota from a spreadsheet.
This still needs a person who signs their name to it.
Can you do it?
5 minutesto a draft.
30 minutesto something you’d act on.
Cost, all in£0
Skill neededchat-fluent
Who has to check ita colleague
What the alternative costsNo priced rota-management alternative is provided in the supplied tool data.
If this goes wrong: someone is scheduled when unavailable, a required skill is missing from a shift, or the workplace is left without enough cover.
What to actually do
Hand it to a person
The route this page recommends
A person who owns the outcome does this end to end, worth it when the failure is dear.
Use a tool built for this
Second choiceDo it yourself
The distant thirdA chat interface, chat-fluent skill, and roughly 30 minutes until you can act on the result.
How to actually do it
- Open the spreadsheet and check that it contains staff names, availability, roles or skills, leave and any existing working-hour limits.
- Gather the rota period, shift times, required headcount, required skills and any fixed assignments from the manager or team policy.
- Paste the spreadsheet into a chatbot or upload it with the prompt, replacing each bracketed slot with the confirmed rota information.
- Ask the model to produce the rota, uncovered-shift list, conflict list and coverage summary specified in the prompt.
- Compare every assigned person and shift time with the spreadsheet, then check each shift against the required headcount, role and skill coverage.
- Ask a manager or responsible colleague to check working hours, rest periods, leave, fairness and local workplace rules before sending the approved rota to staff.
Prompt
Create a draft staff rota from the spreadsheet I attach. Use only the information in the spreadsheet and the rules below. Do not invent availability, qualifications, leave, working hours or staff preferences. If information is missing or contradictory, list the issue instead of guessing. Rota period: [start date] to [end date] Shift patterns and times: [paste or describe them] Required number of people per shift: [paste requirements] Required roles or skills per shift: [paste requirements] Rules and preferences: [paste rules, including maximum hours, rest requirements, fixed shifts and fairness preferences] Produce: 1. A rota with one row per shift and columns for date, shift time, role, assigned person and notes. 2. A separate list of uncovered shifts and any rule conflicts. 3. A separate list of assignments that depend on information not present in the spreadsheet. 4. A short coverage summary showing whether each shift has the required people and skills. Keep names and details exactly as supplied. Do not claim that the rota complies with UK employment law. Mark any legal or policy point that needs checking by the manager or HR. Do not finalise the rota or silently change the source data.
Open it prefilled in ChatGPT or Claude, or copy it into Gemini, which takes no prefill link.
What it gets wrong
- AI cannot infer an employee's real availability when the spreadsheet is incomplete or out of date.
- AI cannot decide whether an informal preference should outweigh coverage, fairness or business needs.
- AI cannot reliably certify compliance with working-time rules, contracts or workplace policy.
- AI cannot take responsibility for missed cover, an unsuitable assignment or a dispute between staff.
What caps this at PARTLY: judgement under ambiguity, verification cost and stakes of error.
How we scored this
Five axes, each scored nought to two by hand: ten means AI carries the task cleanly, and the thresholds that turn a total into YES, PARTLY or NO are published in the methodology. Each axis name links to its definition.
| Axis | Score (0–2) |
|---|---|
| Output | 2 |
| Inputs | 1 |
| Verification | 1 |
| Liability | 1 |
| Effort delta | 2 |
| Total | 7 / 10 |
The methodology and its thresholds are published in full.
FAQ
- Can ChatGPT make a staff rota from Excel?
- Yes, it can turn a suitable Excel spreadsheet into a draft rota, especially when the shifts, availability, roles and coverage rules are clear. It may miss a constraint that is absent from the file, so a manager must check the assignments before the rota is issued.
- Can AI check if a rota is fair?
- AI can compare hours, weekend shifts and other measures if you define fairness and provide complete data. It cannot decide what is fair in a dispute or know which operational or personal context has been left out.
- Can AI make a rota that follows UK working time rules?
- It can flag possible conflicts if you provide the relevant rules and working hours, but it cannot certify that the rota complies with UK employment requirements. Check the final rota against your policy and ask HR or an employment specialist about a serious case.
- What information does AI need to make a staff rota?
- Give it the rota dates, shift times, staff availability, leave, roles or skills, required headcount and any limits on hours or rest. Also provide fixed assignments and preferences, and tell it to list missing or contradictory information instead of guessing.
Nearby answers
Assessed by gpt-5.6-luna (gpt-5.6-luna) on 2026-08-13, second-checked by an independent model. Wrong somewhere? Email [email protected] and it gets re-checked.
The newsletter
AI news, new answers and product picks, straight to your inbox.