Scheduled Clock-In Records (CSV)
Home > Management Mode > Clock-In Records > Export Clock-In Records > Scheduled Clock-In Records (CSV)On the Management Mode Home screen, administrators can select Clock-In Records and Management, then Export Clock-In Records and Scheduled Clock-In Records. After choosing a date range, they can download the CSV file. Field names in the file are in English and are described below.
| No. | Field | Meaning | Description | Example |
|---|---|---|---|---|
| 1 | User ID | Employee ID | The unique identifier of the user (employee) | dReHKiseggH3kiOlhnj876fheKle |
| 2 | Employee ID | Employee Number | The employee number assigned to the user (employee) | 1 |
| 3 | Employee Name | Employee Name | The name of the user (employee) | Lin Xiaoming |
| 4 | Time | Clock-In Time | The clock-in time in year-month-day hour:minute format | 2025-11-20 09:00 |
| 5 | Status | Status | START means the employee started work; END means the employee ended work |
START |
| 6 | Schedule | Schedule | The schedule name associated with the record | Central District Office |
| 7 | Checkpoint | Checkpoint | The checkpoint associated with the record | Office Area |
| 8 | GPS | GPS Location (Latitude, Longitude) | The latitude and longitude recorded for the clock-in | 24.1731843,120.6611364 |
| 9 | WiFi | Wi-Fi | The Wi-Fi network used when clock-in is restricted to a specified network | LOL520_2G |
| 10 | Bluetooth | Bluetooth | The Bluetooth beacon used when clock-in is restricted to a specified Bluetooth range | MSBeacon |
| 11 | NFC | NFC | The NFC tag name and card serial number used for clock-in | NFC01 - D2:6B:94:00 |
| 12 | Approved | Make-Up Clock-In | YES means this is a make-up clock-in; blank means no |
YES |
| 13 | Created | Record Added by Administrator | YES means an administrator added the record; blank means no |
|
| 14 | Photo | Photo | YES means the employee uploaded a photo; blank means no |
YES |
| 15 | Notes | Notes | Notes entered by the employee when clocking in | Started work |
Export Data Availability
SwipePoint stores clock-in records permanently in the cloud, but export permissions and available date ranges depend on the organization’s subscription status.
Export Options and Limits
The following limits depend on whether the organization subscribes to the Ad-Free Organization plan:
| Subscription Status | Records Available for Export | Date Range Limit |
|---|---|---|
| Not subscribed to Ad-Free Organization | Personal records only; the Export All option is unavailable. | Up to 2 months of data. |
| Subscribed to Ad-Free Organization | Personal records or all records. | Up to 1 year of detailed data. |
Fix Garbled Text in Clock-In Record CSV Files
When a clock-in record CSV file is opened in Excel on Windows, Chinese text may appear garbled if Excel does not detect the file’s UTF-8 encoding correctly. Use either method below.
Method 1: Import the UTF-8 CSV in Excel
- Open Excel and create a blank workbook.
- Select
Data > Get Data > From File > From Text/CSV. Menu names may vary by Excel version. - Select the CSV file to import.
- If Excel displays a file-origin or encoding option, select
65001: Unicode (UTF-8)and confirm that the delimiter is a comma. - Confirm that the preview displays the text correctly, then select Load.
Method 2: Save the File as UTF-8 with BOM
- Open the CSV file in a text editor that supports encoding selection, such as Notepad++ or VS Code.
- Select Save As.
- Set the encoding to
UTF-8 with BOM, then save the file. - Reopen the saved file in Excel.
Avoid converting the file to ANSI or Big5 because unsupported characters may be lost or become garbled.
Unscheduled Clock-In Records (CSV)
Home > Management Mode > Clock-In Records > Export Clock-In Records > Unscheduled Clock-In Records (CSV)On the Management Mode Home screen, administrators can select Clock-In Records and Management, then Export Clock-In Records and Unscheduled Clock-In Records. After choosing a date range, they can download the CSV file. This file does not include the Schedule field; the remaining fields are described below.
| No. | Field | Meaning | Description | Example |
|---|---|---|---|---|
| 1 | User ID | Employee ID | The unique identifier of the user (employee) | dReHKiseggH3kiOlhnj876fheKle |
| 2 | Employee ID | Employee Number | The employee number assigned to the user (employee) | 1 |
| 3 | Employee Name | Employee Name | The name of the user (employee) | Lin Xiaoming |
| 4 | Time | Clock-In Time | The clock-in time in year-month-day hour:minute format | 2025-11-20 09:00 |
| 5 | Status | Status | START means the employee started work; END means the employee ended work |
START |
| 6 | Checkpoint | Checkpoint | The checkpoint associated with the record | Office Area |
| 7 | GPS | GPS Location (Latitude, Longitude) | The latitude and longitude recorded for the clock-in | 24.1731843,120.6611364 |
| 8 | WiFi | Wi-Fi | The Wi-Fi network used when clock-in is restricted to a specified network | LOL520_2G |
| 9 | Bluetooth | Bluetooth | The Bluetooth beacon used when clock-in is restricted to a specified Bluetooth range | MSBeacon |
| 10 | NFC | NFC | The NFC tag name and card serial number used for clock-in | NFC01 - D2:6B:94:00 |
| 11 | Approved | Make-Up Clock-In | YES means this is a make-up clock-in; blank means no |
YES |
| 12 | Created | Record Added by Administrator | YES means an administrator added the record; blank means no |
|
| 13 | Photo | Photo | YES means the employee uploaded a photo; blank means no |
YES |
| 14 | Notes | Notes | Notes entered by the employee when clocking in | Started work |
Frequently Asked Questions
Q1: How do I export detailed employee clock-in records?
A: On the Management Mode Home screen, select Clock-In Records and Management, then Export Clock-In Records. Choose Scheduled Clock-In Records or Unscheduled Clock-In Records, set the date range, and export the file.
Q2: What information is included in the exported CSV files?
A: Both CSV files include employee identifiers, clock-in time, status, checkpoint, GPS, Wi-Fi, Bluetooth, NFC, make-up clock-in status, administrator-created status, photo status, and notes. Scheduled clock-in records also include the Schedule field. All exported field names are in English.
Q3: Why are the exported CSV field names in English?
A: English field names make it easier for systems and software to exchange and process the data. This manual provides a field reference for administrators.
Q4: How do I fix garbled text when opening a CSV file in Excel?
A: Import the file with Excel’s From Text/CSV feature and select 65001: Unicode (UTF-8). Alternatively, use a text editor to save the file as UTF-8 with BOM, then reopen it in Excel.
Q5: Which encoding should I select when importing a CSV file?
A: Select 65001: Unicode (UTF-8) first. Confirm that the preview displays the text correctly before loading the data. Avoid converting the file to ANSI or Big5.
Q6: Do exports include clock-in records for former employees?
A: No. Both Scheduled Clock-In Records (CSV) and Unscheduled Clock-In Records (CSV) include data for active employees only.
Subscribers receive faster support. If you encounter an error or have trouble using SwipePoint, contact the SwipePoint team through the official LINE account for priority assistance. LINE ID: @nka7729y Contact the SwipePoint team
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.