Excel Shift Planner Generator

It fills each shift day by day, picking available employees with the fewest hours so far. It respects your weekly shift cap, consecutive day limit, minimum rest and unavailability, so workloads stay balanced.

Yes. You get a real .xlsx workbook with the shift planner, a shift key sheet and an unfilled shifts sheet when coverage gaps exist. CSV download and copy-to-clipboard are also available.

Add a third field to the employee line, for example Sam Lee | Cashier | Sat Sun. You can also list specific dates in YYYY-MM-DD format, such as 2025-03-14, for one-off days off.

Yes. If a shift ends earlier than it starts, such as 22:00 to 06:00, it is treated as overnight and its hours and rest period are calculated correctly.

The tool still builds the schedule, highlights the shortfall in red in the coverage rows, and lists every unfilled shift so you can add staff or relax your rules and regenerate.

No. Everything runs locally in your browser, with no registration and no uploads. Your names and schedules are never sent to a server, so copy or download your results before leaving the page.