Home / Prompts / Work / Shift schedule

Shift schedule

Enter staff, shifts and rules and get a fair rota, also as data you can paste straight into Excel.

The prompt is put together in your browser. Nothing you type is uploaded, and favorites and history stay in your browser too.

Good for

Scheduling a shop or restaurant every week or two
Working around part-timers who can only do certain days
Checking whether there are enough people when many are on leave

1. Fill in the details

Period required

Staff required

Shifts and people per shift optional

Rules and time off optional

2. Adjust the options

Reply language

3. Copy the prompt

Where you will paste it

Cloud AILocal small model

ChatGPT, Claude, Gemini, DeepSeek and similar; the full, detailed prompt

Shift schedule

## Role
You are a store manager who schedules shifts fairly while respecting rules and people's needs.

## Task
Create the shift schedule for [Please add: Period].

## Background
- Staff: [Please add: Staff]

## Requirements
- Check whether the rules conflict first; if there are not enough people, tell me how many are missing
- Keep everyone's total hours as even as possible

## Output format
Give a schedule table (rows are dates, columns are shifts, cells contain names), then each person's total days and hours, and finally the schedule as CSV in a code block for pasting into Excel.

If the information above is not enough to do the task, list the questions you need me to answer first. Do not make anything up.

A filled-in example

Fill it in like this. Press the button below to put the example into the form above.

Period: December 1 to December 7
Staff: Wang (full-time), Amy (part-time, weekends only), Kevin (full-time), Fang (full-time)
Shifts and people per shift: Early 9-5 two people, late 2-10 two people
Rules and time off: Two days off a week each, never 6 days in a row, Wang off on Dec 3

What the AI's answer looks like

Illustrative excerpt: the real answer depends on the AI you use and what you fill in.

⚠️ Bottom line: there are not enough people. Weekdays need 4 shifts a day (2 early, 2 late), but only 3 full-timers can work weekdays and each needs two days off, so every weekday late shift is one person short.

Pick one:
1. Add a part-timer who can work weekdays
2. Staff weekday late shifts with one person

Here is a schedule with one person on weekday late shifts:
| Date | Early | Late |
|---|---|---|
| Mon 12/1 | Wang, Fang | Kevin |
| Tue 12/2 | Wang, Kevin | Fang |
| Wed 12/3 | Kevin, Fang | (Wang off) ... |

Tips

Be specific: "never 6 days in a row" works better than "do not overwork"
When the AI says you are short-staffed, decide how to adjust and ask it to redo the schedule
Paste the CSV into Excel and fine-tune it yourself

How to use it

Fill in the fields. You can leave a field empty for now; the prompt will show a [Please add] placeholder.
Choose the tone, length and where you will paste it, then press Copy.
Paste it into ChatGPT, Claude, Gemini, DeepSeek or a local model. If the AI asks you questions, answer them and the result gets better.