How to Bulk Import Holidays in Workwisely | Step-by-Step

Adding Holiday (Bulk Import)

  • 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

    • Related Articles

    • Updating Employee Job Info (Bulk Import)

      My Team → Team Summary To update employee details in bulk, click on the Three Dots located at the top right above the Status column and select Import Employees.Afer you select the option, you will see the pop-up showing you the steps of importing as ...
    • Bulk Actions

      To perform bulk actions such as uploading candidate profiles, shortlisting candidates, scheduling interviews, or assigning assessments, click the three-dot menu located at the top right corner next to the "Add Job Candidate" button. Recruitment → Job ...
    • Adding Holidays to the List

      After you create the holiday list, you will need to add holidays to it. You can do it in two ways. Adding Holidays through UI(One-by-One) CoreHR → Employee Data Management → Holidays → Published Holidays Click +Add New and select the Holiday List ...
    • Holiday

      CoreHR → Employee Data Management → Holidays The Holiday module allows organizations to define and manage official holidays for employees. Companies can configure holiday calendars based on locations, or employee groups, ensuring compliance with ...
    • Holiday Types

      Mandatory These are company-declared holidays that apply to all employees and cannot be modified or opted out of. Examples include national holidays, religious festivals, and public holidays that the organization observes. Holiday A general holiday ...