Free Appointment Spreadsheet
For service businesses that take bookings by phone and text and need a simple appointment book that shows the day, the week and any clash.
Open the template · Make a copy · Google Sheet, free, no sign-up
What is inside
| Tab | What it holds |
|---|---|
| Dashboard | Totals and views built from Appointments, no typing needed. |
| Appointments | Columns Appointment ID, Date, Start time, Duration (minutes), End time, Customer name, Phone, Email, Service and 8 more. |
| Day view | Totals and views built from Appointments, no typing needed. |
| Week view | Totals and views built from Appointments, no typing needed. |
| Settings | Your own dropdown lists (service, default minutes, weekday number, weekday and open), so the choices match how you work. |
How to fill it in
- Set opening hours, services with default minutes and staff on Settings.
- Add each booking on Appointments with date, start time, service and staff member.
- Check Day view and Week view before you confirm a new time.
- Tick Confirmation sent once the customer has the details.
A tip from the field
Staff overlap and Customer overlap flag two bookings in one slot, and the business hours alert catches times outside your hours.
Starter files
Each tab with sample rows comes as a CSV file, handy for importing into another tool or starting fresh.
- Appointments (13 sample rows)
Related templates
- Free Google Sheets Scheduling Template
- Free Google Sheets Dispatch Schedule
- Free Lead Follow Up Spreadsheet
When you outgrow it
Smarfle gives you an online booking page that only offers free times, plus reminder texts you can turn on. See how it works on smarfle.com.