Skip to content
14-day free trial, no card9 languages176 business types · 50 apps
EN· USD
Try a live demoStart free trial

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

  • 3-minute lesson
  • Payroll → Attendance

Step by step

  1. 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/attendance
  2. Make sure the columns are: employee number, date (YYYY-MM-DD or DD/MM/YYYY), in, out (HH:MM).

  3. On Payroll → Attendance click Import CSV and choose the file.

  4. Check the grid and correct any day by clicking it.

Where to find it

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.