Importing and Exporting Holiday Dates

You can import dates into an existing holiday rule and export dates from a holiday rule into a CSV file. For example, in the US Holidays rule, you can import all of the holidays with their associated dates for the next year.

To import holiday dates:

Importing Holiday Dates into a Holiday Rule

  1. From Home, click Application, then click Configuration, and then select the Organizations tab.
  2. Select the Holiday Rules tab.
  3. Create or select a holiday rule and navigate to the Properties tab.
  4. Select Import.
  5. In the Import File drawer:
    • Enter the file name, or click Browse to navigate to the CSV import file.

      Example:

      "Date","Name"
      "Jan 1, 2026","New Years Day"
      "May 25, 2026","Memorial Day"
    • For Import Type, select one of the following:
      • Replace—Replaces the holiday dates with the holiday dates in the file that you are importing. It does not affect other units that are not specified in the import file.
      • Replace All—Imports a new set of holiday dates that replaces the existing holiday dates. Use this option to replace a unit in one system with an updated definition from another system. Holiday dates that are not specified in the import file are deleted.
    • In File Delimiter, select how the values in the import file are separated. Options are Comma, Tab, or Space.
    • In Date Format select a date format from the drop down list of allowed date formats. Date formats are not translated. By default, the date format is set to the locale date format of the exported file location.

      For example:

      • MM/dd/yyyy
      • dd/MM/yyyy
      • dd-MMM-yy
      • MMM d, yyyy
  6. Click Import
  7. After the import completes successfully, select Save to save the changes.

Exporting Holiday Dates

  1. From Home, click Application, then click Configuration, and then select the Organizations tab.
  2. Select the Holiday Rules tab.
  3. Click the name of the holiday rule from which to export holiday dates.
  4. In the Properties tab, select Export to export the holiday dates to the Holidays.csv file.

Dates will be exported in the YYYY-MM-DD format