Japan
16 holidays
Local names in Japanese, from Coming of Age Day to Culture Day.
Every public holiday, in your Google Sheet.
Pick a country and a year. Every holiday shows up, with its local name and the day of the week. 204 countries. No API key.
Free. Log in with your email to get your own copy.
- countries
- 204
- countries
- US holidays in 2027
- 17
- US holidays in 2027
- US long weekends in 2027
- 8
- US long weekends in 2027
- API keys needed
- 0
- API keys needed
Pick any country
Same sheet, one dropdown. Here's what 2027 looks like in six of them.
Germany
19 holidays
Every state holiday too, from Epiphany to Reformation Day.
Brazil
15 holidays
Two days of Carnival in February, and Tiradentes in April.
France
11 holidays
Bastille Day lands on a Wednesday in 2027.
Mexico
9 holidays
Constitution Day and Benito Juárez's birthday both fall on Mondays.
United States
17 holidays
11 are nationwide. The sheet shows which states get the rest.
Find the long weekends first
The US gets 6 three day weekends in 2027 without using a single vacation day.
Take Friday 12 November and Friday 26 November off and you get two more four day weekends, after Veterans Day and Thanksgiving.
Holidays that land on a weekend get flagged, so you can check if your day off moves.
Know who's actually off
The US has 17 holidays in 2027, but only 11 are nationwide.
Lincoln's Birthday is in 9 states. Good Friday is a public holiday in 10 and optional in Texas. Every row says where it applies.
Running a team across states or countries? Tick Nationwide only, or check each place in its own tab.
Formulas you can type anywhere
Every tab runs on these. Use them in your own sheets too.
=PUBLICHOLIDAYS("Canada", 2027)
Every holiday in a year. Canada has 31, and 8 are nationwide.
=LONGWEEKENDS("US", 2027)
Every 3 and 4 day weekend, and which day to take off.
=HOLIDAYSBETWEEN("UK", start, end)
Holidays between two dates, even across years.
=HOLIDAYCOUNTRIES()
All 204 countries the free API covers.
Dates come back as real dates, so NETWORKDAYS works on them. The Working days tab counts 254 working days in Canada in 2027.
Read the full guide: how to get public holidays into Google Sheets with a free API →
Who it's for
Planning your year
Put the holidays on your calendar before the year fills up.
Running a team
See which days people are off, by state or province.
Remote teams
Check holidays for every country your team lives in.
Booking a trip
Find the long weekends first, then use fewer vacation days.
Payroll and project plans
Count working days without typing a single holiday.
Rotas and shift work
Mark every holiday on the rota before the month starts.
Plan around these holidays
You've got the dates. Now put them where you'll see them.
Big Year is my free one page yearly calendar in Google Sheets. Add your holidays and they light up on every layout.
Plan around these holidays with Big Year
Questions
Is it free?
Yes. Log in free with your email and copy the sheet to your Google Drive. The holiday data comes from Nager.Date, a free public holidays API.
Do I need an API key?
No. There's nothing to sign up for. The sheet calls the API for you.
Which countries does it cover?
204. Type =HOLIDAYCOUNTRIES() in any cell to see them all. A few, like United Arab Emirates and India, aren't in the free API yet. The sheet tells you that in plain words instead of breaking.
Which years?
About one year back and five years ahead. Right now that's 2025 to 2031.
What if a holiday lands on a weekend?
The sheet shows the real date and flags it. Many countries move the day off to the Friday or the Monday, so check your own rule for those.
Does it include state and province holidays?
Yes. Every holiday says where it applies. Tick Nationwide only to hide the local ones.
Can I use the formulas in my own sheets?
Yes. =PUBLICHOLIDAYS, =LONGWEEKENDS and =HOLIDAYSBETWEEN work in any cell of your copy, and the dates come back as real dates, so NETWORKDAYS and filters work on them.
Can I see how it works?
Yes. The Apps Script is commented line by line. Open Extensions, then Apps Script in your copy. The full guide on the blog walks through every tab and formula.
Stop typing holidays by hand
One dropdown, 204 countries, your own copy in Google Drive.
Free login. Holiday data from Nager.Date.