輸出時計記録
ホーム > Admin モード > 打刻 Records > 輸出時計記録On the Admin モード home page, administrators can select 打刻 Records 及び Management, then 輸出時計記録. The system provides 打刻 Records with 予定表, 打刻 Records without 予定表, 及び オーバータイムタイムインレコード. Each type can be exported in Excel or CSV format.
打刻 Records with 予定表 (Excel)
ホーム > Admin モード > 打刻 Records > 輸出時計記録 > 打刻 Records with 予定表 (Excel)On the Admin モード home page, select 打刻 Records 及び Management > 輸出時計記録 > 打刻 Records with 予定表, choose a date range, 及び export the records. The Excel file can be opened 及び edited in Microsoft Excel or another compatible spreadsheet application.
Data Format
| No. | Field | Description | Example |
|---|---|---|---|
| 1 | スケジュール名 | 予定表 name 及び date | Day Shift (Wed, 4/1) |
| 2 | 予定表 Time | 予定表d start 及び end times | 2026-04-01 09:00-18:00 |
| 3 | Break | 予定表d break time | 12:00-13:00 |
| 4 | Start Work | Time when the user (employee) clocks in to start work | 2026-04-01 08:58 |
| 5 | End Work | Time when the user (employee) clocks out from work | 2026-04-01 18:03 |
| 6 | 打刻 時間 | Total time from Start Work to End Work | 8h 5m |
打刻 時間
Definition: 打刻 時間 is the total time from an employee's first clock-in to their final clock-out during a workday. It includes both working periods 及び breaks between them.
計算: 打刻 時間 = End Work time - Start Work time
Example: If an employee clocks in at 9:00 AM 及び clocks out at 6:00 PM, the 打刻 時間 value is 9 hours.
記号:
- Lunch 及び other breaks are normally included in 打刻 時間.
打刻 Records without 予定表 (Excel)
ホーム > Admin モード > 打刻 Records > 輸出時計記録 > 打刻 Records without 予定表 (Excel)On the Admin モード home page, select 打刻 Records 及び Management > 輸出時計記録 > 打刻 Records without 予定表, choose a date range, 及び export the records. The Excel file can be opened 及び edited in Microsoft Excel or another compatible spreadsheet application.
Data Format
| No. | Field | Description | Example |
|---|---|---|---|
| 1 | 日付 | Start date of the pai赤 clock-in record | Fri, 2026-04-03 |
| 2 | Start Work | Time when the user (employee) clocks in to start work | 2026-04-03 02:59 |
| 3 | End Work | Time when the user (employee) clocks out from work | 2026-04-03 09:06 |
| 4 | 打刻 時間 | Total time from clock-in to clock-out | 7h 7m |
| 5 | Work 時間 | 打刻 時間 converted to whole hours | 7 hrs |
打刻 時間
Definition: 打刻 時間 is the total time from an employee's first clock-in to their final clock-out during a workday. It includes both working periods 及び breaks between them.
計算: 打刻 時間 = End Work time - Start Work time
Example: If an employee clocks in at 9:00 AM 及び clocks out at 6:00 PM, the 打刻 時間 value is 9 hours.
記号:
- Lunch 及び other breaks are normally included in 打刻 時間.
Work 時間
Definition: Work 時間 is the exported whole-hour value calculated by subtracting Start Work from End Work. This field does not automatically deduct break time.
計算: Work 時間 = whole hours in 打刻 時間 (minutes below one hour are discarded)
Example: If an employee clocks in at 8:57 AM 及び clocks out at 5:40 PM, Work 時間 is 8 hours because the remaining minutes are not included.
Additional information:
- This field is for summary purposes only. 支払roll 及び overtime pay should still be calculated according to the organization's attendance 及び break rules.
オーバータイムタイムインレコード (Excel)
ホーム > Admin モード > 打刻 Records > 輸出時計記録 > オーバータイムタイムインレコード (Excel)On the Admin モード home page, select 打刻 Records 及び Management > 輸出時計記録 > オーバータイムタイムインレコード, choose a date range, 及び export the records. The Excel file can be opened 及び edited in Microsoft Excel or another compatible spreadsheet application.
Data Format
| No. | Field | Description | Example |
|---|---|---|---|
| 1 | 日付 | Start date of the pai赤 clock-in record | Fri, 2026-04-03 |
| 2 | Start Work | Time when the user (employee) clocks in to start overtime | 2026-04-03 02:59 |
| 3 | End Work | Time when the user (employee) clocks out from overtime | 2026-04-03 09:06 |
| 4 | 打刻 時間 | Total time from clock-in to clock-out | 7h 7m |
| 5 | Work 時間 | 打刻 時間 converted to whole hours | 7 hrs |
打刻 時間
Definition: 打刻 時間 is the total time from an employee's first clock-in to their final clock-out during a work period. It includes both working periods 及び breaks between them.
計算: 打刻 時間 = End Work time - Start Work time
Example: If an employee clocks in for overtime at 6:00 PM 及び clocks out at 8:00 PM, the 打刻 時間 value is 2 hours.
記号:
- Breaks are normally included in 打刻 時間.
Work 時間
Definition: Work 時間 is the exported whole-hour value calculated by subtracting Start Work from End Work. This field does not automatically deduct break time.
計算: Work 時間 = whole hours in 打刻 時間 (minutes below one hour are discarded)
Example: If an employee clocks in for overtime at 5:57 PM 及び clocks out at 8:13 PM, Work 時間 is 2 hours because the remaining minutes are not included.
Additional information:
- This field is for summary purposes only. 支払roll 及び overtime pay should still be calculated according to the organization's attendance 及び break rules.
打刻 Records with 予定表 (CSV)
ホーム > Admin モード > 打刻 Records > 輸出時計記録 > 打刻 Records with 予定表 (CSV)The exported CSV uses 英語 field names. Records with a schedule include the 予定表 field. The fields are described below:
| No. | Field | Description | Example |
|---|---|---|---|
| 1 | 使用r ID | Unique ID of the user (employee) | dReHKiseggH3kiOlhnj876fheKle |
| 2 | 従業員 ID | 従業員 number of the user (employee) | 1 |
| 3 | 従業員の名前 | Name of the user (employee) | Lin Xiaoming |
| 4 | Time | 時計の時間 in Year-Month-Day Hour:Minute format | 2025-11-20 09:00 |
| 5 | 状態 | START means Start Work; END means End Work |
START / END |
| 6 | 予定表 | 予定表 name associated with the record | Central オフィス |
| 7 | Checkpoint | Checkpoint associated with the record | オフィス Area |
| 8 | GPS | GPS coordinates in latitude, longitude order | 24.1731843,120.6611364 |
| 9 | WiFi | Wi-Fi name used for a Wi-Fi-restricted clock-in | LOL520_2G |
| 10 | Bluetooth | Bluetooth device name used for a range-restricted clock-in | MSBeacon |
| 11 | NFC | NFC name 及び card serial number scanned for the clock-in | NFC01 - D2:6B:94:00 |
| 12 | 承認 | YES means a make-up clock-in; blank means no |
YES |
| 13 | Created | YES means the record was added by an administrator; blank means no |
|
| 14 | 写真 | YES means the employee uploaded a photo; blank means no |
YES |
| 15 | 記号s | 従業員's clock-in note | Clocked in for work |
Export Data Description
SwipePoint stores clock-in records in the cloud. The employees 及び date ranges available for export depend on the organization's subscription status.
Export Function Categories 及び Restrictions
Export permissions depend on whether your organization subscribes to the 組織 Ad-Free plan:
| Subscription 状態 | Export Scope | 日付 Range Limit |
|---|---|---|
| Not subscribed to 組織 Ad-Free | Personal records only; Export All is unavailable. | Up to 2 months of data. |
| Subscribed to 組織 Ad-Free | Personal records or Export All. | Up to 1 year of detailed data. |
Fix Garbled Text in Exported 打刻 Records
When a UTF-8 CSV is opened directly in Excel on Windows, non-英語 text may appear garbled if Excel does not detect the encoding correctly. 使用 Excel's import feature first. If the issue remains, save a copy of the file as UTF-8 with BOM.
Method 1: Import a UTF-8 CSV in Excel
- Open Excel 及び create a blank workbook.
- Select
Data > Get Data > From File > From Text/CSV. In some versions, selectData > From Text/CSV. - Select the exported CSV file.
- 内部 preview, set File Origin or the encoding option to
65001: Unicode (UTF-8), 及び confirm that the text appears correctly. - 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 記号pad++ or VS Code.
- Select Save As 及び set the encoding to
UTF-8 with BOM. - Save a copy, then open that copy in Excel.
Keep the original CSV as a backup. Do not convert it to ANSI or Big5, because characters that those encodings cannot represent may be lost.
打刻 Records without 予定表 (CSV)
ホーム > Admin モード > 打刻 Records > 輸出時計記録 > 打刻 Records without 予定表 (CSV)The exported CSV uses 英語 field names. Records without a schedule do not include the 予定表 field. The fields are described below:
| No. | Field | Description | Example |
|---|---|---|---|
| 1 | 使用r ID | Unique ID of the user (employee) | dReHKiseggH3kiOlhnj876fheKle |
| 2 | 従業員 ID | 従業員 number of the user (employee) | 1 |
| 3 | 従業員の名前 | Name of the user (employee) | Lin Xiaoming |
| 4 | Time | 時計の時間 in Year-Month-Day Hour:Minute format | 2025-11-20 09:00 |
| 5 | 状態 | START means Start Work; END means End Work |
START / END |
| 6 | Checkpoint | Checkpoint associated with the record | オフィス Area |
| 7 | GPS | GPS coordinates in latitude, longitude order | 24.1731843,120.6611364 |
| 8 | WiFi | Wi-Fi name used for a Wi-Fi-restricted clock-in | LOL520_2G |
| 9 | Bluetooth | Bluetooth device name used for a range-restricted clock-in | MSBeacon |
| 10 | NFC | NFC name 及び card serial number scanned for the clock-in | NFC01 - D2:6B:94:00 |
| 11 | 承認 | YES means a make-up clock-in; blank means no |
YES |
| 12 | Created | YES means the record was added by an administrator; blank means no |
|
| 13 | 写真 | YES means the employee uploaded a photo; blank means no |
YES |
| 14 | 記号s | 従業員's clock-in note | Clocked in for work |
オーバータイムタイムインレコード (CSV)
ホーム > Admin モード > 打刻 Records > 輸出時計記録 > オーバータイムタイムインレコード (CSV)The exported CSV uses 英語 field names. 余分時間 records do not include the 予定表 field. The fields are described below:
| No. | Field | Description | Example |
|---|---|---|---|
| 1 | 使用r ID | Unique ID of the user (employee) | dReHKiseggH3kiOlhnj876fheKle |
| 2 | 従業員 ID | 従業員 number of the user (employee) | 1 |
| 3 | 従業員の名前 | Name of the user (employee) | Lin Xiaoming |
| 4 | Time | 時計の時間 in Year-Month-Day Hour:Minute format | 2025-11-20 09:00 |
| 5 | 状態 | START means Start Work; END means End Work |
START / END |
| 6 | Checkpoint | Checkpoint associated with the record | オフィス Area |
| 7 | GPS | GPS coordinates in latitude, longitude order | 24.1731843,120.6611364 |
| 8 | WiFi | Wi-Fi name used for a Wi-Fi-restricted clock-in | LOL520_2G |
| 9 | Bluetooth | Bluetooth device name used for a range-restricted clock-in | MSBeacon |
| 10 | NFC | NFC name 及び card serial number scanned for the clock-in | NFC01 - D2:6B:94:00 |
| 11 | 承認 | YES means a make-up clock-in; blank means no |
YES |
| 12 | Created | YES means the record was added by an administrator; blank means no |
|
| 13 | 写真 | YES means the employee uploaded a photo; blank means no |
YES |
| 14 | 記号s | 従業員's clock-in note | Clocked in for work |
Unable to 輸出時計記録
If the organization name contains characters that are not supported in file names, such as /, the export may fail. 使用 the following path to edit the 組織 Name, remove the unsupported characters, 及び try again:
ホーム > Admin モード > 組織 > My 組織 > 組織 NameIf the export still fails after you remove unsupported characters, note the export type, date range, 及び on-screen error message, then contact the SwipePoint team.
進歩的な使用
Create a Summary of All 従業員s' 時間
管理者s can submit the exported Excel file 及び the prompt below to チャットGPT, Gemini及び another AI tool that can process spreadsheets. Before uploading the file, follow your organization's data-h及びling policies 及び remove any personal data that is not needed.
File to Upload
The Excel file exported for this task. Do not alter the original file; create a copy first.
迅速に
Please process the uploaded Excel file 及び export the completed result as an .xlsx file.
Requirements:
1. Keep all existing worksheets 及び data. Do not modify the original content.
2. Add a worksheet named "Summary" 及び place it first in the workbook.
3. 使用 dates for the columns in Summary. Determine the start 及び end dates from the digits at the end of the file name.
For example, if the file name contains 20260301-20260430, list dates from 2026/03/01 through 2026/04/30.
4. 使用 employee names for the rows in Summary. Obtain the names from the existing worksheet names.
5. Fill the cells from the actual clock-in records in each employee worksheet, using this format:
Start Work time - End Work time
6. Follow these rules strictly:
使用 only Start Work 及び End Work times that actually exist in the source data.
Do not infer times from the schedule.
Do not insert 08:00, 00:00及び any other time that is not present.
If a day contains only one time, such as 00:00, enter only 00:00. Do not change it to 00:00 - 08:00.
If a date has no clock-in record, leave the cell blank.
Do not fill trailing blank records with numbers or times.
If a date has multiple clock-in records, list them in source order in the same cell, using line breaks if needed.
7. Assign each record to the date shown in the source data. Do not change the date because a shift crosses midnight or because of the schedule time.
8. Export a new Excel file with the .xlsx extension containing:
First worksheet: Summary
Remaining worksheets: all original data worksheetsよく聞かれる質問
Q1: How can administrators export employee clock-in records?
A: Go to ホーム > Admin モード > 打刻 Records 及び Management > 輸出時計記録. Select records with a schedule, without a schedule及び overtime records, then choose the date range 及び file format 及び export the file.
Q2: Which file formats are available for exported clock-in records?
A: You can choose Excel or CSV. Excel is suitable for direct viewing 及び editing. CSV uses 英語 field names 及び is suitable for import into other systems.
Q3: What data is included in the exported file?
A: The fields depend on the export type 及び format. Excel exports contain summary fields such as 日付, Start Work, End Work, 及び 打刻 時間. CSV exports contain detailed fields for user 及び employee identification, time, status, checkpoint, location or device data, make-up clock-ins, 及び notes. A scheduled CSV also includes 予定表.
Q4: Does the exported file include overtime records?
A: Yes. On the export page, select オーバータイムタイムインレコード, then choose Excel or CSV.
Q5: What are "打刻 時間"?
A: 打刻 時間 is the total time from an employee's first clock-in to their final clock-out, including working periods 及び breaks between them. It is calculated as End Work time minus Start Work time. For example, 9:00 AM to 6:00 PM produces 9 打刻 時間.
Q6: What are "Work 時間"?
A: Work 時間 is the exported whole-hour value derived from 打刻 時間. It does not automatically deduct break time. For example, 打刻 時間 from 8:57 AM to 5:40 PM is 8 hours 及び 43 minutes, so Work 時間 displays 8 hours.
Q7: Why does Work 時間 include only whole hours?
A: The field is displayed in whole hours, so minutes below one hour are discarded. It is for summary purposes only; payroll 及び overtime pay should still be calculated according to the organization's rules.
Q8: Why am I unable to export clock-in records?
A: The export may fail if the organization name contains a character that is unsupported in file names, such as /. Go to ホーム > Admin モード > 組織 > My 組織 > 組織 Name, remove the unsupported character, 及び try again. If it still fails, note the export settings 及び error message 及び contact the SwipePoint team.
Q9: Are clock-in records for former employees included in exports?
A: No. Excel 及び CSV exports include data only for current employees. 記録s for former employees cannot currently be exported.
Subscribers receive faster support. If you encounter an error or have trouble using SwipePoint, contact the SwipePoint team through the official ライン account for priority assistance. ライン ID:
@nka7729y; Contact the SwipePoint team.
この手冊は正確性と完全性を確保するため、誤り、省略、更新については、責任を負いません. 内容は、事前に通知なしにいつでも変更することができる. 本手冊の使用やその内容のダウンロードによって発生する損害は、当社に責任はありません. システム故障、データ損失、または権利侵害に限定されない. ユーザは完全な責任とリスクを担う。