Home/Spreadsheets/HR & Employees/Medical Office Staff Schedule
Medical Office Staff Schedule
A medical office staff schedule: assign front desk, check-out, phones and exam rooms by session, and see every half hour where a room is short. The files open in Microsoft Excel and in Google Sheets, have no macros and nothing to install, and are yours to reuse as often as you like.
What it does
- Schedule by session (AM, PM or full day); each row is checked against approved PTO, the person's role, credentials, clashes and your break rules
- Room Grid: every room, every half hour of the clinic day, against the minimum staff you set; an expired credential stops counting toward coverage
- PTO balances from your own policy, with each request logged and decided
- Coverage: the next 28 clinic days by role, to check before you approve leave
- Credential renewal dates with an owner and next action, a training sign-off matrix and an onboarding checklist for new office hires
- Handover log for unfinished work between sessions, and a Summary each morning
- Opens in Excel and in Google Sheets
$14.99one-time, no subscription
Buy on Etsy
Instant digital download · one-time purchase · no subscription

What it looks like


What is in the bundle
- Medical_Office_Staff_Schedule.xlsx: blank, 11 tabs, with starter rooms, roles and lists
- Medical_Office_Staff_Schedule_Filled_Example.xlsx: 16 made-up office staff
- A PDF with Make a copy links for the Google Sheets version (blank and filled example)
- Up to 250 staff, 20 rooms on the Room Grid and 15 roles on Coverage
Works in
- Microsoft 365, Excel 2024 or Excel for the web (not Excel 2021 or older); no macros or add-ins
- Google Sheets with a free Google account, in a web browser; the phone app is fine for viewing
- Not compatible with Numbers, LibreOffice or OpenOffice
Honest scope
This is a record-keeping template, not legal or HR advice. Leave, overtime and pay rules vary by state and by employer policy; the file reports what you enter and does not decide what anyone is entitled to.
Others in HR & Employees
- ExcelEmployee PTO TrackerAn employee PTO tracker for Excel: vacation, sick days and half-days for up to 200…$14.99View →

- Excel + Google SheetsPerformance Review WriterAn employee evaluation spreadsheet that writes the performance review for you: rate…$17.99View →

- Excel + Google SheetsEmployee Training MatrixA training matrix and skills matrix for small teams: every employee down the side…$14.99View →

- Excel + Google SheetsEmployee Leave TrackerAn employee leave tracker for small teams: set your PTO policy once, log each request…$17.99View →
