Skip to the content.

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

  1. Set opening hours, services with default minutes and staff on Settings.
  2. Add each booking on Appointments with date, start time, service and staff member.
  3. Check Day view and Week view before you confirm a new time.
  4. 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.

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.

All free templates