Free template · Excel & Google Sheets
Free Appointment Schedule Template with Double-Booking Check (Excel & Google Sheets)
For solo service businesses that book over text and DM: one sheet that knows how long each service takes and warns you about overlaps.
No sign-up, no email. Opens in Excel, Google Sheets, Apple Numbers and LibreOffice.What's inside
- Service list with duration, buffer and price
- End time calculated including buffer
- Double-booking warning in red
- Booked / Done / No-show / Cancelled status
- Revenue, no-show rate and bookings by weekday
Preview
Yellow cells are the ones you type in. Everything else calculates.
| Date | Start | Client | Service | Ends | Price | Check |
|---|---|---|---|---|---|---|
| Thu 12 Nov | 2:00 PM | J. Rivera | Standard | 3:15 PM | $85 | |
| Thu 12 Nov | 2:30 PM | A. Chen | Consultation | 3:10 PM | $45 | ⚠ Overlap |
How to use it
- On Services, list what you offer with duration, buffer time and price.
- On Bookings, add the date, start time, client and pick the service.
- If '⚠ Overlap' appears, move one of the appointments.
- Mark each appointment Done or No-show afterwards; the Dashboard updates.
Using Google Sheets?
Upload the file to Google Drive, then open it with Google Sheets. Formulas, drop-downs and colour rules carry over.
Times are local to the sheet. If clients are in other time zones, note it in the Notes column.
BookingSolved: Client Booking
BookingSolved reads a client's 'Could I do Tuesday at 2?' message, checks your Apple Calendar and prepares the booking and reply for you to approve.
Get it on the App StoreQuestions people ask
- How does the double-booking check work?
- For each appointment it counts other non-cancelled bookings on the same date whose time ranges overlap, including buffer time.
- Can I share it with an assistant?
- Yes — upload it to Google Drive and share edit access.
- Does it send reminders?
- No; it's a schedule. The app prepares replies, and Apple Calendar can alert you.
Share or reuse
This template is free to use, share and adapt under CC BY 4.0. If you post it on your site, please link back to this page.