Skip to content

Export a report as CSV

Download the Allowance or Absence report as a CSV file to open in Excel, Google Sheets or Numbers.

ManagersAdminsOwners

You can download either report as a CSV file, then open it in any spreadsheet app.

  1. 1

    Open Reports

    Select Reports in the menu.

  2. 2

    Choose the report and period

    Choose Allowance and a leave year, or Absence and the dates.

  3. 3

    Export it

    Select Export CSV. The file is named after the report and its dates, for example leave-allowance-2026-01-01-to-2026-12-31.csv or absence-2026-01-01-to-2026-12-31.csv. In the Absence report, Export each absence downloads absences-….csv with one line for each absence.

What's in the file

The export has the same people, period and figures as the report on screen, with one row for each row in the report and the same column names. Managers' exports include only the people they manage, just as the page does. Figures are in days and dates are written day, month, year (22/12/2026). The file opens in Excel with accented names shown correctly.

ExportColumns
AllowanceEmployee, Email, Employee ref, Department, Leave type, Leave year start, Leave year end, Allowance, Taken, Booked, Balance, Waiting for approval, Available to book, Figures as at
AbsenceEmployee, Email, Employee ref, Department, Leave type, Occasions, Days taken, Days booked, Total days
Each absenceEmployee, Email, Employee ref, Department, Leave type, Start, End, Days in period, Status (Taken or Booked)

Employee ref is the reference you can give each person on their profile, such as a payroll number, so you can match the file to your payroll. It's empty when it isn't set. In Each absence, Start and End are the leave's own dates; Days in period counts only its days inside the dates you chose. For what each column counts, see Reports.

If nothing matches, the file has only its header row.

Opening the file safely

If a name or other text in the export starts with a character that a spreadsheet would treat as a formula, such as =, Clearleave adds an apostrophe in front of it. This stops a formula from running when you open the file. Numbers, including negative ones, are left as numbers.