Most theatre diaries still live somewhere fragile – a laminated whiteboard by the scrub room, a printed grid that is out of date by Tuesday, or one person’s spreadsheet that nobody else can open. The Operation Theatre Booking Calendar in Google Sheets replaces that with a shared file anyone can open in a browser. It ships with 100 sample bookings, IDs 1 to 100, running from 02-Jan-2026 to 30-Dec-2026 with every one of the twelve months populated (8, 8, 8, 9, 8, 9, 8, 9, 8, 9, 8, 8). Those bookings sit across 26 named locations and 18Operation Theatre Booking Calendar in Google Sheets booking types, at 18 distinct start times between 7:30 AM and 8:30 PM. It costs $4.99 once.
Before anything else, the honest framing. This is a scheduling spreadsheet. It is not a patient record, not an EHR or EMR, not a theatre-management system. It holds no clinical data of any kind, and it makes no clinical or safety recommendation. What it does is answer one question quickly and for everybody at once: what is booked, where, and when.Operation Theatre Booking Calendar in Google Sheets
Key Features of the Operation Theatre Booking Calendar in Google Sheets
- One table, three views. Every booking lives on the Events sheet in seven columns – ID, Date, Day, Event Name, Time, Location, Description. The Annual, Monthly and Daily pages are formula-driven reads of that one table, so a booking is typed once.
- The whole theatre day is bookable, not only the operating. The sample includes Cardiac Bypass (CABG), Neurosurgery Craniotomy, Orthopaedic Joint Replacement, Elective Caesarean Section, Cataract Day List, Paediatric ENT List, Urology TURP List, Endoscopy List, Emergency Laparotomy Slot and Vascular Access Procedure – and, just as importantly, Instrument Sterilisation Cycle, Terminal Clean & Turnover, Anaesthesia Machine Check, Laminar Flow Service & Downtime, Recovery Bay Reservation and a held Trauma Standby Slot.Operation Theatre Booking Calendar in Google Sheets
- 26 locations already modelled, from Theatre 1 – General Surgery through Theatre 14 – Vascular, plus Obstetric Theatre 5B, Paediatric Day Case Theatre 10B, Cardiac Hybrid Theatre 12, the Interventional Suite, two PACU recovery bays, two CSSD autoclave bays, Endoscopy Suite B and its decontamination room, an instrument store and an ophthalmic minor-ops room.Operation Theatre Booking Calendar in Google Sheets
- A 36-year horizon. A hidden List helper sheet feeds the dropdowns with all twelve month names and the years 2021 to 2056.
- Browser-native. No install, no licence, no macros to enable. It opens on a phone in the corridor as readily as on the scheduler’s desktop.
- No patient field anywhere. Not a hedge – a design choice, and worth its own section below.
Calendar Pages Explained
Six sheets: five you use, one helper.
Home
A four-button menu – Annual View, Monthly View, Daily View, Events – and every page carries a Back link home. It is the whole navigation, and it means a colleague who has never seen the file knows where to click.
Annual View
All twelve months of the chosen year in a 3×4 grid, with every booked date shaded. One Year cell drives it. In the 2026 sample, 96 of the 365 dates carry at least one booking, and the shading makes the shape of the year obvious at a glance – which is exactly what you want when someone asks whether November is already busy.
Monthly View
A Month and Year dropdown over a seven-column week grid, with the booking name printed under each booked date. May 2026 shows Instrument Sterilisation Cycle on the 1st, Urology TURP List on the 8th and 9th, Anaesthesia Machine Check on the 18th and 20th, and Neurosurgery Craniotomy on the 27th. This is the page most people will print.Operation Theatre Booking Calendar in Google Sheets
Daily View
Type a Start Date and an End Date and the booking list filters to that window, in full detail. The May 2026 range returns eight rows, IDs 34 to 41, each with its time, location and description. Set it to Monday-Friday and you have a printable week of theatre lists.Operation Theatre Booking Calendar in Google Sheets
Events
The master table, and the only place you type. Each of the 18 booking types carries a standing description – “Pre-list machine, circuit and monitor check signed off by the duty ODP” for an Anaesthesia Machine Check, “Planned ventilation and laminar-flow canopy service; theatre closed to bookings” for a service slot – so the sample doubles as a worked example of how to word your own.Operation Theatre Booking Calendar in Google Sheets
List (hidden)
The helper sheet behind the dropdowns: twelve month names and the years 2021 to 2056.
Operation Theatre Booking Calendar vs. Excel vs. Paid Theatre Software – Feature Comparison
| This Google Sheets calendar | Excel theatre calendar | Paid theatre / OR management software | |
|---|---|---|---|
| Cost | $4.99 once | $4.99 once | Typically four to five figures a year |
| Platform | Any browser, any operating system | Windows desktop Excel, macro-enabled | Vendor web app |
| Setup time | Under 5 minutes | Under 5 minutes | Weeks, plus implementation fees |
| Real-time collaboration | Yes, built in | Only via a shared drive | Yes |
| Mobile access | Yes, the Sheets app | Limited | Yes |
| Customisable fields | Yes – add columns freely | Yes | Vendor-controlled |
| Share with a link | Yes | No | Account-based |
| Year-1 cost at 5 users | $4.99 | $4.99 | Thousands |
| Double-booking prevention | No | No | Yes |
| Theatre utilisation % | No – no duration field | No | Yes |
| Stores patient data | No – by design | No | Yes, and regulated accordingly |
The Missing Patient Column Is the Point
It is worth stopping on this, because it looks like an omission and is not one. Every one of the 100 sample rows was checked. There is no patient name column, no patient ID, no hospital or NHS number, no date of birth, no diagnosis and no clinical notes field anywhere in the file – and no sample row smuggles an identifier into a description either. The seven columns are ID, Date, Day, Event Name, Time, Location and Description, and that is the whole schema.
That means a theatre diary built on this template can be shared with the porters, the CSSD team, the cleaning supervisor and the on-call anaesthetist without any of them seeing something they should not. The booking says Urology TURP List, 8:00 AM, Theatre 2. Who is on the table stays in the clinical system that is built, secured and regulated to hold it. Privacy by omission is a real design decision, and it is the reason a spreadsheet is a defensible tool for this particular job.
Who Should Use This Template
Theatre schedulers and coordinators who need next quarter’s diary visible to a whole department. Small private hospitals, day-surgery units and standalone eye or endoscopy centres with no theatre-software budget. Departments running the diary on a whiteboard or a printed grid today. Managers who want to see where servicing, deep cleans and sterilisation cycles have already eaten the capacity.
It is the wrong tool if you need conflict detection, utilisation reporting, role-based permissions, an audit trail, or anything that touches patient identity. Those are system problems, not spreadsheet problems.
Real-World Use Cases
A 60-bed private hospital. The scheduler builds six weeks ahead on Events and prints Daily View filtered Monday to Friday for the theatre noticeboard. Because cleans and sterilisation cycles are rows too, the printed sheet shows real capacity rather than an optimistic version of it.
A standalone day-surgery unit. The manager plans next year each autumn from Annual View: the shaded dates show where Laminar Flow Service & Downtime already closes a theatre, so the high-volume cataract day lists get scheduled around the downtime instead of into it.
An ODP team lead. View-only access on a phone, Monthly View checked the night before, so the machines needing a pre-list check the next morning are known before anyone arrives.
Advantages of the Operation Theatre Booking Calendar in Google Sheets
- Everyone sees the same diary. No emailed versions, no “which copy is current”.
- Type once, read three ways. Annual for shape, Monthly for the working grid, Daily for the printable detail.
- Genuinely editable. Rename every theatre, add your own columns, change the wording. Nothing is locked.
- Free version history. Google Sheets keeps its own revision history, so a mis-typed booking is recoverable.
- It does not expire. The Year dropdown runs to 2056.
- One payment. No per-user licence, no renewal, no vendor.
Opportunities for Improvement
Four limitations are worth knowing before you buy, not after.
- Nothing prevents a double booking. Two rows can share the same location and the same time with no validation and no warning. The sample carries four dates with more than one booking – 20-Feb, 08-May, 18-May and 26-Jun 2026 – and on 26-Jun both bookings sit at 8:30 PM, in different theatres. Clash-checking is a human job here.
- Monthly View shows only the first booking on a date, followed by a small “1 more…” note. Use Daily View for any date carrying more than one – it lists them all.
- There is no duration or end-time column, so theatre utilisation cannot be calculated. You can add one yourself; the template does not do the maths for you.
- No surgeon, anaesthetist or team column. If you need to know who is running the list, add a column – or pair the calendar with a separate roster.
None of these are bugs. They are the boundary between a $4.99 spreadsheet and a theatre-management system, and it is better to see that boundary drawn clearly.
Best Practices
- Keep the Date column as a real date. The Annual, Monthly and Daily pages all read it; text that merely looks like a date will not appear.
- Standardise your location names before anyone else starts typing. “Theatre 3” and “Theatre 3 – Orthopaedic” will not group together.
- Give edit access to schedulers only, everyone else view-only. It is the closest thing the file has to permissions.
- Book the non-operating time too. Cleans, servicing and sterilisation cycles are what turn an optimistic diary into an accurate one.
- Sort by Date before you print, and check the multi-booking dates in Daily View.
- Keep patient identity out of it, including out of the Description column. The template is safe to share precisely because it holds none – do not undo that.
If you are new to the mechanics of shared sheets, Google’s own guide to sharing files and setting permissions is the reference to read before you hand the link around.
Explore Relevant Templates
The same engine, tuned for other parts of the hospital: the Medical Appointment Calendar in Google Sheets for outpatient clinics, the Radiology Slot Booking Calendar in Google Sheets for scanner and imaging-room slots, the Dental Clinic Appointment Calendar in Google Sheets, the Physiotherapy Session Calendar in Google Sheets and the Patient Follow-Up Visit Calendar in Google Sheets.Operation Theatre Booking Calendar in Google Sheets
For the people rather than the rooms, the Doctor Duty Roster Data Entry System in Excel handles the rota beside the theatre diary. And when a spreadsheet genuinely is not enough any more – multiple users, permissions, an audit trail – the Hospital Management System Web App is the step up.
An Excel edition of this same theatre calendar is being released alongside this one. It is the macro-enabled Windows-desktop build with a form-driven entry screen, carrying the same 100-booking sample and the same four views. If your theatre office lives in desktop Excel rather than a browser, that is the one to wait for; if you want to share a link, this is the one.Operation Theatre Booking Calendar in Google Sheets
Frequently Asked Questions
Is this a patient record system or an EHR?
No. It is a booking calendar with seven columns and no patient field of any kind. Book the theatre slot here; keep the person’s identity in your clinical system.Operation Theatre Booking Calendar in Google Sheets
Does it make my theatre department compliant or safe?
No. There is no certification, no accreditation and no assurance attached to it. It checks no safety standard, enforces no staffing rule and applies no booking policy, and it makes no clinical or safety recommendation.Operation Theatre Booking Calendar in Google Sheets
Will it warn me about a clash?
No. Two bookings can share a theatre and a time with no validation and no warning. That check stays with the scheduler.Operation Theatre Booking Calendar in Google Sheets
Can I see theatre utilisation?
No. Bookings have a start time but no duration, so utilisation cannot be derived. Add a duration column if you need it.Operation Theatre Booking Calendar in Google Sheets
Does it work after 2026?
Yes – the Year dropdown covers 2021 to 2056. The 2026 dates are sample data you delete.Operation Theatre Booking Calendar in Google Sheets
Do I need a paid Google account?
No. A free personal Google account is enough, and there is no recurring fee.Operation Theatre Booking Calendar in Google Sheets
Can several people use it at once?
Yes. That is the main advantage over the Excel edition – Google Sheets handles concurrent editing natively, and you share it with a link.
About the Author
Built by PK – Microsoft Certified Professional with 15+ years of Excel, Google Sheets, and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.Operation Theatre Booking Calendar in Google Sheets
Conclusion
A theatre diary does not need to be clever. It needs to be current, visible to everyone who acts on it, and honest about what is already committed. The Operation Theatre Booking Calendar in Google Sheets does those three things for $4.99 – one payment, no subscription, no per-user licence – and it does them without asking you to put a single patient detail into a spreadsheet.Operation Theatre Booking Calendar in Google Sheets
Open the PDF, click the copy link, and the calendar is in your own Google Drive in about two minutes. If the file does not open or copy correctly, get in touch for a replacement or a refund.Operation Theatre Booking Calendar in Google Sheets
Last updated: 26 August 2026.
