Technician schedule in Excel: a weekly template to copy, and where it falls short

What goes into a technician schedule in Excel?

A schedule in Excel shows, for each technician, what they do and when, usually for one week. There are two layouts. A grid puts the technicians in rows and, for each day, a morning and an afternoon in columns. A list has one row per intervention, with the date, time window, technician, customer, address and status. The grid gives the overview, the list the details.

In a service company, that schedule has to absorb four things:

• urgent calls that come in mid-week;
• leave, sickness and training;
• travel between customers in different municipalities;
• technicians who are on the road and do not open the file.

How to plan a week well, with a single queue and room for the unexpected, is covered in scheduling technicians. This article is about the Excel file itself.

The weekly schedule in Excel: the grid

The grid hangs on the wall or goes to the technicians. An example with the first three days; Thursday and Friday follow the same pattern.

Four conventions make the grid readable:

• The date in the header. “Mon 2/11” rather than “Mon”, so nobody mistakes an old week for the new one.
• Keep each cell short. The work and the region. The address, contact person and access go in the list or on the work order.
• A free slot is visible. Write “Free for urgent work” in the cell. An empty cell looks forgotten.
• Freeze the first row and column. With Excel’s Freeze Panes, the names and the days stay in view as you scroll.

Making a schedule in Excel: one row per intervention

From a handful of interventions a day, not everything fits in a cell any more. A list then works better: one row per intervention, with a filter on every column.

How to use the list:

• An intervention without a date stays in. With the status To schedule and an empty date, it goes to the top when you sort. That is your queue.
• The status comes from a drop-down list. For example To schedule, Scheduled, Confirmed, Completed and To reschedule. With Excel’s Data Validation, nobody types their own variant.
• A Notes column for what the technician needs to know, such as where the key is.
• A filter per technician gives their week, ready to print or to send as a PDF.

Colour codes everyone understands

Choose few colours and put their meaning next to the schedule. An example:

Always put the meaning in text as well. A black-and-white printout loses the colours, and a colleague who has trouble telling red from green can still read the text.

Urgent calls, leave and travel

Urgent calls

When an urgent call comes in, fill the “Free for urgent work” slot of the technician working closest by. If other work has to give way, set that intervention to To reschedule, with the reason, and call the customer. Call the technician too: they will not notice a changed file by themselves.

Leave and public holidays

Enter leave, training and public holidays in the grid before you schedule work, taken from your technician leave planning.

Belgium has ten statutory public holidays. If a public holiday falls on a Sunday or on a day your company does not normally work, it is replaced by a day off on a normal working day (FPS Employment, in Dutch). For example, 1 November 2026 falls on a Sunday. Ask your social secretariat (payroll provider) which replacement day applies to your company before you colour it grey.

Travel

Put the municipality or the region in its own column and sort each day by region. Leave time for the drive between two interventions, and count the first drive if the technician leaves from home. The order of a day with several addresses is covered in route planning with multiple stops.

Recurring maintenance is planned ahead in a separate maintenance schedule in Excel. The weekly schedule only contains that week’s visits.

Sharing the schedule with the technicians

1. One person changes the schedule. The others read it.
2. Every version gets a date and a time. In the file name or at the top of the grid, for example “Week 45, version Monday 10am”.
3. One place for the file. A shared folder, read-only for the technicians. Or, on Friday, a PDF per technician with their week.
4. Changes during the day go by phone. A technician does not open the file between two customers. Call them, and only then update the file.
5. The technician reports back. What is completed, what is not and why. The office sets the status in the list.

An example: a heating company’s week

A heating company with four technicians schedules in Excel. On Friday, the planner puts the next week’s maintenance visits in the list. They fill the grid by region and, each day, keep half a day free for urgent work with one technician. Each technician gets their week as a PDF.

At nine on Monday, a shopkeeper reports that the heating in their shop has failed. The planner puts the repair in the free slot of the technician in that region, calls the technician and the customer, and sets the status to Urgent in the list. On Wednesday, a technician calls in sick. The planner colours their day grey, sets their two maintenance visits to To reschedule and calls the customers for a new date.

On Friday, accounts filters the list on Completed. For the hours and the parts, they look up the work orders separately.

Where Excel falls short

• Changes during the day. The file changes, but the technician does not notice. Every change takes a phone call.
• Two people in the same file. If two colleagues each work in their own copy, a change gets lost or two versions exist side by side.
• Conflicts stay invisible. Excel does not warn you about an intervention on a day of leave or two interventions at the same time, unless you build the formulas for it yourself.
• The work order and the invoice are separate. The status Completed does not say which hours and parts are on the work order. See from work order to invoice.
• The status does not come back by itself. Whether the technician is on the way, on site or finished, the office only knows when they call.

How it works in Digitalnatie Service Suite

In the planning and service orders module, the schedule replaces the grid and the list. Every change is saved immediately.

• The views: day, week, map and routes. The week view shows one line per technician and one column per day, with the scheduled hours per day. In the day view, you schedule to the quarter of an hour.
• Unscheduled interventions: the queue of interventions without a technician or without a date, which you can filter on urgent interventions and breakdowns.
• Conflicts: while dragging, you see another intervention, leave or a time outside working hours. A double booking gets a red border, work on a day of leave an orange border, and the conflict counter distinguishes double bookings, work outside working hours and work on a day off.
• Leave: an approved absence appears on the technician’s line, as leave or a public holiday. Service Suite refuses to schedule on it, just as it does outside working hours; an administrator or a manager can schedule anyway, with a reason.
• Map and routes: the day’s interventions on the map, fixed routes per technician and per weekday, and route optimisation for the order of the visits.
• The technician: they see their work per day or per week in the calendar of the technician app. The app fetches the changes when it opens and then every minute.
• From intervention to invoice: on a completed intervention, accounts creates the invoice: a draft invoice takes over the billable hours and the parts used.

Good to know:

• There are no push notifications. Call the technician about a change during the day.
• When an absence is approved afterwards, a notice lists the work that was already scheduled. Nothing is moved automatically.
• Route optimisation does not change the scheduled times; you adjust them yourself.
• You cannot drag an intervention on a smartphone or from the map. The positions on the map are those of the last action in the app, not live GPS tracking.
• The data import takes over customers, sites, installations and maintenance contracts, among other things, but not interventions. You put the appointments from your current Excel schedule in the schedule yourself.
• The application and the guide are available in Dutch, French and English.

Frequently asked questions

How do I make a technician schedule in Excel?

Choose a grid with the technicians in rows and, for each day, a morning and an afternoon in columns, or a list with one row per intervention: date, time window, technician, customer, address, work and status. Enter leave and public holidays first, keep a slot free for urgent work and give each status a fixed colour and text.

Is there a free example or template for a schedule in Excel?

This page has no file to download. It contains two examples to copy, a grid by half-day and a list with one row per intervention, and a table of colour codes. Copy them into a blank Excel file, one per tab.

How do I share an Excel schedule with my technicians?

Let one person change the schedule and keep the file in one place, read-only for the technicians, or send each technician their week as a PDF. Pass on changes during the day by phone.

When is a schedule in Excel no longer enough?

When the schedule changes several times a day, when two people schedule at the same time, or when you have to look up the hours and parts separately for the invoice. Excel also does not warn you about an intervention on a day of leave or a double booking.

Does a technician get a notification when I change the schedule in Service Suite?

No, there are no push notifications. The technician’s app fetches the changes when it opens and then every minute. So call the technician about an urgent change.