Appointment booking spreadsheet template. Free, and ready to become an app.
One workbook for a practice or a small service business: every appointment with its client, service, date, start and end time and status, a client list with how each client prefers to be contacted, the services you offer with their length and price, your staff with their role and availability, and a reminder log. Download it free. When clients should book their own times and each staff member should see only their own day, describe the same structure to Tadabase AI and it builds the booking app.
Excel · Google Sheets · Numbers · 5 sheets
Rather have it as an app? Describe it — we’ll build it now.
Same structure as the spreadsheet, plus logins, roles and workflows. Free to start.
5 sheets, already linked by ID.
Each sheet is one kind of record. The ID columns are how the sheets point at each other, and they are the same links the app version turns into real relationships.
-
Appointments
One row per appointment: the client's name, the service, the date, a start and an end time, and a status of Scheduled or Completed.
Appointment ID · Client Name · Service · Appointment Date · Start Time · End Time · Status
-
Clients
Each client with an ID, email, phone and the way they prefer to be contacted (Email or Phone in the sample rows).
Client ID · Name · Email · Phone · Preferred Contact Method
-
Services
What clients book: each service with its length in minutes and its price, for example a 30-minute Consultation at $50.
Service ID · Service Name · Duration (minutes) · Price
-
Staff
Who takes appointments: name, role, email, phone and a single Available or Unavailable flag.
Staff ID · Name · Role · Email · Phone · Availability
-
Reminders
One reminder per appointment, with the client, the date and time it should go out, and a status of Sent or Pending.
Reminder ID · Appointment ID · Client ID · Reminder Date · Reminder Time · Status
Fine for one person. Hard for a team.
Where the spreadsheet starts to cost you time once more people depend on it.
-
Nothing stops a double booking
Start and end times are typed as text ("10:00 AM"), and an appointment does not say which staff member it is with. The sheet cannot warn you that two clients are booked into the same hour with the same person, and the Staff sheet holds one Available or Unavailable flag, not working hours.
-
Reminders are a to-do list
The Reminders sheet records when each reminder is due and whether it went out, but nothing sends it: someone reads the sheet, contacts each client and changes Pending to Sent by hand. The status dropdowns stop after the two sample rows, and there is no Cancelled or No-show status.
-
Clients cannot book or see their own times
There is no way to let a client pick a free slot or see only their own appointments: sharing the file shares every client's name, email and phone. Appointments name the client by typing, while Reminders use the Client ID, so the two drift apart as the list grows.
Same structure, with logins and automations.
Start from a real prompt, change anything that doesn’t fit, then build it.
Loads this prompt into the prompt box- Appointment booking app An appointment booking app for a small service business with clients, staff, services, appointments and reminders. Each service has a length in minutes and a price; each staff member has working hours for each day of the week. Clients log in, choose a service, a staff member and a time, and see only their own appointments. Staff log in and see only their own schedule, as a calendar and as a list for today. An appointment is requested, confirmed, completed, cancelled or a no-show. Warn the front desk when a new appointment overlaps another one for the same staff member. Email the client when their appointment is confirmed and again the day before.
- Waitlist for cancelled slots A waitlist for a booking business — clients join the waitlist for a service and a preferred day; when an appointment is cancelled, everyone waiting for that service and day gets an email that a slot opened; the front desk sees who is waiting for each open slot and books one of them; and the owner sees how many cancelled slots were refilled from the waitlist each week.
- No-show follow-up A no-show tracker for a practice — every appointment ends as completed, cancelled or a no-show; a cancellation less than 24 hours before the start is flagged as late; a client with two no-shows in 90 days is flagged for the front desk to call, with the call and its outcome logged; and the owner sees the no-show rate per service and per staff member each month.
Starting from Appointment booking app
Opens the builder with your prompt. Free for 14 days, no card needed.
Questions about this template.
Is the spreadsheet template really free?
Yes. It is a normal .xlsx file that opens in Excel, Google Sheets or Numbers. No sign-up is needed to download it.
Does it work as an appointment booking template in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets, or use File, then Import, in a blank sheet. Every sheet comes across with its columns and sample rows.
Does the spreadsheet send appointment reminders?
No. The Reminders sheet is a log you update by hand, and the file has no formulas. In the app, a scheduled workflow emails each client before their appointment and records that it went out; the first prompt above asks for a confirmation and a reminder the day before.
Can clients book and see only their own appointments?
Not in the spreadsheet. In the app, yes: the AI sets up a client role that sees only their own appointments, a staff role limited to their own schedule and a front-desk role that sees everything. That rule is enforced on the server for every record, not by hiding rows.
Can I bring the data I already have in the spreadsheet?
Yes. Once the app is built, import each sheet into the matching table from a CSV or Excel file. The importer maps your columns to the fields and shows any row it could not bring in, and why.
When should I move from the spreadsheet to an app?
When more than one person edits it, when someone outside your team needs to see part of it, or when you start copying rows between tabs by hand. Those are the points where a spreadsheet starts losing data quietly.
Keep the structure. Lose the copy-paste.
Describe the app the spreadsheet was trying to be. Tadabase AI builds it with real logins, roles and workflows, and you can try it free for 14 days.
- 14-day free trial, no card
- Unlimited app users
- Live on your own domain