Import attendance from Excel or CSV

You can upload any .csv, .xls or .xlsx layout — you’ll match its columns on screen. Or click Download Template for a ready-made file. You need one row per employee per day.

Employee IDRequired

The Employee ID on the employee’s profile. Leading zeros don’t matter.

Punch In (Date & Time)Required

For example 2026-10-05 09:30.

Punch Out (Date & Time)Required

For example 2026-10-05 18:15.

Attendance DateRequired

YYYY-MM-DD is preferred. DD-MM-YYYY and MM-DD-YYYY are detected automatically.

1. 1

   Choose your file. You’ll see how many columns and rows were detected. Click Next: Map Columns.

2. 2

   Check each Attendance Field is matched to the right column in your file. Common names such as “emp code”, “in time” or “check in” are matched automatically. Click Next: Review.

3. 3

   Review the rows. Rows with problems are greyed out and skipped; untick any others you don’t want.

   If dates in your file are ambiguous (like 03-08-2026), a notice tells you how they’ll be read.

4. 4

   Click Import {n} Row(s).

When it finishes you’ll see how many days were newly marked and how many were updated, then the Monthly Log opens.

When you import more than 500 rows, the import runs in the background with a live progress panel showing processed, imported, failed and skipped rows. You can leave the page while it runs.

• Download error report — a CSV of the rows that failed and why.
• Retry failed rows — try the failed rows again after fixing the cause.
• Import another file or Go to Attendance when you’re done.