How to get Public Holidays by Country

Get public holidays for any country and year from the free Nager.Date API - date, local name, English name, types, and regional coverage. date.nager.at is one page of it. A run reads that public list and saves one row per result.

One row per result

A row has Date, Local Name, Name, Country Code. The columns are listed in the schema on this page.

New rows from that site

Each run reads date.nager.at again. Put it on a schedule and the next file is the latest rows from that site.

Public Holidays by Country in Excel, Sheets, or Power BI

The rows are the same in each of those tools. The guide for the one you already use starts with a free Apify account and finishes with the file.

Schema

Examples come from the actor sample, not a live result.

Name	Description	Example
`date`	Date	`2026-01-01`
`localName`	Local Name	`New Year's Day`
`name`	Name	`New Year's Day`
`countryCode`	Country Code	`US`
`fixed`	Fixed	`false`
`global`	Global	`true`
`counties`	Counties	`128`
`types`	Types	`Public`
`sourceUrl`	Source Url	`https://date.nager.at/api/v3/PublicHolidays/2026/US`
`scrapedAt`	Scraped At	`2026-09-11T12:00:00+00:00`

dateDate2026-01-01
localNameLocal NameNew Year's Day
nameNameNew Year's Day
countryCodeCountry CodeUS
fixedFixedfalse
globalGlobaltrue
countiesCounties128
typesTypesPublic
sourceUrlSource Urlhttps://date.nager.at/api/v3/PublicHolidays/2026/US
scrapedAtScraped At2026-09-11T12:00:00+00:00