# Appointments scheduler Excel (free) + online

> Free Excel appointments sheet for consultants and service centres: clash and working-hours alerts, day agenda per staff, follow-ups, utilisation and no-shows.

Source: https://softwiro.com/blog/appointments-scheduler-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Appointment scheduler in Excel (free): clash alerts, staff hours, day agenda and follow-ups

One workbook for services, staff working hours, double-booking and out-of-hours alerts, a day agenda, client follow-ups, utilisation and no-shows.

13 November 2026 6 min read

## In short

- The end time comes from the service length, and a staff member booked on overlapping times shows a red clash flag.
- Staff working days and hours flag any booking on a day off or outside hours.
- A day agenda shows each staff member in half-hour slots, and a follow-up list shows clients due to return.
- Utilisation per staff member, no-show rate and revenue appear in the summary with charts.

You run an appointment-based business: a consultant, lawyer, trainer, repair centre or a government-paperwork office, and you want to know at any moment: who has an appointment today and when, whether a staff member was booked twice at the same time, whether a booking fell on their day off, whom you should call about a return visit, and how much of your team's time is really used. The free [general appointments sheet](https://softwiro.com/templates/appointments-scheduler) answers all of that from one log. (The page is in Arabic; the workbook is Arabic, right to left.)

## The problem it solves

Appointments start in a notebook or on WhatsApp. Then the team grows, two people book the same staff member at the same time, a booking lands on a day the staff member does not work, and you forget a client you told to "come back in a month". It is hard to tell whether the issue is too few bookings, no-shows, or working hours nobody fills. An ordinary table does not know that a contract review takes 45 minutes and a device check 30, so it never warns you about an overlap.

## How it differs from the clinic and salon sheets

We have two close sheets, each with a different purpose:

- The clinic appointments sheet is built around the patient file: visits, the fee, what the patient owes and the follow-up date.
- The beauty salon bookings sheet is built around services, each staff member's commission and today's list.
- This sheet is built around staff time: each service's length, each person's working days and hours, clash prevention, a half-hour day agenda and utilisation. It suits any other business.

## How the sheet works, step by step

1. Settings: enter today's date, the day whose agenda you want and any date inside the summary month.
2. Services: for each, its length in minutes and price.
3. Staff: type "yes" under every day the person works, plus the start and end of their working hours.
4. Appointments: log date, time, service, staff member, client, phone and booking channel. The end time, price and alerts appear.
5. After the appointment: pick the status done, cancelled or no-show, enter what was paid and, if agreed, the next visit.
6. Day agenda, Follow-ups and Summary: each updates by itself from the appointments log.

## What each sheet holds

- Appointments: a red clash column and a yellow hours column: "day off" or "outside hours".
- Day agenda: staff in columns and half-hour slots in rows; the client's name in each booked slot, "clash" if two overlap, and a grey dash outside working hours.
- Follow-ups: clients with a next visit, sorted by date.
- Summary: three charts: revenue per staff member, their utilisation and each service's share of revenue.

## A walk-through on the sample numbers

The names and numbers below are sample data inside the sheet, not real people. The chosen month is October and today's date is 12 November. The team is four: a lawyer (Hossam Azmy), a business consultant (Mona Kamel), a repair technician (Tarek Nabil) and a paperwork officer (Iman Fawzy).

