Appointments can pile up fast when you are juggling client bookings, follow-ups, breaks, paperwork time, and last-minute changes. This appointment schedule template is designed for planning a five-day block of time in a grid that is easy to scan, update, and print. It works for clinics, salons, consultants, tutors, coaches, service providers, and office teams that want a visual schedule where each time slot can carry both an appointment note and a quick status marker.
The template includes a time column on the left and five day columns across the top. Each day is split into two parts, a small status cell and a wider notes cell. You can use the status cell for an icon to indicate the current status and the notes cell for the appointment details, such as a client name, service type, room, or short reminder. Here’s a breakdown of the template to use it effectively.
Setting the Dates, Start Time, and Interval
At the top of the sheet, you can adjust the schedule using three inputs. Start Date controls the first day in the header, and the template fills the remaining four day headers automatically so your five-day schedule can begin on any date. Start Time controls the first time shown on the left, and the template continues the timeline from that starting point. Interval sets the time step between rows, which is set to 30 minutes by default but can be changed if you need a different booking rhythm. If you prefer a shorter visible day, you can hide the rows outside your working hours so the printed schedule stays focused.
Adding Appointments to the Schedule
Each appointment slot uses two cells.
First, type your appointment note in the wider cell. Keep it short so the schedule stays readable when you print it. If you need extra detail, add one short line such as a room number, a phone call label, or a document reminder.
Next, select the status icon in the small cell beside the note. The icon cell has a dropdown list, so you do not need to memorize symbols or type them manually. When you choose an icon, conditional formatting fills the icon cell and the matching notes cell with a related color, so the status stands out across the day.
What the Legend Means and How the Icons Format the Schedule
The legend on the right shows the icons available in the dropdown and what each one means. The same icons drive the color tagging inside the schedule grid.
- ✔ Appointment confirmed shows that the booking is locked in.
- ✖ No show marks a missed appointment.
- ⚑ Need to confirm flags a slot that still needs a call, text, or email confirmation.
- ○ Out of office or break marks lunch, breaks, off-site time, or blocked personal time.
- ★ Special condition marks appointments that need extra prep, longer time, specific equipment, or priority handling.
- Gray out completed is triggered when the icon cell is left blank for that slot and you label the appointment as completed in the notes cell. The formatting shifts the text style so completed items look visually separated from active bookings.
If you want status colors to stay meaningful, use the icons for status only, then use the notes cell for the appointment name or task. Mixing status and notes inside the icon cell can make the color tagging less useful.
Adjusting the Template for Different Scheduling Styles
If you manage more than one provider or room, you have a few practical options.
You can keep one copy of the file per provider, such as one for each doctor, stylist, or consultant. You can also duplicate the schedule sheet and label tabs by room or team member, so everyone uses the same icon system.
If your work week includes weekends, you can extend the header area by adding more day columns and copying the same two-cell pattern for each new day. Use the existing day columns as your reference so the icon dropdown and formatting remain aligned.
If you reduce the interval to a smaller number, such as 15 minutes, the visible time range covered by the current number of rows becomes shorter. If you want the schedule to cover a full day at a smaller interval, extend the time formulas downward to add more rows.
Printing and Sharing Notes
For printing, the schedule reads best in landscape orientation with the page scaled to fit the width. If you hide unused time rows first, the printout becomes easier to review at a desk or front counter. If you share the file with staff, consider keeping client-sensitive details out of the notes cell unless the file is stored in a private workspace with appropriate access.
Excel and Google Sheets Versions
This appointment schedule template is available in Excel and Google Sheets, so you can use it as a spreadsheet on your computer or share it with a team through a cloud-based file. If you work in Excel, you can keep separate copies for different staff members or locations. If you use Google Sheets, you can share one live schedule, control access for different roles, and keep updates visible to everyone who needs the latest version.
FAQs
Yes. Add a new icon and label in the legend area, then update the dropdown source range to include the new row. After that, add a matching conditional formatting rule that references the new icon cell so the schedule colors match your new status.
Yes. Set the start time to your opening hour, then hide the rows that fall outside your working window. If you want the sheet to stop earlier, you can also hide the bottom rows before printing or sharing.
Yes. Copy both the icon cell and the notes cell for each time slot so the status and the color tagging transfer together. If you copy only the notes cell, the appointment text moves but the status may not match.
