Public Holidays Calendar: 200+ Countries, States & Regions

Get public, bank and school holidays for 200+ countries and their regions, with no login, no browser and no code. Export to JSON, CSV or Excel, or use the API.

Get public, bank, school and observance holidays for 200+ countries and their states/regions (e.g. US-TX, DE-BY, CA-ON) for any years: date, local name, type, weekday and substitute-day flag. Runs offline on the open date-holidays dataset, so it's instant and cheap. Ideal for scheduling, payroll, delivery estimates and business-day calculations.

Use cases

• Business-day and delivery-date calculations
• Payroll and scheduling calendars for multi-country teams
• Avoid booking shoots or campaigns on local holidays

Input

Field	Type	Notes
countries	array	ISO codes, optionally with region: US, US-CA, GB, DE-BY, FR, JP.
years	array	Leave empty for this year and next.
types	array	Any of: public, bank, school, optional, observance. Empty = all.

Example input

{
 "countries": [
  "US",
  "US-TX",
  "GB",
  "DE-BY",
  "XX"
 ],
 "years": [
  "2026"
 ],
 "types": [
  "public",
  "bank"
 ]
}

Output

One dataset item per result. Main columns: region, country, date, name, type, weekday, substitute, source, license, error. A RUN_SUMMARY record is saved to the default key-value store. See the sample output in the Output tab.

Example output

{
  "region": "US",
  "country": "United States of America",
  "year": 2026,
  "date": "2026-01-01",
  "name": "New Year's Day",
  "type": "public",
  "weekday": "Thursday",
  "substitute": false,
  "start": "2026-01-01T05:00:00.000Z",
  "end": "2026-01-02T05:00:00.000Z",
  "rule": "01-01 and if sunday then next monday if saturday then previous friday",
  "source": "date-holidays (github.com/commenthol/date-holidays)",
  "license": "Data CC BY-SA 3.0; code ISC"
}

Pricing

Pay per result, with no monthly rental or subscription:

• Holiday record: $0.0002

Example: 1,000 results cost about $0.20 in fees. Apify's free plan includes $5 of monthly credit, which is enough to test this Actor.

FAQ

Do I need an account, cookies or a login for the source site? No. Public Holidays Calendar uses public data sources only, so there is nothing to connect and no account to risk.

How much will a run cost? You pay only for results delivered (see Pricing above), plus Apify platform usage, which the free plan's monthly credit easily covers for test runs. Start with a small limit to see the exact cost per run.

Can I export to CSV, Excel or Google Sheets? Yes. Every run's dataset can be downloaded as JSON, CSV, Excel, XML or HTML, or pushed to Google Sheets, Make, Zapier, n8n, Slack or a webhook through Apify integrations.

Can I run it on a schedule or from my own code? Yes. Add an Apify Schedule (hourly, daily, weekly) or call it through the Apify API / Python & JavaScript clients. It also works with AI agents through the Apify MCP server.

What happens if an input is invalid or a source is down? The run keeps going. The bad input gets a row with an error field so you can see what failed, and you are not charged for results that were not delivered.

Is this legal to use? It collects publicly available data. You are responsible for using the output in line with the source's terms and privacy laws such as GDPR/CCPA; don't use it for spam.

Something missing or broken? Open an issue on the Issues tab. Feature requests are usually added within a few days.

Scheduling / monitoring

Create a Schedule (daily/weekly) and connect a webhook or Slack/email integration.

Fair use

Official public APIs only, no login. Do not use output for spam or harassment. Respect the data sources' rate limits and terms.

Data attribution

Every output row carries source and license fields. Holiday data from the open-source date-holidays project (code ISC; data CC BY-SA 3.0).

REST API

GET https://api.mediaprotools.com/v1/public-holidays?items=... (header X-API-Key). Up to 25 items per call, separated by ,. Or POST {"items":[...],"options":{...}}.

Parameter	Type	Notes
items	token	ISO codes, optionally with region: US, US-CA, GB, DE-BY, FR, JP.
years	array	Leave empty for this year and next.
types	array	Any of: public, bank, school, optional, observance. Empty = all.

Output fields: country, date, end, error, license, name, region, rule, source, start, substitute, type, weekday, year.