Bulk-import your entire holiday calendar from an Excel file — match columns, fix validation errors inline, and publish in one pass.
To import the holiday list, you need to navigate to the CoreHR → Employee Data Management → Published Holidays tab and click on the Three Dots and select Import Holidays.
After you select the option, you will see the pop-up showing you the steps of importing as well as providing you with some instructions.
Download the editable excel template by clicking on the Download button.
Open the file and enter the holiday details, including Holiday Name, Location or Custom Group (based on configuration), Holiday Type, Start and End Date, and Description.
Once the details are updated, upload the file back into the system by clicking Choose a file or dragging the file into the upload area.
After uploading, you will be directed to the Match Columns section to align the Excel columns with system fields. This step is required if you are using a custom Excel file instead of the provided template.
Click Next and then Continue to proceed.
If there are any data discrepancies, the affected cells will turn red, and validation messages will be displayed for each row or column. You can correct the data directly in the online editor.
Once all corrections are made, click Submit to complete the import.
The holidays will now be successfully populated in the system.
Fig: Holiday Bulk Import
Fig: Column Match