Public Holidays in CSV/XLXS format

12 April 2018 at 11:56 (7 years ago)

Current there is a Public Holidays Dataset, but only available as PDF. Could this dataset also be made available as CSV or XLSX or potentially another format (REST API JSON) that could be digested by software. We synchronize our internal system with public holidays, and presently its a manual process. Would love to be able to write some software that makes a automated call (perhaps once a year) to update our data

Opening this data would solve the problem of…

as Above in description

Response from
Ministry of Business Innovation and Employment

8 May 2018 at 11:16 11:16 am (6 years ago)

Status Other

Comments Data is already available for download, as referenced in PDF, at http://apps.employment.govt.nz/ical/public-holidays-all.ics

6 Comments

Philippa 7 October 2024 at 15:32 03:32 pm (25 days ago)

Hey team,
The above mentioned link to a PDF (http://apps.employment.govt.nz/ical/public-holidays-all.ics) a) doesn't appear to be a PDF but a outlook calendar file, and b) doesn't work.
Having a historical and future public holiday calendar in csv form would be very helpful and plus much more usable than a PDF you then have to manually convert to a something machine readable.
Thanks :)
Brent McSharry 31 October 2021 at 18:20 06:20 pm (3 years ago)

I got tired of trying to get an API to serve public holiday data so I put (a free/non-commercial) one up myself at . Feel free to use if this meets your needs (serves json or text/calendar)
Tendai Masamba 24 September 2021 at 10:45 10:45 am (3 years ago)

Has this been resolved
Russell Schaare (Requester) 11 December 2020 at 14:00 02:00 pm (4 years ago)

Can confirm .ics file is only valid up until 2018 dates. Not very useful...
Herbert Stevenson (Requester) 8 May 2020 at 09:14 09:14 am (4 years ago)

I agree with the above comments. I had to complete these steps for this to be exported as a .csv
https://smallbusiness.chron.com/convert-ical-csv-45527.html
Tai Yu Lin 22 January 2020 at 15:04 03:04 pm (5 years ago)

The ics in the link provided is only up to 2018. An API would be a better way to provide the data.