Skip to main content

FMI Consulting

Resources › Excel templates
Free downloads

Free Excel templates for scheduling

Ready-made calendars, holiday plan, work shifts and project Gantt

Five Excel files to plan a team of up to 10 people. Choose a start date and an end date and the calendar builds itself, with weekends and public holidays shaded. Download, fill in and use.

Download the Excel templates

Pick the plan you need. Every file is free, has an instruction sheet and an example to start from.

Weekly planner in Excel with ten people, morning and afternoon rows, week numbers and a shaded public holiday columnWeekly calendar

Weekly calendar for up to 10 people

Excel .xlsx · up to 8 weeks · morning and afternoon · 42 KB

A week-by-week plan with a morning and an afternoon slot for each person. Choose the dates: the calendar starts on Monday, shows the week numbers and shades weekends and public holidays.

Download the template ↓

Monthly planner in Excel with one row per person, one column per day and the January holidays shadedMonthly calendar

Monthly calendar by person

Excel .xlsx · up to 62 days · 10 people · 39 KB

One row for each person and one column for each day. Write the client, the job or a short code in the day cell and see how many days each person is planned.

Download the template ↓

Holiday planner in Excel where the cells marked F are red, with holidays taken and remaining for ten peopleHoliday plan

Holiday plan and absences

Excel .xlsx · up to 366 days · 10 people · 65 KB

Type F in a cell and it turns red, with the text staying black. P marks a leave and M an illness. Holidays taken and left are counted for each person, and a row shows how many people are away each day.

Download the template ↓

Shift schedule in Excel with colour-coded morning, afternoon, night and rest shifts, total hours and daily coverageWork shifts

Work shift schedule

Excel .xlsx · up to 62 days · 10 people · 42 KB

Morning, afternoon, night, day and rest shifts in one colour-coded grid. Total hours for each person and the daily coverage of every shift are calculated under the grid.

Download the template ↓

Gantt chart in Excel with five project phases drawn as coloured bars, the people involved and milestone markersProject plan

Project plan with Gantt chart and milestones

Excel .xlsx · up to 120 days · 10 people · 66 KB

Dates across the top and phases down the side, with the people involved, progress and milestones. The example is a project of 5 phases of 10 working days, with 2 people on each phase.

Download the template ↓

Illustration: an Excel shift plan with one row per cleaner fades into the shared Google Calendar week of one cleanerWorked example

Shift plan for a cleaning company

Excel .xlsx · in Italian · 8 sheets · 40 clients, 20 people · 133 KB

A full month of shifts with costs, hours and a printout for each person, built with an AI assistant. Not a template: an example to study and adapt, with invented clients and addresses.

Read the guide and download →

Monthly timesheet summary in Excel: hours, overtime, travel, kilometres, expenses, leave and sick days for each technician, with the monthly totalsTimesheet report

Timesheet and job-costing report

Excel .xlsx · in Italian · 2 sheets · 20 technicians · 56 KB

A real month of hours, travel, kilometres and expenses by technician, client and job order, produced automatically by PlanningConnect. Not a template: an example of what you can get without re-typing.

See the report and download →

Diagram: download the Excel template, load it in Reports, set the period and export the data from PlanningPME Web Access to Excel (in Italian)Only for Web Access customers

Export templates for PlanningPME Web Access

Excel .xlsx · in Italian · 4 report templates

Not a spreadsheet to fill in: four report templates to load in PlanningPME Web Access and reuse at every extraction, with activity progress, staff absences and activity detail.

Get the export templates →

Beyond the file

Need to share the plan with your team?

A file is a good start for one person or a small team. When many people have to work on the same plan, a shared calendar saves time and avoids duplicated versions.

Read the guide →

How the templates work

Three steps from download to a plan you can share or print.

Step 1

Download

Choose the template that fits your plan and open the .xlsx file in Excel.

Step 2

Set dates and names

Write the start and the end date in the two highlighted cells and replace Collaboratore 1–10 with the names of your team.

Step 3

Fill in the grid

Write activities, codes or the letter F for holidays. Weekends and public holidays are shaded by the template, and totals update by themselves.

What every template includes

The same logic and the same look in all five files, so you can use them together.

Perpetual calendar

The days of the calendar come from your start and end dates. The same file works for any month, quarter or year, up to the length each template shows.

Weekends and public holidays in view

Saturdays and Sundays have a soft grey background and holidays a soft yellow one. Italian national holidays, Easter included, are calculated for you; you can add your own closures.

Up to 10 people

Ten rows named Collaboratore 1 to 10, ready to be renamed. Totals, such as days planned, holidays left or hours worked, are formulas that update as you type.

Instructions and examples

Each file has an instruction sheet with the colour legend and an example in the first rows that shows how it works. Delete the example and start with your data.

When a spreadsheet is enough, and when it is not

These templates are made for what Excel does well: one person or a small team, a plan that lives in a single file and is updated by one person at a time. They are free and you can start in a few minutes.

When several people have to update the same plan, when absences and overlaps must be checked for you, or when the plan has to follow the job from the office to the field, a shared schedule saves time. FMI Consulting is the Approved Reseller of PlanningPME for Italy: PlanningPME is a shared calendar for people, machines and vehicles, and PlanningConnect adds automations, analysis and the connection to your ERP.

Guide · Spreadsheets

Excel for scheduling: where it stops working and what PlanningPME adds

Where a spreadsheet is enough, where it stops, and how PlanningPME compares on sharing, absences, conflicts and skills.

Read the guide →

Guide · Project planning

Project planning software: planning the work is half the job

Plan the sequence first and name the people later, and see how PlanningPME sits next to your project tool.

Read the guide →

Solutions

Scheduling for your sector

See how companies in industrial assembly, cleaning, installation and maintenance and event production plan their teams.

Browse industries →

Questions about the Excel templates

Short answers about the files, the calendar and the holidays.

Are the Excel templates really free?
Yes. You can download the five files for free, without signing up, and adapt them to your own work.
In which language are the templates?
The templates are in Italian: sheet names, labels, instructions and weekday abbreviations. Names and activities can be written in any language.
How does the perpetual calendar work?
You enter a start date and an end date. Month, week, weekday and day headers are rebuilt from those two dates, so the same file works for any month or year, up to the length each template shows.
Are public holidays included?
Yes. Italian national holidays, including Easter and Easter Monday, are calculated for the year of the start date and the two following years. In the Festivi sheet you can add local holidays and company closures, or replace the list with the holidays of another country.
How many people can I plan?
Each template has ten rows, named Collaboratore 1 to Collaboratore 10 (team member 1 to 10). Type over the names with your own. The examples in the first rows can be deleted.
Which version of Excel do I need?
The files are standard .xlsx workbooks that use common Excel functions and conditional formatting. We recommend Excel 2010 or later.
When is it better to move from Excel to a shared schedule?
When several people have to update the same plan, or when absences and overlaps must be checked for you. Our guide Excel for scheduling: where it stops working explains where the limits are and what PlanningPME adds.

Ready to plan with a calendar the whole team can update?