Free template · Excel · Spanish labour calendar 2027 (BOE 13 Oct 2026)
Free Excel vacation template 2027 for Spain: annual planner per employee
A vacation grid with the 365 days of 2027 in columns, grouped by month, and one employee per row. You mark V, P, B or T and the template colours the cell, shades weekends and Spain's national public holidays from the BOE and calculates the days used and remaining. No sign-up, no macros. The template is in Spanish (the same file as the Spanish version of this page); sheet and column names are given below.
Compatible with Excel 2016 or later, LibreOffice Calc and Google Sheets (import). Standard formulas, conditional formatting and data validation; no macros.
What the 2027 vacation template includes
Five linked sheets: you fill in two and the other three calculate themselves.
Sheet 1
Cuadrante 2027 (grid)
30 employee rows and 365 columns grouped by month, with the weekday letter. Drop-down with V (vacaciones, vacation), P (permiso, paid leave), B (baja, sick leave) and T (teletrabajo, remote work); each code colours itself. Weekends in grey and public holidays in amber. “V / pend.” column with days used and remaining.
Sheet 2
Empleados (employees)
Name, department and entitlement under the collective agreement (30 by default). The columns for vacation used, remaining, paid leave, sick leave and remote work are calculated by formula from the grid; negative balances are flagged in red.
Sheet 3
Resumen por mes (monthly summary)
Vacation days of each employee in each month and total “person-days” per month, to see at a glance whether August is left without cover.
Sheet 4
Festivos (public holidays)
The nine Spanish national public holidays of 2027 loaded and checked against the BOE, a reference block with each autonomous community's own holidays and free rows for the two local holidays of your municipality. Whatever you add is coloured in the grid.
Sheet 5
Instrucciones (instructions)
How to fill it in, the legend, the applicable rules (articles 37 and 38 of the Estatuto de los Trabajadores, Spain's Workers' Statute) and an honest list of what the template does not do.
Format
No macros, no sign-up
53 KB .xlsx file with standard formulas (COUNTIF, WEEKDAY), conditional formatting and data validation. Frozen headers so you can scroll through the 365 days without losing the employee's name.
How to use the vacation planner in four steps
Designed to be maintained by one person in HR or administration without explanations.
1
Enter your staff
In the Empleados sheet: name, department and entitlement days. If your collective agreement counts in working days (22 or 23), enter that figure.
2
Complete the public holidays
The national ones are already there. Add those of your autonomous community (reference block in the same sheet) and the two local ones published by your regional or provincial gazette.
3
Mark the absences
In the grid, type V, P, B or T on the day. If you count in working days, do not mark weekends or public holidays; if you count in calendar days, mark them.
4
Check balances and cover
Empleados shows used and remaining; Resumen por mes, how many people are away each month. Communicate the dates two months in advance (art. 38.3 ET).
Spanish national public holidays 2027 included in the template
Checked against the Resolución de 8 de octubre de 2026, de la Dirección General de Trabajo (Spain's Directorate-General for Labour, BOE no. 254 of 13 October 2026). They are paid and non-recoverable throughout Spain; the autonomous communities add their own up to the maximum of 14 a year, two of them local.
Date
Day
Holiday
1 January
Friday
New Year's Day
6 January
Wednesday
Epiphany
26 March
Friday
Good Friday
1 May
Saturday
Labour Day
12 October
Tuesday
Spanish National Day
1 November
Monday
All Saints' Day
6 December
Monday
Spanish Constitution Day
8 December
Wednesday
Immaculate Conception
25 December
Saturday
Christmas Day
Maundy Thursday (25 March), Easter Monday (29 March), St Joseph's Day (19 March) and Monday 16 August are public holidays only in some autonomous communities: the Festivos sheet of the template brings the reference block by community so you can copy the ones that apply to you.
Which rules the template applies (and what it cannot do for you)
Vacation days. A minimum of 30 calendar days a year, not replaceable by financial compensation (art. 38.1 of the Estatuto de los Trabajadores, Spain's Workers' Statute). The collective agreement may improve it; the template takes the days you enter in Empleados.
Vacation calendar. It is set in each company and each person must know their dates at least two months before taking them (art. 38.3 ET). The annual grid is the simplest way to comply.
Public holidays. Up to 14 public holidays a year, paid and non-recoverable, two of which are local (art. 37.2 ET). The nine national ones for 2027 are already in the template; you add the regional and local ones.
Sick leave and vacation. If temporary incapacity coincides with vacation, it is taken afterwards, even after the year has ended, within the following 18 months (art. 38.3 ET). In the template, change the V to B and the days return to the balance.
Paid leave. The P covers the paid leave of art. 37.3 ET (marriage, bereavement, moving house, public duties, prenatal examinations…). The full table with days by degree of kinship is in the guide to paid leave in Spain.
Informative content; it does not replace the advice of your labour adviser or what your collective agreement says. Reviewed on 20 October 2026.
Honestly
Limits of the Excel vacation planner and when to move to software
For a company of ten or fifteen people with a single person in charge of the file, the Excel grid works. These are the signs that it is already costing you more than it saves.
Nobody sees the overlaps in time
The template adds up people per month, but it does not warn when two from the same team ask for the same week. You find out when it has already been granted.
Requests arrive by email or WhatsApp
Every request has to be copied by hand into the grid and answered through the same channel. With more than 20 people, Excel becomes a part-time job.
No trace of who approved what
A changed cell leaves no mark. If an employee claims days they “already requested”, you have no history to prove it, neither for the Labour Inspectorate nor for payroll.
Balances do not match payroll
Mid-year hires, seniority, carried-over days: every exception is a manual formula and an error that shows up in the December payroll.
Everyone sees everyone's sick leave
The B is health data (art. 9 GDPR). A shared file does not let each manager see only their team and HR the detail.
Several people edit the same file
“final-v3” versions, overwritten cells and broken formulas. When there is more than one editor, the grid stops being reliable.
The same logic, without Excel
Dokuflex's online vacation planner imports your Excel with a CSV template, the employee requests from the phone, the manager approves with a notification, overlaps are detected before approval and the days go to payroll without re-entering them. It is part of the leave and absence management software, free up to 10 employees and no card required; if you also clock in, the time tracking and digital clock-in software shares the same platform.
Frequently asked questions about vacation and the template
How many vacation days are employees entitled to by law in Spain?
A minimum of 30 calendar days a year (article 38.1 of the Estatuto de los Trabajadores, Spain's Workers' Statute). The collective agreement or the contract may improve that figure and express it in working days (for example, 22 or 23). Vacation cannot be replaced by money, unless the employment relationship ends before it is taken.
Which national public holidays are in the 2027 Spanish labour calendar?
Nine: 1 January, 6 January, 26 March (Good Friday), 1 May, 12 October, 1 November, 6 December, 8 December and 25 December, according to the Resolution of 8 October 2026 of the Dirección General de Trabajo (BOE of 13 October 2026). Each autonomous community adds its own up to a maximum of 14 a year, two of them local.
Is vacation counted in calendar days or working days?
The Workers' Statute sets the minimum in calendar days (30), but many collective agreements translate it into working days (22 or 23). In the template, enter in the Empleados sheet the days your agreement states and mark with V only the days that count: if they are working days, do not mark Saturdays, Sundays or public holidays; if they are calendar days, mark them too.
How far in advance must an employee know their vacation dates?
At least two months before they start (article 38.3 of the Estatuto de los Trabajadores). The vacation calendar is set in each company in accordance with the collective agreement, which is why it pays to have the year's grid closed in the first months.
What happens if sick leave coincides with vacation?
If temporary incapacity prevents the employee from taking their vacation, they may take it later, even after the calendar year has ended, provided no more than 18 months have passed since the end of the year in which it accrued (article 38.3 of the Workers' Statute). In the template, change the V to B on the sick-leave days and the vacation counts as pending again.
When is it worth replacing the Excel template with vacation software?
When two people in the same team request the same dates and nobody sees it until it is too late, when balances do not match payroll, when every request arrives by email or WhatsApp and has to be copied by hand into Excel, or when more than one person edits the file. From then on, an online vacation planner with requests and approvals from the phone saves more time than it costs. If you also record working time, the Excel working time register template is this one's sister.
