Import attendance from a CSV file
Load the check-in and check-out times from your biometric or time-clock export.
Lesson 5 of 12 · Step by step
Step by step
Export Export downloads a list as a file: CSV or XLSX for Excel, or JSON for other software. Import loads records from a file into a list. More words in the glossary the Attendance Who was present, absent or on leave each day, with check-in and check-out times. More words in the glossary from your biometric device as CSV.
/admin/payroll/attendanceMake sure the columns are: employee number, date (YYYY-MM-DD or DD/MM/YYYY), in, out (HH:MM).
On Payroll → Attendance click Import CSV and choose the file.
Check the grid and correct any day by clicking it.
Where to find it
- Payroll → Attendance
/admin/payroll/attendance
Checklist
Before you move on, check that you can:
- Open Payroll → Attendance
- Export the attendance from your biometric device as CSV.
- Make sure the columns are: employee number, date (YYYY-MM-DD or DD/MM/YYYY), in, out (HH:MM).
- On Payroll → Attendance click Import CSV and choose the file.
- Check the grid and correct any day by clicking it.