Loading page
FeaturesFree Excel template
Year Planner 2027 with German Public Holidays
Built for teams based in Germany: holidays for all 16 federal states, ISO calendar weeks, one sheet per year.
This planner is made for Germany. It knows the public holidays of every German federal state and nothing else, so it only makes sense if your team works there. Download it, pick a state, enter leave and appointments. The Excel file calculates holidays and weekends itself and is set up for one A4 page, so you can print it or save it as PDF. A ready PDF sits next to it. Labels in the file are in German. No sign-up.
Download the 2027 year planner
Both files are free to use, including at work. The Excel file opens in Excel and LibreOffice. Sheet labels and holiday names are in German.
Year planner 2027 for Excel
Year and federal state via dropdown, German public holidays and calendar weeks calculated, one note field per day. Prints to a single A4 page as PDF via File, Print.
XLSX, two sheets, 38 KBDownload Excel template
Year planner 2027 to print
One A4 page in portrait with the nationwide German public holidays. For the pinboard, the desk or the kitchen.
PDF, A4, one pageDownload PDF
Calendar 2027 in Excel: choose year and federal state
Two cells control the file. Excel calculates the rest.
Year and federal state
Enter the year in cell C1 and pick a German federal state in G1, or DE for the nationwide holidays. Days, month markers and calendar weeks rearrange themselves, for 2028 or any other year.
Holidays appear on their own
Fixed and movable holidays show in red with their German names. Easter, Ascension, Whitsun and Corpus Christi are recalculated for every year. Saturdays and Sundays are shaded grey.
All 16 federal states on one sheet
The Feiertage sheet lists 19 holidays with date and one column per state. Add your own days, such as company holidays, in the empty rows below with an x in your state's column. They then show up in the calendar.
German public holidays 2027 by federal state
The same list sits in the Feiertage sheet of the Excel file. Nationwide means: in all 16 states.
| Holiday | Date | Federal states |
|---|---|---|
| New Year's Day (Neujahr) | nationwide | |
| Epiphany (Heilige Drei Könige) | Baden-Württemberg, Bavaria, Saxony-Anhalt | |
| International Women's Day | Berlin, Mecklenburg-Vorpommern | |
| Good Friday (Karfreitag) | nationwide | |
| Easter Sunday | Brandenburg | |
| Easter Monday (Ostermontag) | nationwide | |
| Labour Day (Tag der Arbeit) | nationwide | |
| Ascension Day (Christi Himmelfahrt) | nationwide | |
| Whit Sunday | Brandenburg | |
| Whit Monday (Pfingstmontag) | nationwide | |
| Corpus Christi (Fronleichnam) | Baden-Württemberg, Bavaria, Hesse, North Rhine-Westphalia, Rhineland-Palatinate, Saarland | |
| Assumption Day (Mariä Himmelfahrt) | Saarland | |
| World Children's Day | Thuringia | |
| German Unity Day | nationwide | |
| Reformation Day | Brandenburg, Bremen, Hamburg, Mecklenburg-Vorpommern, Lower Saxony, Saxony, Saxony-Anhalt, Schleswig-Holstein, Thuringia | |
| All Saints' Day (Allerheiligen) | Baden-Württemberg, Bavaria, North Rhine-Westphalia, Rhineland-Palatinate, Saarland | |
| Day of Repentance (Buß- und Bettag) | Saxony | |
| Christmas Day | nationwide | |
| Boxing Day (2. Weihnachtstag) | nationwide |
Assumption Day applies in Bavaria only in municipalities with a predominantly Catholic population. Based on the public holiday acts of the federal states, as of November 2026.
When the year planner is no longer enough
For one person or a small team the spreadsheet is the right tool. You see the year at a glance and enter leave in seconds.
With more people come questions a spreadsheet does not answer: who still has how much leave left? Do two absences overlap on the same project? Who approved the request? Then you maintain several files and reconcile them by hand.
In QUANTICAL.ERP employees request their own leave, half days included. Managers approve with one click, remaining leave and public holidays by federal state are calculated by the system. The hours those same people book sit next to it, ready for timesheets and invoices.
Leave management in QUANTICAL.ERP →Plan team leave in a system, not a spreadsheet
QUANTICAL.ERP books hours, manages leave and travel expenses and writes invoices from the booked time. Free for 90 days, then 12.90 € per user and month plus VAT.
Try free for 90 daysFrequently asked questions
Is the year planner really free?
Yes. No account, no email address. You download the file and use it privately or at work. The link to QUANTICAL.ERP at the bottom of the sheet is the only reference to us.
Which public holidays apply in North Rhine-Westphalia in 2027?
North Rhine-Westphalia has eleven public holidays in 2027: New Year's Day, Good Friday, Easter Monday, Labour Day, Ascension Day, Whit Monday, Corpus Christi, German Unity Day, All Saints' Day, Christmas Day and Boxing Day. Choose NW in cell G1 for this.
Can I save the year planner as PDF?
Yes. The Excel file is set up for one A4 page in portrait. Via File, Print and "Save as PDF" you get a PDF with the holidays of your chosen state. The ready PDF above contains the nationwide holidays only.
Why are school holidays missing?
The German states set school holidays anew every year. A template with them built in goes stale quickly. Enter them like leave: one word in the field next to the day.
Does the file work in LibreOffice or Google Sheets?
In LibreOffice yes, that is what we tested the file with. Google Sheets and Numbers open it too, the formulas are standard functions. We have not tested the dropdown and colour rules there.
Can I switch the year to 2028?
Yes. Change the year in cell C1. The file recalculates all days and holidays, the movable ones included. This works for any year between 2000 and 2100.