Switch from Timetastic
Upload Timetastic's Full Backup workbook. What Clearleave reads from it, and what you set up yourself.
The importer is built to read Timetastic's export columns, so there are no columns to rename or dates to reformat. Set up your leave types and people in Clearleave first, then upload the file in Import & migrationLeave history.
Comparing the two first? See Clearleave vs Timetastic.
What to export
In Timetastic, go to Settings › Reporting & Backup. Timetastic's help article Reports and backup describes two useful downloads:
- Full Backup, under Settings › Reporting & Backup, as an Excel workbook. It has worksheets including Users and Leave, with leave across all years.
- Annual Summary, for one year. Its Leave worksheet includes declined and cancelled requests, and its Allowances worksheet has brought forward, carry forward and remaining leave.
Keep the Allowances figures: you'll need them to check balances.
- 1
Create matching leave types
Name your Clearleave leave types the way Timetastic does, such as Holiday or Time in Lieu. Matching isn't case-sensitive.
- 2
Import your people
The People import takes a
.csvwithFirstname,SurnameandEmailcolumns (orFirst NameandLast Name). See Import your people. - 3
Upload the leave file
Upload the
.xlsxor.csvas it is, select Check file, and review the rows before you import.
Map your columns
You don't need to change anything. This is what the importer reads:
| Timetastic column | Clearleave column |
|---|---|
employee_email | |
| Firstname + Surname | first_name + last_name |
| User Id | Looked up in the workbook's users sheet to find the email |
| Leave Type | leave_type |
| Start Date or Start Time | start_date |
| End Date or End Time | end_date |
| Start Type (Morning / Afternoon) | start_half |
| End Type (Morning / Afternoon) | end_half |
| Duration + Booking Unit | hours when the unit is hours. Days are only compared with Clearleave's count. |
| Status | status |
| Reason | reason |
From a workbook, the importer reads the sheet with leave type, start and end columns. If there are no Start Type and End Type columns, half days are read from the times: a start at 12:00 or later is an afternoon, and an end at 14:00 or earlier is a morning.
Approved rows are deducted, pending rows wait for approval, and declined and cancelled rows are skipped.
What doesn't come across
- Allowances and carry-forward. Allowances come from your Clearleave policies. Add carried-over days as adjustments. See Set opening balances.
- Other worksheets. Only one sheet is read from a workbook. Departments, work schedules and time in lieu sheets aren't imported.
- Attachments, approvers and the audit trail. Set approvers on each person in Clearleave.
- Day counts. Clearleave counts working days from each person's working week and location's public holidays. Where that differs from Timetastic's duration, the row shows a warning.
How long it takes
For a team of about 25, setting up leave types and people takes an hour or two. Exporting, checking and importing the leave file takes a few minutes. Files over 2,000 rows need splitting.