- October appointments: 85: 73 done, 4 cancelled and 8 no-shows. No-show rate = 8 / (73 + 8) = 9.9%.
- Revenue: 30,650 from the appointments that were done, about 420 per appointment. Collected is 30,300 and clients owe 350: for example a contract review for Al-Amal Company costs 500, 300 was paid, so 200 is left.
- Clash: on 5 October Tarek was booked for a device check 10:00-10:30 and then a repair 10:15-11:15, so both rows show "clash".
- Working hours: a legal consultation on Friday 9 October shows "day off" because Hossam does not work Fridays, and a business consultation at 19:00 shows "outside hours" because Mona's day ends at 15:00.
- Utilisation: Mona has 24.5 booked hours of 156 available, 15.7%; Hossam 15 of 126 (11.9%); Tarek 13 of 156 (8.3%); Iman 10 of 84 (11.9%). The whole team is at 12.0%.
- Revenue per staff member: Mona 13,600, Hossam 10,300, Tarek 4,350, Iman 2,400. The top service is the one-to-one training session: 11 sessions for 8,800.
- Agenda for 12 November: 5 appointments; Hossam has a consultation 10:00-11:00 and a contract review 10:15-11:00, so "clash" shows in the 10:30 slot.
- Follow-ups on 12 November: one overdue (Nadine Omar, due 2 November), one soon (Salwa Gaber, 14 November) and three upcoming. Adel Ramzy, who had a next visit written for 25 October, disappeared from the list because he booked a newer appointment under the same phone number.

## How the numbers are worked out

- End time = start + service length.
- Revenue = service price for "done" appointments only, and amount due = price - paid.
- Utilisation = hours of non-cancelled appointments / the staff member's available working hours in the month.
- No-show rate = no-shows / (done + no-shows).

## Common mistakes

- Forgetting to enter working hours: every booking for that person then shows "day off".
- Changing a service length after logging appointments: every old end time changes, so add a new service instead of editing the old one.
- Typing phone numbers in different formats: follow-ups match on the phone number, so a client who already booked can stay on the list.
- Leaving the status empty after the appointment: it counts as booked and adds no revenue.
- Ignoring today's date: type =TODAY() so follow-up labels stay current.

## When to move to a system

The sheet is enough for a small team with one person typing. If you want clients to book themselves from your page and see only free slots, to send automatic reminders, or to let each staff member see their agenda on a phone, that is a system's job. For clinics there is more detail in the [clinic appointments article](https://softwiro.com/blog/clinic-appointments-free-excel-online.html), and for cutting no-shows see [reducing patient no-shows with phone booking](https://softwiro.com/blog/reduce-clinic-no-shows-phone-booking.html); the ideas work for any appointment business.

## Try it now

[Open the sheet and try it online, or download the Excel file](https://softwiro.com/templates/appointments-scheduler). Clear the examples, type your services and staff with their hours, log tomorrow's appointments and open the day agenda to see the free time. It holds 1500 appointments, 50 staff and 40 services. If you want a version made for your business, [request it here](https://softwiro.com/request-sheet).

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: general appointments (1/3)](https://softwiro.com/uploads/cheatsheets/appointments-scheduler/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/appointments-scheduler/en-1.jpg)[![Cheat sheet: general appointments (2/3)](https://softwiro.com/uploads/cheatsheets/appointments-scheduler/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/appointments-scheduler/en-2.jpg)[![Cheat sheet: general appointments (3/3)](https://softwiro.com/uploads/cheatsheets/appointments-scheduler/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/appointments-scheduler/en-3.jpg)

0 downloads · 3 pages

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Questions this raises

### How is the end time worked out and how are clashes found?

End time = start time + the service length typed in the Services sheet. If an appointment overlaps another non-cancelled appointment for the same staff member, both rows show a red clash flag. An appointment that starts exactly when another ends is not a clash.

### How is this different from the clinic appointments and beauty salon sheets?

The clinic sheet is built around the patient file, visits and follow-ups; the salon sheet around services and each person's commission. This sheet is built around staff time: service lengths, working days and hours, clash prevention, a day agenda and utilisation. Use the clinic or salon sheet for those trades and this one for everything else.

### How do I know a staff member was booked on a day off or outside hours?

In the Staff sheet type yes under the days the person works and enter their start and end hours. The Hours column in Appointments then shows day off or outside hours for any booking that breaks that.

### How does the follow-up list work?

Enter the next visit on the client's latest done appointment. It stays in Follow-ups until the client books a newer appointment under the same phone number. It is overdue once the date passes, soon within 7 days, and upcoming after that.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
