Export Detailed Clock-In Records (CSV)

Home > Management Mode > Clock-In Records and Management > Export Detailed Clock-In Records (CSV) > Select Start and End Time

Administrators can enter Clock-In Records and Management from the Home page of Management Mode, then click Export Detailed Clock-In Records (CSV) to open the export detailed clock-in records page. All field names in the exported CSV file are displayed in English, including User ID, Employee ID, Employee Name, Time, Status, Schedule, Attendance, Checkpoint, GPS (Latitude, Longitude), Wi-Fi (WiFi), Bluetooth, NFC, Overtime, Approved, Created, Photo, and Notes. The Chinese names above are provided for administrator reference and comparison only.

The exported detailed clock-in record fields are in English. The corresponding descriptions are as follows:

No. English Field Chinese Field Description Example
1 User ID Employee ID The unique identification ID of the user (employee) dReHKiseggH3kiOlhnj876fheKle
2 Employee ID Employee Number The employee number of the user (employee) 1
3 Employee Name Employee Name The name of the user (employee) Lin Xiaoming
4 Time Clock-In Time The time of this clock-in record, Year-Month-Day Hour:Minute 2025-11-20 09:00
5 Status Status Start or end of work, START indicates start, END indicates end START END
6 Schedule Schedule The schedule name of this clock-in record Central District Office
7 Attendance Attendance Personal attendance record, normal indicates normal, end_early indicates early leave, start_late indicates late arrival normal end_early start_late
8 Checkpoint Checkpoint The checkpoint of this clock-in record Office Area
9 GPS GPS Location (Latitude, Longitude) The GPS location of this clock-in record, latitude, longitude 24.1731843,120.6611364
10 WiFi Wi-Fi The Wi-Fi name when clock-in is restricted to Wi-Fi points LOL520_2G
11 Bluetooth Bluetooth The Bluetooth name when clock-in is restricted by Bluetooth range MSBeacon
12 NFC NFC The NFC name and card serial number when scanning an NFC tag for clock-in NFC01 - D2:6B:94:00
13 Overtime Overtime Whether this is overtime, YES indicates yes, blank indicates no YES
14 Approved Make-Up Clock-In Whether this is a make-up clock-in, YES indicates yes, blank indicates no YES
15 Created Administrator Added Record Whether this record was added by an administrator, YES indicates yes, blank indicates no
16 Photo Photo Whether the employee uploaded a photo, YES indicates yes, blank indicates no YES
17 Notes Notes Notes for the employee clock-in Clock-in for work

How to Resolve Garbled Characters in Clock-In Records

When opening exported clock-in record CSV files in Excel on Windows computers, garbled characters may appear. This is usually caused by a mismatch between the CSV file encoding and Excel’s default encoding. By default, Excel prefers ANSI (such as Big5) or UTF-16 encoding, while many systems or programs export CSV files in UTF-8.

Method 1: Save the CSV File in a Compatible Encoding Format

  1. Open the CSV file using a text editor (such as Notepad++ or VS Code).
  2. Select Save As.
  3. In the encoding options, choose ANSI (for Traditional Chinese environments, Big5 is recommended) or UTF-8 with BOM.
  4. Save the file and reopen it in Excel.

Method 2: Use Excel’s Text Import Wizard

  1. Open Excel and create a blank worksheet.
  2. Select Data > Get Data > From Text/CSV (or Import Text File, depending on the version).
  3. Browse and select the administrator’s CSV file.
  4. During the import process, select the correct encoding format (such as UTF-8 or Big5).
  5. Click Finish to correctly import the data.

Frequently Asked Questions

Q1: How do I export detailed employee clock-in records?

A: Administrators need to enter the Home page of Management Mode, then click Clock-In Records and Management > Export Detailed Clock-In Records (CSV), and select the desired time range to export.

A: The exported CSV file includes many detailed clock-in information such as Date, Time, Status, Schedule, Attendance, Checkpoint, GPS location, Wi-Fi, Bluetooth, NFC, Overtime, Approved, Created, and Notes. All field names are displayed in English.

Q3: Why are the field names in the exported CSV file in English?

A: The field names in the exported CSV file are displayed in English by default to facilitate system or program processing. The documentation provides corresponding Chinese field names for administrator reference.

Q4: How can I resolve garbled characters when opening a CSV file in Excel?

A: The first method is to save the CSV file in an Excel-supported encoding format. You can open the CSV file using a text editor (such as Notepad++ or VS Code), select Save As, then choose ANSI (Big5 is recommended for Traditional Chinese environments) or UTF-8 with BOM, save it, and then reopen it in Excel. The second method is to use Excel’s Text Import Wizard. Open Excel, create a blank worksheet, then select Data > Get Data > From Text/CSV (or Import Text File depending on the Excel version), browse and select your CSV file, and ensure the correct encoding format (such as UTF-8 or Big5) is selected during the import process.

Q5: Which encoding format should I choose in the Text Import Wizard to avoid garbled characters?

A: In the Text Import Wizard, you should select the encoding format based on the actual encoding used by the CSV file. If the file is known to be UTF-8 encoded, select UTF-8. In Traditional Chinese environments, you may also need to try Big5 encoding. If the exact encoding is unknown, try several common encodings until the data displays correctly.

Q6: Are clock-in records of resigned employees included when exporting?

A: Clock-in records of resigned employees are not included during export. Whether using Export Clock-In Records or Export Detailed Clock-In Records (CSV), only active employee data is included.

This manual strives for accuracy and completeness, but we do not assume any liability for errors, omissions, or updates. The content may be modified at any time without prior notice. We are not responsible for any damages arising from the use of this manual or downloading its contents, including but not limited to system failures, data loss, or infringement of rights. Users assume full responsibility and risk.