Export Overtime Clock-in Records (Excel)
Home > Management Mode > Clock-in Records > Export Clock-in Records > Overtime Clock-in Records (Excel)From the Management Mode home page, select Clock-in Records and Management, then choose Export Clock-in Records and Overtime Clock-in Records. Select a month to export the overtime clock-in records. You can open and edit the exported file in Excel.
Data Format
| No. | Field | Description | Example |
|---|---|---|---|
| 1 | Date | Start date of the paired clock-in record | 2026-04-03 (Fri) |
| 2 | Start Work | Time when the user (employee) clocked in to start work | 2026-04-03 02:59 |
| 3 | End Work | Time when the user (employee) clocked out after work | 2026-04-03 09:06 |
| 4 | Clock-in Duration | Total time from Start Work to End Work | 6h 7m |
| 5 | Work Hours | Clock-in Duration truncated to a whole number of hours | 6 hrs |
Clock-in Duration
Definition: Clock-in Duration is the total elapsed time from Start Work to End Work within the same paired record.
Calculation: Clock-in Duration = End Work time ā Start Work time
Example: If an employee clocks in for overtime at 6:00 p.m. and clocks out at 8:00 p.m., the Clock-in Duration is 2 hours.
Note:
- The system calculates the direct difference between Start Work and End Work. It does not currently subtract break time automatically.
Work Hours
Definition: Work Hours is the Clock-in Duration truncated to a whole number of hours. This field does not mean that the system has identified or deducted break time.
Calculation: Work Hours = Clock-in Duration with the minutes discarded
Example: If an employee clocks in for overtime at 5:57 p.m. and clocks out at 8:13 p.m., the Clock-in Duration is 2 hours 16 minutes, while Work Hours displays 2 hours.
Additional information:
- Use the Clock-in Duration field when you need the minutes to be included.
Export Overtime Clock-in Records (CSV)
Home > Management Mode > Clock-in Records > Export Clock-in Records > Overtime Clock-in Records (CSV)From the Management Mode home page, select Clock-in Records and Management, then choose Export Clock-in Records and Overtime Clock-in Records. The exported CSV uses English column names. The table below explains each column.
| No. | CSV Column | Display Name | Description | Example |
|---|---|---|---|---|
| 1 | User ID | User ID | Unique identifier of the user (employee) | dReHKiseggH3kiOlhnj876fheKle |
| 2 | Employee ID | Employee ID | Employee number of the user (employee) | 1 |
| 3 | Employee Name | Employee Name | Name of the user (employee) | Lin Xiaoming |
| 4 | Time | Clock-in Time | Date and time of the record in YYYY-MM-DD HH:MM format | 2025-11-20 09:00 |
| 5 | Status | Status | START means the start of work; END means the end of work |
START |
| 6 | Checkpoint | Checkpoint | Checkpoint used for the clock-in record | Office area |
| 7 | GPS | GPS Location (latitude, longitude) | GPS latitude and longitude of the clock-in record | 24.1731843,120.6611364 |
| 8 | WiFi | Wi-Fi | Wi-Fi name used when Wi-Fi clock-in restrictions apply | LOL520_2G |
| 9 | Bluetooth | Bluetooth | Bluetooth device name used when Bluetooth range restrictions apply | MSBeacon |
| 10 | NFC | NFC | NFC tag name and card serial number used for clock-in | NFC01 - D2:6B:94:00 |
| 11 | Approved | Supplemental Clock-in | YES means this is a supplemental clock-in; blank means no |
YES |
| 12 | Created | Added by Manager | YES means the record was added by a manager; blank means no |
|
| 13 | Photo | Photo | YES means the employee uploaded a photo; blank means no |
YES |
| 14 | Notes | Notes | Note entered by the employee when clocking in | Clocking in for work |
Export Data Availability
SwipePoint stores clock-in records permanently in the cloud. However, export permissions and the available date range depend on the organization's subscription status.
Export Options and Limits
The following limits apply based on whether the organization subscribes to the Organization Ad-Free plan:
| Subscription Status | Records Available for Export | Date Range Limit |
|---|---|---|
| No Organization Ad-Free subscription | Personal records only; Export All is unavailable. | Up to the most recent 2 months. |
| Organization Ad-Free subscription active | Personal records or all records. | Up to 1 year of detailed records. |
Fix Garbled Text in Clock-in Record CSV Files
When you open a clock-in record CSV file in Excel for 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 differ slightly by Excel version. - Select the CSV file you want to import.
- If File Origin or an encoding option is available, select
65001: Unicode (UTF-8)and confirm that the delimiter is a comma. - Verify that the preview displays the text correctly, then select Load.
Method 2: Save the File as UTF-8 with BOM
- Open the CSV in a text editor that supports encoding selection, such as Notepad++ or Visual Studio Code.
- Choose Save As.
- Select
UTF-8 with BOMas the encoding and save the file. - Reopen the saved file in Excel.
Do not convert the file to ANSI or Big5. Unsupported characters may be lost or become garbled.
Frequently Asked Questions
Q1: How do I export overtime records?
A: From the Management Mode home page, select Clock-in Records and Management, then choose Export Clock-in Records and Overtime Clock-in Records. You can then select the month to export.
Q2: Who can export overtime records?
A: Only users with Management Mode permission (managers) can export overtime records.
Q3: Which file formats are available?
A: You can export the records in Excel or CSV format and open them with Excel or other compatible software.
Q4: Which fields are included in the Excel export?
A: The export includes Date, Start Work, End Work, Clock-in Duration, and Work Hours.
Q5: What is the difference between Clock-in Duration and Work Hours?
A: Clock-in Duration is the complete difference between the End Work and Start Work times. Work Hours displays that duration as whole hours after discarding the minutes. Neither field currently subtracts break time automatically.
Q6: How do I choose the month to export?
A: On the Export Clock-in Records page, select Overtime Clock-in Records and specify the month to export.
Subscribers receive more immediate support. If you encounter an error or need help using SwipePoint, contact the SwipePoint team through the official LINE account. We will prioritize your request to help keep attendance management running smoothly. 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.