Offices using Hikvision access terminals
See why a check-in and check-out report is refused before sending it to payroll.
Hikvision Attendance Excel Export: Headers and Pitfalls
Hikvision attendance software can export a report with one row per person and separate check-in and check-out columns. The header shape our tests cover is Person ID, Name, Department, Check-in Time, Check-out Time. WatheeqaHR reads Person ID as the employee ID and the two time columns as the day's check-in and check-out. That shape has no date column, so the file also needs one such as Date, Attendance Date or Event Date, or it is refused.
Hikvision: header shape, what WatheeqaHR reads and pitfalls
The header shape our tests cover
The automated tests resolve this header row for the ID column: Person ID, Name, Department, Check-in Time, Check-out Time. The test proves the employee ID is found. It does not prove the file is complete, and as written this shape has no date column. Use the attendance or event export of your Hikvision software as Excel or CSV and check that a date column is present.
What WatheeqaHR reads from it
Person ID is the employee ID and Name the employee name. Check-in Time and Check-out Time are matched as the check-in and check-out columns, because the matcher accepts a label followed by the word Time. Department is not used by the analyzer. Each row is read as one person on one day.
Pitfall: in and out columns without a date
When a file has check-in and check-out columns but no date column, it is refused with 'No attendance-date column was found'. The date column can be called Date, Attendance Date, Work Date, Punch Date, Event Date, Day or the Arabic equivalents التاريخ and تاريخ. Without a date each time has no day to belong to.
Pitfall: the Access Result filter
If the file has an Access Result column, only rows whose value is granted, allowed, success or successful are counted, ignoring case. Failed attempts and blank values are dropped before any totals, because a refused door event is not attendance. A person who looks absent may simply have a column of non-matching values, so read that column first.
Before you upload
Upload the original export, one month at a time, under 5 MB. In the file preview check that Person ID and a date column are present. If the employee column is missing the refusal lists the first columns it found.
Features
| Feature | Description |
|---|---|
| Person ID | Employee ID. |
| Name | Employee name. |
| Department | Not used by the analyzer. |
| Check-in Time | Matched as the day's check-in column. |
| Check-out Time | Matched as the day's check-out column. |
| Access Result (if present) | Only granted, allowed, success and successful rows are counted. |
Who uses this
IT administrators
Choose an export with a date column and a clean Access Result column.
Frequently asked questions
How do I convert a Hikvision attendance report to Excel?
Export the attendance or event report from your Hikvision software as Excel or CSV and upload it to the free analyzer, which returns an Excel report. WatheeqaHR reads the file and does not connect to the device.
Why does my Hikvision file say no attendance-date column was found?
Your file has check-in and check-out columns but no date. Add or re-export with a column named Date, Attendance Date, Event Date or similar, and upload again.
What does the Access Result column do?
If the file has one, only rows marked granted, allowed, success or successful are counted. Everything else, including empty cells, is dropped as not being attendance.
Is Department used?
No. Department is not read, so it does not matter whether it is filled in.
Is this a Hikvision compatibility guarantee?
No. Layouts are detected from column names, and this page describes the shape our tests use. Test your real file.
Related pages
Start with your real attendance file
Upload an Excel or CSV export and review the result free — no signup required.
Analyze attendance free Create free account