Import holidays
You can load company holidays from an Excel file on the Holidays tab of the HR settings page, with Import holidays in the … menu. The first column of the file is the start date (for example 2026-12-24), the second the end date (leave it empty for a single day), and the third the holiday's name (optional).
File format
- Accepted file types: .xlsx, .xls or .csv.
- Column A – start date. Either an Excel date cell or text in YYYY-MM-DD form.
- Column B – end date. Leave it empty for a single-day holiday.
- Column C – the holiday's name, for example "Christmas". Optional.
No header row is needed. If there is one, it is simply skipped, because its first cell is not a date.
How to import
- Open Settings → HR settings and choose the Holidays tab.
- Click the … button above the list, then Import holidays.
- Choose the file.
When the import finishes, a summary shows how many rows were added and how many were skipped. A row is skipped if it has no valid start date, or if a holiday with exactly the same dates is already in the list.