The time off CSV file must have three required fields and one optional one. Our software has an interface to map these required fields to the columns of the CSV file. The 4 fields are listed below - note that the order of the fields doesn’t matter:
- Employee email (to match individuals)
- Start date
- End date
- Duration in days (optional, to indicate a fraction of a day)
- Category of leave (optional, e.g. Vacation, Sick day, Out of office, etc.)
Here is an example of a leave records spreadsheet.
In addition to these 4 fields, you can have others, as the data is processed on the client side and only data from the mapped fields are sent to the server.
Any standard date format can be entered, e.g. “YYYY-MM-DD”. If the format isn’t suitable, our software will let you know.
The ISO_8601 date format is preferred.
After the import of the CSV is complete, you will see the number of total imported days and other statistics to validate that your data was imported correctly.