Hidden
Data / Business · Plainwork
World Public Holidays 2027 & 2028
Public holidays for 245 countries in Excel, CSV, JSON and calendar files, with a team planner.
One-time price, VAT includedExcel and Google SheetsDownload link by email
Try it
Use the real workbook before you buy.
Open the actual sheets of this file, see what each yellow area does, and change the key number to see what the workbook calculates.
Explore a preview with sample inputs. The downloadable workbook is the full product.
What you get
Built, tested, ready to use.
- 245 countries and territories, 2027 and 2028, in one filterable Excel sheet
- Team planner: pick up to 10 countries and a month and see who is off, with no formulas to write
- English and local-language holiday names, weekday and holiday type for every date
- 2,231 regional holidays for states, provinces and regions on a separate sheet
- 490 ready-made .ics calendar files for Google Calendar, Outlook and Apple Calendar
- CSV and JSON copies for payroll systems, shop back-ends and your own tools
In the download
- World-Public-Holidays-2027-2028.xlsx (Excel workbook: Start here, Team planner, All holidays, Regional holidays, Country summary, Weekends)
- csv/holidays-2027-2028.csv and csv/regional-holidays-2027-2028.csv
- json/holidays-2027-2028.json
- ics/ folder with 490 .ics calendar files (one per country per year)
- README.txt (calendar import guide) and LICENSE.txt
Personal or business use. Not for resale. Refunds: see our refund page.