Export a report as CSV
Download the Allowance or Absence report as a CSV file to open in Excel, Google Sheets or Numbers.
You can download either report as a CSV file, then open it in any spreadsheet app.
- 1
Open Reports
Select Reports in the menu.
- 2
Choose the report and period
Choose Allowance and a leave year, or Absence and the dates.
- 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.csvorabsence-2026-01-01-to-2026-12-31.csv. In the Absence report, Export each absence downloadsabsences-….csvwith 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.
| Export | Columns |
|---|---|
| Allowance | Employee, 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 |
| Absence | Employee, Email, Employee ref, Department, Leave type, Occasions, Days taken, Days booked, Total days |
| Each absence | Employee, 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.