Skip to content

Public Holidays in CSV/XLXS format

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

as Above in description


Response from
Ministry of Business Innovation and Employment

Other

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

7 Comments

  • Ministry of Business, Innovation and Employment (MBIE) (Ministry of Business Innovation and Employment)

    Thank you for your request.

    As noted in prior responses to this type of request, the Ministry of Business Innovation and Employment (MBIE) does not intend to produce a file of New Zealand public holidays at this time.

    A list of public holidays for 2024 and 2025 can be found on our Employment New Zealand website, at https://www.employment.govt.nz/leave-and-holidays/public-holidays/public-holidays-and-anniversary-dates/. The dates on this page are compiled in good faith from information provided to MBIE, and we can’t guarantee the accuracy of the information on this page.

    If needed, this information can also be supplemented with school holiday dates published by the Ministry of Education on its website, at https://www.education.govt.nz/school/school-terms-and-holiday-dates/.

    You may also be interested in advice about how to make a CSV file and then import it into your email programme online:

    • For Microsoft Outlook, at https://answers.microsoft.com/en-us/outlook_com/forum/all/import-csv-dates-file-into-specific-outlook/4bc2689a-0e3b-4de8-8e0e-8c50d758feba
    • For Google calendars, at https://support.google.com/calendar/answer/37118?hl=en&co=GENIE.Platform%3DDesktop

  • Philippa

    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

    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

    Has this been resolved

  • Russell Schaare (Requester)

    Can confirm .ics file is only valid up until 2018 dates. Not very useful...

  • Herbert Stevenson (Requester)

    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

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

Top