Business owners
Import your monthly attendance file and get a summary without spreadsheet formulas.
Convert Biometric Attendance Excel Files | UAE
WatheeqaHR converts supported attendance Excel and CSV files exported from biometric devices into structured employee reports. The free analyzer needs no signup: upload the original export to review days present, estimated absence, worked hours, lateness and missing punches before deciding whether to import it into the full system.
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 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