How to add Public Holiday Calendar to Sharepoint Calendar?

Question

Hi, I have a SharePoint Calendar that is accessible to my entire organization. I would like to add public holidays in Malaysia so they appear automatically in this calendar.

May I know how to import public holiday data into a SharePoint Calendar, or how to configure the calendar to display public holidays?

Any guidance or recommended method would be appreciated.

Answer 1

Dear @Khairul Ariff Halim,

SharePoint Online does not have a built‑in feature to automatically add or subscribe to public holiday calendars. There is no direct and effective method in SharePoint online to add holidays automatically.

1.As a workaround, you could sync the calendar list to Outlook:

• If you do not see the ribbon as shown in the image, please proceed as follows:
• In the upper-right corner, select Return to classic SharePoint (or access the page using a URL in the format /Lists/Calendar/calendar.aspx).
• Once you switch back to the Classic experience, the ribbon will appear at the top of the page.

2.Then add holidays to your calendar in Outlook for Windows

3.After you add all the holidays to your Outlook calendar, open up the SharePoint Calendar in Outlook - Drag and Drop the events from Outlook to the SharePoint Calendar in Outlook. Holidays added to SharePoint Group Calendar through Outlook will be synced immediately.

I hope this helps. Your understanding and co-operation are highly appreciated. Thank you for your precious time. I am looking forward to your response!

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.