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. A run saves one row per result.

One row per result

Each saved row is one result.

The next run

Put the run on a schedule and the next file is the latest rows.

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.