Owners, HR managers and admins processing monthly attendance

How to Import an Attendance File (Excel/CSV) in WatheeqaHR

Go to Attendance > Import File, upload the Excel or CSV export from your biometric device, review the auto-detected column mapping, then confirm. WatheeqaHR auto-detects ZKTeco, Hikvision, Suprema, Dahua, eSSL and generic exports and calculates present/absent/late/overtime per employee automatically.

Last updated: 2026-07-20 · بالعربية

Steps

  1. Confirm your work calendar first

    If you haven't already, set your shift times and weekly off days in Settings > Work Calendar — WatheeqaHR will prompt you if this step is missing.

  2. Go to Attendance > Import File

    Open the Attendance page from the sidebar; the Import File tab is selected by default.

  3. Upload your file

    Drag or select the .xls, .xlsx or .csv file exported from your attendance device or software.

  4. Review the column mapping

    WatheeqaHR auto-detects columns like Employee ID/Enrollment No, Date, and Time. Adjust manually if your device uses a non-standard export format.

  5. Confirm the import

    WatheeqaHR calculates present, absent, late and overtime for each employee and each day based on your work calendar.

  6. Review the results

    Check the import summary for row errors or unmatched employee IDs, then review the report before it's used for salary.

Frequently asked questions

Which devices are supported?
ZKTeco, Hikvision, Suprema, Dahua, eSSL, Anviz and most generic USB/CSV exports used in the UAE.
What happens if an employee ID isn't recognized?
The import wizard lists unrecognized device IDs before importing. You can create them as employees (each with a name and join date) or continue without creating — their punches then stay unmatched until you link them to an employee.
Does importing immediately affect salary?
No. Import only prepares an attendance report for review. Salary deductions require a separate review and approval step.

Related guides

Check your attendance export before importing

Upload Excel or CSV and review missing punches, lateness and estimated absence without creating an account.

Try your file in the free attendance analyzer

Export formats by device: ZKTeco, Hikvision, Dahua and more

Still need help?

Contact your account owner/admin, or reach our support team from inside the app.

Create free account

Fluxnova LLC · Sharjah Media City, Sharjah, UAE · +971 54 489 6844

LinkedIn · Instagram · X