Why RotaSync exists

Your work rota is trapped in a messy spreadsheet. Your life shouldn't be.

The problem

If you work in a hospital, your rota almost certainly lives in a spreadsheet: a shared Google Sheet, an Excel workbook on SharePoint, or a file that gets emailed around the department. It has dozens of columns, cryptic shift codes like LD, N and TW, merged cells, colour-coding only the rota coordinator understands, and it changes constantly. Swaps happen. Annual leave gets approved. Gaps get filled at short notice.

So every few weeks you sit down and copy your shifts, one by one, into your phone's calendar. Then the rota changes and your calendar is quietly wrong. You double-book yourself against a night shift, discover a swap you never saw, or spend Sunday evening squinting at row 47 of a spreadsheet trying to work out whether you're on tomorrow.

If you've ever thought “I wish this rota would just sync itself to my calendar and stay up to date”: that is, word for word, the problem RotaSync was built to fix.

A hospital rota spreadsheet with coded shifts next to a phone calendar showing the same week as named, timed events synced by RotaSync

The fix

RotaSync reads the rota exactly where it already lives: no new system for your department, no asking the rota coordinator to change anything. You paste the link (or upload the file) once, tell it which name on the sheet is yours, and it does the rest:

  • It finds your shifts among everyone else's, even across multiple tabs.
  • It decodes the shift codes into real start and end times (long days, nights, twilights, on-calls, leave), which you can fine-tune once and keep forever.
  • It serves the result as a standard calendar feed you subscribe to from Apple Calendar, Google Calendar or Outlook.
  • When the spreadsheet changes, your calendar updates automatically on its next refresh. No re-copying, ever.

Who it's for

RotaSync is built for doctors' rotas (junior doctors rotating every 4–6 months, registrars, nurses, ACPs, pharmacists), but works for anyone whose shifts are decided by a spreadsheet they don't control. Access to rota data rests on the access your team already manages: you can only link a rota whose share link or file you already hold through your work, and at link time you confirm (recorded with a timestamp) that you're entitled to it and that it contains no confidential information. If your rota is a Google Sheet, an Office 365/SharePoint workbook or an Excel file, RotaSync can almost certainly turn it into a live calendar.

Why it's not just a script

Every department formats its rota differently, and formats drift mid-rotation. RotaSync reads them with years of battle-tested layout detection built specifically for NHS rotas — not an AI model, and your rota is never sent to one — so it adapts to new layouts, unusual shift codes and reshuffled columns, and when a colleague on the same rota has already set it up, your setup reuses their layout mapping instantly. Because it's interpreting a spreadsheet made for humans, we're upfront that it can make mistakes. Your official rota always remains the source of truth.

Stop copying shifts by hand

Link your rota in a couple of minutes and see your shifts appear in your own calendar. Free for your first 30 days, no card required to try it.