How to convert .dat files to .csv

Talexio Tech-Support
Talexio Tech-Support
  • Updated

Locate the .dat file, which has been exported from the clocking device

1.png

Right click on the file and select "Open with"

2.png

Select "Notepad"

3.png

When the file is open correctly the following screen will appear

4.png

When the file is open, select "File" and "Save As..."

5.png

In the appearing dialog select "All files" as a "Save as type"6.png

Rename the "File name" from .dat to .csv

7.png

A new file with a new file extension will be saved in your directory, double click on this file to open and view in other applications supporting the .csv file extension

8.png

Data displayed will contain:

Employee ID: 1

Date and time: 2021-11-22 16:47:34

Punch state: 1 0 1 0 (Punch in)

Punch state : 1 1 1 0 (Punch out)

Note: each punch in and out will contain one line of data

 

Share: