Content translated from the uploaded markdown file
Export Clock-in Records
Home > Admin Mode > Clock-in Records > Export Clock-in RecordsAdministrators can click Clock-in Records and Management on the Home page in Admin Mode, then select Export Clock-in Records to enter the export page. Administrators can choose the required export format. Currently available exports include Clock-in Records with Schedule, Clock-in Records without Schedule, and Overtime Clock-in Records, with two available formats: Excel and CSV.
Clock-in Records with Schedule (Excel)
Home > Admin Mode > Clock-in Records > Export Clock-in Records > Clock-in Records with Schedule (Excel)Administrators can click Clock-in Records and Management on the Home page in Admin Mode, then select Export Clock-in Records, and choose Clock-in Records with Schedule to enter the page. Administrators can export scheduled clock-in records. The exported file can be opened and edited using Excel software.
Data Format
| No. | Field Name | Description | Example |
|---|---|---|---|
| 1 | Schedule Name | The name and date of the assigned schedule | Day Shift (4/1 Wed) |
| 2 | Schedule Time | The start and end time of the schedule | 2026-04-01 09:00–18:00 |
| 3 | Break | The break time within the schedule | 12:00–13:00 |
| 4 | Start Work | The time when the user (employee) clocked in to start work | 2026-04-01 08:58 |
| 5 | End Work | The time when the user (employee) clocked out after work | 2026-04-01 18:03 |
| 6 | Clock-in Hours | The total duration from clock-in start to clock-in end | 8h 5m |
Clock-in Hours
Definition: Clock-in hours refer to the total duration from the start clock-in time to the end clock-out time within a working day. This duration includes all working periods and break periods in between.
Calculation Method: Clock-in Hours = End Work Time − Start Work Time
Example: If an employee clocks in at 9:00 AM and clocks out at 6:00 PM, the clock-in hours are 9 hours.
Notes:
- If there is a lunch break or other break periods, they are usually included in the clock-in hours.
Clock-in Records without Schedule (Excel)
Home > Admin Mode > Clock-in Records > Export Clock-in Records > Clock-in Records without Schedule (Excel)Administrators can click Clock-in Records and Management on the Home page in Admin Mode, then select Export Clock-in Records, and choose Clock-in Records without Schedule to enter the page. Administrators can export clock-in records without schedules. The exported file can be opened and edited using Excel software.
Data Format
| No. | Field Name | Description | Example |
|---|---|---|---|
| 1 | Date | The starting date of the paired clock-in record | 2026-04-03 (Fri) |
| 2 | Start Work | The time when the user (employee) clocked in to start work | 2026-04-03 02:59 |
| 3 | End Work | The time when the user (employee) clocked out after work | 2026-04-03 09:06 |
| 4 | Clock-in Hours | The total duration from clock-in start to clock-in end | 7h 7m |
| 5 | Work Hours | The actual effective working hours invested by the employee | 7hrs |
Clock-in Hours
Definition: Clock-in hours refer to the total duration from the start clock-in time to the end clock-out time within a working day. This duration includes all working periods and break periods in between.
Calculation Method: Clock-in Hours = End Work Time − Start Work Time
Example: If an employee clocks in at 9:00 AM and clocks out at 6:00 PM, the clock-in hours are 9 hours.
Notes:
- If there is a lunch break or other break periods, they are usually included in the clock-in hours.
Work Hours
Definition: Work hours refer to the actual effective working hours invested by the employee. This usually excludes break time and counts only actual working time.
Calculation Method: Work Hours = End Work Time − Start Work Time (only integer hours are counted; minutes are discarded)
Example: If an employee clocks in at 8:57 AM and clocks out at 5:40 PM, the work hours are calculated as 8 hours (minutes are not counted).
Additional Notes:
- Calculating work hours using only integer hours helps simplify payroll calculations and working hour records.
Overtime Clock-in Records (Excel)
Home > Admin Mode > Clock-in Records > Export Clock-in Records > Overtime Clock-in Records (Excel)Administrators can click Clock-in Records and Management on the Home page in Admin Mode, then select Export Clock-in Records, and choose Overtime Clock-in Records to enter the page. Administrators can export overtime clock-in records. The exported file can be opened and edited using Excel software.
Data Format
| No. | Field Name | Description | Example |
|---|---|---|---|
| 1 | Date | The starting date of the paired clock-in record | 2026-04-03 (Fri) |
| 2 | Start Work | The time when the user (employee) clocked in to start work | 2026-04-03 02:59 |
| 3 | End Work | The time when the user (employee) clocked out after work | 2026-04-03 09:06 |
| 4 | Clock-in Hours | The total duration from clock-in start to clock-in end | 7h 7m |
| 5 | Work Hours | The actual effective working hours invested by the employee | 7hrs |
Clock-in Hours
Definition: Clock-in hours refer to the total duration from the start clock-in time to the end clock-out time within a working day. This duration includes all working periods and break periods in between.
Calculation Method: Clock-in Hours = End Work Time − Start Work Time
Example: If an employee clocks in for overtime at 6:00 PM and clocks out at 8:00 PM, the clock-in hours are 2 hours.
Notes:
- If there is break time, it is usually included in the clock-in hours.
Work Hours
Definition: Work hours refer to the actual effective working hours invested by the employee. This usually excludes break time and counts only actual working time.
Calculation Method: Work Hours = End Work Time − Start Work Time (only integer hours are counted; minutes are discarded)
Example: If an employee clocks in for overtime at 5:57 PM and clocks out at 8:13 PM, the work hours are calculated as 2 hours (minutes are not counted).
Additional Notes:
- Calculating work hours using only integer hours helps simplify payroll calculations and working hour records.
Clock-in Records with Schedule (CSV)
Home > Admin Mode > Clock-in Records > Export Clock-in Records > Clock-in Records with Schedule (CSV)Administrators can click Clock-in Records and Management on the Home page in Admin Mode, then select Export Clock-in Records, and choose Clock-in Records with Schedule to enter the page. All field names in the exported CSV file are displayed in English, including User ID, Employee ID, Employee Name, Time, Status, Schedule, Checkpoint, GPS Location (Latitude, Longitude), WiFi, Bluetooth, NFC, Approved, Created, Photo, and Notes. The Chinese names above are provided only for administrator reference.
The exported detailed clock-in record fields are in English. The corresponding descriptions are as follows:
| No. | English Field | Description | Example |
|---|---|---|---|
| 1 | User ID | The unique identification ID of the user (employee) | dReHKiseggH3kiOlhnj876fheKle |
| 2 | Employee ID | The employee number of the user (employee) | 1 |
| 3 | Employee Name | The name of the user (employee) | Lin Xiaoming |
| 4 | Time | The clock-in time of the record, Year-Month-Day Hour:Minute | 2025-11-20 09:00 |
| 5 | Status | Start or end of work. START indicates start, END indicates end | START END |
| 6 | Schedule | The schedule name of the clock-in record | Central Office |
| 7 | Checkpoint | The checkpoint of the clock-in record | Office Area |
| 8 | GPS | The GPS location of the clock-in record, Latitude, Longitude | 24.1731843,120.6611364 |
| 9 | WiFi | The WiFi name when clocking in within a restricted WiFi range | LOL520_2G |
| 10 | Bluetooth | The Bluetooth name when clocking in within a restricted Bluetooth range | MSBeacon |
| 11 | NFC | The NFC name and card serial number when scanning an NFC tag for clock-in | NFC01 - D2:6B:94:00 |
| 12 | Approved | Whether this is a make-up clock-in. YES indicates yes; blank indicates no | YES |
| 13 | Created | Whether this is an administrator-created record. YES indicates yes; blank indicates no | |
| 14 | Photo | Whether the employee uploaded a photo. YES indicates yes; blank indicates no | YES |
| 15 | Notes | The employee’s clock-in remarks | Clock-in for Work |
Export Data Description
The SwipePoint system permanently stores clock-in records in the cloud. However, export permissions and time range limits vary depending on the organization’s subscription status.
Export Function Categories and Restrictions
Depending on whether your organization subscribes to the Organization Ad-Free Plan, export permissions are divided into the following two categories:
| Subscription Status | Export Target Limit | Time Range Limit |
|---|---|---|
| Not Subscribed to Organization Ad-Free Plan | Only personal export is allowed; the Export All function is unavailable | Up to 2 months of data can be exported |
| Subscribed to Organization Ad-Free Plan | Personal export or Export All is available | Up to 1 year of detailed data can be exported |
Solution for Garbled Text in Clock-in Record Export Files
When opening a CSV file of clock-in records in Excel on a Windows computer, garbled text may appear. This is usually caused by a mismatch between the CSV encoding format and Excel’s default encoding format. By default, Excel prefers ANSI (such as Big5) or UTF-16 encoding, while many systems or programs export CSV files using UTF-8.
Method 1: Save the CSV File in a Compatible Encoding Format
- Open the CSV file using a text editor (such as Notepad++ or VS Code).
- Select
Save As. - Choose ANSI (recommended Big5 in a Traditional Chinese environment) or UTF-8 with BOM in the encoding options.
- Save the file and reopen it in Excel.
Method 2: Use Excel’s Text Import Wizard
- Open Excel and create a blank worksheet.
- Select
Data > Get Data > From Text/CSV(or select Import Text File depending on the version). - Browse and select the administrator’s CSV file.
- During the import process, choose the correct encoding format (such as UTF-8 or Big5).
- Click Finish to correctly import the data.
Clock-in Records without Schedule (CSV)
Home > Admin Mode > Clock-in Records > Export Clock-in Records > Clock-in Records without Schedule (CSV)Administrators can click Clock-in Records and Management on the Home page in Admin Mode, then select Export Clock-in Records, and choose Clock-in Records without Schedule to enter the page. All field names in the exported CSV file are displayed in English, including User ID, Employee ID, Employee Name, Time, Status, Checkpoint, GPS Location (Latitude, Longitude), WiFi, Bluetooth, NFC, Approved, Created, Photo, and Notes. The Chinese names above are provided only for administrator reference.
The exported detailed clock-in record fields are in English. The corresponding descriptions are as follows:
| No. | English Field | Description | Example |
|---|---|---|---|
| 1 | User ID | The unique identification ID of the user (employee) | dReHKiseggH3kiOlhnj876fheKle |
| 2 | Employee ID | The employee number of the user (employee) | 1 |
| 3 | Employee Name | The name of the user (employee) | Lin Xiaoming |
| 4 | Time | The clock-in time of the record, Year-Month-Day Hour:Minute | 2025-11-20 09:00 |
| 5 | Status | Start or end of work. START indicates start, END indicates end | START END |
| 6 | Checkpoint | The checkpoint of the clock-in record | Office Area |
| 7 | GPS | The GPS location of the clock-in record, Latitude, Longitude | 24.1731843,120.6611364 |
| 8 | WiFi | The WiFi name when clocking in within a restricted WiFi range | LOL520_2G |
| 9 | Bluetooth | The Bluetooth name when clocking in within a restricted Bluetooth range | MSBeacon |
| 10 | NFC | The NFC name and card serial number when scanning an NFC tag for clock-in | NFC01 - D2:6B:94:00 |
| 11 | Approved | Whether this is a make-up clock-in. YES indicates yes; blank indicates no | YES |
| 12 | Created | Whether this is an administrator-created record. YES indicates yes; blank indicates no | |
| 13 | Photo | Whether the employee uploaded a photo. YES indicates yes; blank indicates no | YES |
| 14 | Notes | The employee’s clock-in remarks | Clock-in for Work |
Overtime Clock-in Records (CSV)
Home > Admin Mode > Clock-in Records > Export Clock-in Records > Overtime Clock-in Records (CSV)Administrators can click Clock-in Records and Management on the Home page in Admin Mode, then select Export Clock-in Records, and choose Overtime Clock-in Records to enter the page. All field names in the exported CSV file are displayed in English, including User ID, Employee ID, Employee Name, Time, Status, Checkpoint, GPS Location (Latitude, Longitude), WiFi, Bluetooth, NFC, Approved, Created, Photo, and Notes. The Chinese names above are provided only for administrator reference.
The exported detailed clock-in record fields are in English. The corresponding descriptions are as follows:
| No. | English Field | Description | Example |
|---|---|---|---|
| 1 | User ID | The unique identification ID of the user (employee) | dReHKiseggH3kiOlhnj876fheKle |
| 2 | Employee ID | The employee number of the user (employee) | 1 |
| 3 | Employee Name | The name of the user (employee) | Lin Xiaoming |
| 4 | Time | The clock-in time of the record, Year-Month-Day Hour:Minute | 2025-11-20 09:00 |
| 5 | Status | Start or end of work. START indicates start, END indicates end | START END |
| 6 | Checkpoint | The checkpoint of the clock-in record | Office Area |
| 7 | GPS | The GPS location of the clock-in record, Latitude, Longitude | 24.1731843,120.6611364 |
| 8 | WiFi | The WiFi name when clocking in within a restricted WiFi range | LOL520_2G |
| 9 | Bluetooth | The Bluetooth name when clocking in within a restricted Bluetooth range | MSBeacon |
| 10 | NFC | The NFC name and card serial number when scanning an NFC tag for clock-in | NFC01 - D2:6B:94:00 |
| 11 | Approved | Whether this is a make-up clock-in. YES indicates yes; blank indicates no | YES |
| 12 | Created | Whether this is an administrator-created record. YES indicates yes; blank indicates no | |
| 13 | Photo | Whether the employee uploaded a photo. YES indicates yes; blank indicates no | YES |
| 14 | Notes | The employee’s clock-in remarks | Clock-in for Work |
Unable to Export Clock-in Records
The reason for export failure is that the organization name configured by the administrator contains special characters such as " / ". Please go to Organization Name and modify it using the following path:
Home > Admin Mode > Organization > My Organization > Organization NameAdministrators can click Organization on the Home page in Admin Mode, then select My Organization to enter the page and modify the Organization Name.
Frequently Asked Questions
Q1: How can administrators export employee clock-in records?
A: Administrators can export clock-in records through the following path: Home > Admin Mode > Clock-in Records and Management > Export Overtime Records > Select Month. Select the month to be exported on this page to download the clock-in record file.
Q2: What is the file format of the exported clock-in records?
A: The exported clock-in record file can be opened and edited using Excel software.
Q3: What data is included in the exported file?
A: The exported file includes the following fields: Employee ID, Name, Start Work Time, End Work Time, Clock-in Hours, Work Hours.
Q4: Does the exported file include overtime records?
A: No. This export function only provides general clock-in records and does not include overtime records.
Q5: What are “Clock-in Hours”?
A: Clock-in hours refer to the total duration from the start clock-in time to the end clock-out time, including all working periods and break periods. The calculation method is End Work Time minus Start Work Time. For example, if work starts at 9:00 AM and ends at 6:00 PM, the clock-in hours are 9 hours.
Q6: What are “Work Hours”?
A: Work hours refer to the actual effective working hours invested by the employee, usually excluding break time. The calculation method is End Work Time minus Start Work Time, counting only integer hours and discarding minutes. For example, if work starts at 8:57 AM and ends at 5:40 PM, the work hours are calculated as 8 hours.
Q7: Why are work hours calculated using only integer hours?
A: Work hours are calculated using only integer hours to simplify payroll calculations and working hour records.
Q8: Why am I unable to export clock-in records?
A: The reason may be that the administrator’s organization name contains special characters (such as " / "). The administrator needs to modify the organization name on the My Organization page and remove special characters before trying again. The path is:
Home > Admin Mode > Organization > My Organization > Organization Name.
Q9: Will clock-in records of resigned employees be included in the export?
A: No. Whether exporting clock-in records or exporting detailed clock-in records (CSV), only records of currently employed employees are included. Records and clock-in data of resigned employees cannot be exported.
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.