How to convert a ZKTeco .dat file (USB flash drive) to Excel for free

Upload the 1_attlog.dat file from your ZKTeco clock USB flash drive right here to download an Excel sheet with worked hours calculated, or connect your clock to EzGYM and ditch the USB stick.

Create a free account Free time clock software

Free ZKTeco .dat file (USB flash drive) to Excel converter

Downloaded punches onto a USB drive and got a 1_attlog.dat or attlog.dat file? Open it right here in your browser: we calculate clock-in, clock-out and hours worked per day and employee, ready to download for Excel. Your file never leaves your browser.

No ZKTeco-formatted punches (tab-separated ID, date and time) were found in this file.

Employee (ID) Date First punch Last punch Hours Punches

Tired of walking to the clock with a USB drive every month? If your ZKTeco has ADMS / Cloud Server, connect it for free to EzGYM: punches arrive live on their own and you get WhatsApp alerts when someone is late.

Create a free account

When you download attendance logs from a ZKTeco time clock onto a USB flash drive (via Menu › USB Manager › Download › Attendance Data), the clock saves a file named 1_attlog.dat or attlog.dat. Opening it on a computer shows raw tab-separated numbers that are tedious to add up for payroll.

With the free converter above, drop that .dat file from your computer or phone: it pairs each employee's first check-in and last check-out per day, calculates total worked hours in decimal format and downloads a clean spreadsheet ready for Excel.

If you want to stop walking over with a USB drive every month, connect your ZKTeco clock over WiFi or Ethernet to EzGYM (by setting acceso.ezgym.net in Cloud Server Setting / ADMS). Punches arrive live on their own, you get WhatsApp alerts for late arrivals and your monthly Excel is always ready.

How to set it up

  1. 1 Create your free EzGYM account.
  2. 2 Under Attendance › Clocks, connect your ZKTeco clock with ADMS to the server acceso.ezgym.net.
  3. 3 Add your employees with their number and schedule.
  4. 4 See the day and the month, and download the Excel for payroll.

Frequently asked questions

How do I get the 1_attlog.dat file from my ZKTeco clock?

Plug a FAT32-formatted USB flash drive into the clock and go to Menu › USB Manager › Download › Attendance Data. The clock writes 1_attlog.dat to the drive.

Does the converter upload my file to a server?

No. Your .dat file is parsed locally inside your browser and the Excel file is generated on the spot on your device, free and without signing up.

How can I stop using the USB flash drive altogether?

If your clock has ADMS / Cloud Server Setting, point it to acceso.ezgym.net on port 443 with HTTPS enabled. Every punch is then sent automatically to EzGYM.

More guides

Create a free account