Business owners
Import your monthly attendance file and get a summary without spreadsheet formulas.
Attendance Excel Import UAE — Convert Device Exports to Reports
WatheeqaHR imports attendance Excel and CSV files exported from UAE biometric devices and generates structured monthly reports. Upload the file, preview the column mapping, and import. WatheeqaHR groups punches by employee and day, calculates present, absent, late and overtime, and produces a summary ready for payroll or accountant review.
Features
| Feature | Description |
|---|---|
| File upload | Upload CSV, XLSX, XLS, TXT or DAT files directly from your device software |
| Column mapping | Map employee ID, name, date, time and punch type columns to WatheeqaHR fields |
| Format auto-detection | Date format (DD/MM/YYYY, MM/DD/YYYY, YYYY-MM-DD) and delimiter are detected automatically |
| Preview before import | See the first 20 rows and column headers before committing the import |
| Auto-create employees | Option to create employee stubs automatically for first-time imports |
| Error reporting | Row-level error messages explain exactly which rows failed and why |
Who uses this
HR managers
Save time by importing device exports directly instead of manually entering attendance.
Accountants
Receive a structured attendance report linked to salary calculations.
Compliance disclaimer
WatheeqaHR attendance imports are for internal record-keeping. Always verify records against your device software for discrepancies.
Frequently asked questions
How do I export attendance from ZKTeco software?
In ZKTeco software, go to Reports > Attendance, select the date range and export as CSV. Upload this file to WatheeqaHR.
What if my file has encoding issues?
WatheeqaHR handles UTF-8, UTF-8 BOM and UTF-16 encoded files automatically.
Can I save my column mapping as a template?
Yes. After a successful import, you can save the column mapping as a named template for future imports from the same device.
What happens to existing records when I re-import?
Re-imports are merged — earlier check-ins and later check-outs are preserved. No duplicate attendance records are created.
Related pages
Start tracking employee operations
UAE-first. No HRMS complexity. Set up in hours.
Create free account