Skip to content
New! Çetele 1.0 is on the App StoreDownload

Free · no sign-up

Free appointment book Excel template

In this template you write your services with length and price once, then enter each appointment with date, time, customer and service. Length and amount come from the service list. As you set each one to “Done”, “No-show” or “Cancelled”, the “Summary” sheet works out takings and the no-show rate between the dates you pick.

Appointment book template.xlsx · opens in Excel, Google Sheets and Numbers · 15 KB
Download the Excel file
ShareShare on WhatsApp

Inside the file

  • MerveDone
    Date
    6 days ago
    Time
    10:00
    Service
    Acrylic nails
    Amount
    ₺1,500.00
  • ElifDone
    Date
    6 days ago
    Time
    13:30
    Service
    Gel polish
    Amount
    ₺600.00
  • DenizNo-show
    Date
    5 days ago
    Time
    11:00
    Service
    Cut + blow-dry
    Amount
    ₺900.00
  • AyşeDone
    Date
    4 days ago
    Time
    15:00
    Service
    Colour + blow-dry
    Amount
    ₺1,800.00
  • EmreDone
    Date
    2 days ago
    Time
    09:30
    Service
    Beard
    Amount
    ₺300.00
  • ZeynepCancelled
    Date
    Yesterday
    Time
    16:00
    Service
    Facial
    Amount
    ₺1,200.00
  • GülPlanned
    Date
    Today
    Time
    10:00
    Service
    Cut + blow-dry
    Amount
    ₺900.00
  • SelinPlanned
    Date
    Tomorrow
    Time
    14:00
    Service
    Acrylic nails
    Amount
    ₺1,500.00
Appointments, last 7 days
7
Done · no-show · cancelled
4 · 1 · 1
No-show rate
14.3%
Takings (done)
₺4,200.00
The “Appointments” sheet and “Summary” with example records

What's in the file?

  • How to useFive steps and a privacy note.
  • AppointmentsDate, time, customer, service, length, amount, status (Planned, Done, No-show, Cancelled), note.
  • ServicesService, length and price; picked from a dropdown when booking.
  • SummaryBetween two dates: appointments, done, no-shows, cancelled, no-show rate and takings.

How to use it

  1. Download and open the file; list your services with their length and price on “Services”.
  2. Enter each appointment on “Appointments”; pick the service and length and amount fill in.
  3. When it's done set the status to “Done”; “No-show” for someone who didn't come.
  4. At the end of the week check takings and the no-show rate on “Summary”.
  5. For privacy, don't put customers' phone numbers in this file or share it.

To open it in Google Sheets

  1. 1. Download the file.
  2. 2. Upload it to Google Drive.
  3. 3. Right-click the file → Open with → Google Sheets.

Frequently asked questions

How do you keep an appointment book in Excel?

Each appointment is a row: date, time, customer, service, amount and status. Keep services in their own list so you don't type prices every time. In this template the service is picked from a list, the status from a dropdown, and the summary sheet works out takings and the no-show rate.

Why does the no-show rate matter?

Every no-show is a fee you could have taken from someone else at that hour. If 5 of 60 weekly appointments don't show, that's 8.3%; at ₺600 an appointment it's ₺3,000 a week. See it with your own numbers in the no-show cost calculator.

Can I use this template on my phone?

It opens and works in the Google Sheets or Excel app, but typing rows on a small screen is slow. If you want quick entries at the chair, an app that books an appointment in one tap is easier.

More templates

Have a good day at work!

In Çetele you tap “Done” when an appointment is over and the fee goes into that day's till; no-shows stay in the customer's history and the morning says “4 appointments today”.

Download on the App Store

Appointments and memberships arrive with the next version; the App Store version today is for shops.