Adding Holiday (Bulk Import)

ADMIN HELP CENTER · HOLIDAY

Adding Holiday (Bulk Import)

Bulk-import your entire holiday calendar from an Excel file — match columns, fix validation errors inline, and publish in one pass.

CoreHR → Employee Data Management → Published Holidays

Before You Begin

Gather your holiday data

Have Holiday Name, Location/Custom Group, Holiday Type, Start & End Date, and Description ready. Use the downloadable template for fastest results.

What You'll Achieve

Year's holidays in minutes

All holidays populated in the system in a single upload — no manual entry required, with validation catching errors before they land.

💡 Tip

If any cells turn red after upload, it's a validation error. You can fix data directly in the online editor — no need to re-upload the file.

• 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 & Next Steps

➕ Manual Entry

Adding Holidays to the List

Add holidays one at a time from the UI.

📋 Reference

Holiday Types

The holiday type categories available in Workwisely.

🚀 Next Step

Create & Publish Holiday List

Publish imported holidays so employees see them.

📚 Overview

Holiday

Full guide to holiday configuration.

• Related Articles

• Holiday

  ADMIN HELP CENTER · HOLIDAY Holiday Module Define and manage official holidays for your organization — published to the right employees, at the right locations, with the right rules. CoreHR → Employee Data Management → Holidays WHO IT'S FOR Admin ...

• Holiday Types

  ADMIN HELP CENTER · HOLIDAY Holiday Types The three categories Workwisely uses to classify every holiday — so you know which are required, which are policy-driven, and which are employee-chosen. Reference · 3 holiday categories Before You Begin ...

• Adding Employees Individually

  ADMIN HELP CENTER · TEAM SUMMARY Adding Employees Individually Walk through the three-step Add Employee wizard — from Personal Info to Finalize — to onboard a new hire one record at a time. 📍 Navigation Path: My Team → Team Summary → +Add Employee ...

• Adding Holidays to the List

  ADMIN HELP CENTER · HOLIDAY Adding Holidays to the List Add individual holidays to your published list through the UI — perfect for one-off entries or quick fixes after a bulk import. CoreHR → Employee Data Management → Holidays → Published Holidays ...

• Creating and Publish Holiday List

  ADMIN HELP CENTER · HOLIDAY Creating & Publishing a Holiday List Set up the named holiday list that will hold all your published holidays — the foundation every holiday entry gets attached to. CoreHR → Employee Data Management → Holidays → Holiday ...