Exporting Personal Data (CSV)
How to export
Open the export page using the following path:
ホーム > 管理モード > Human リソース > 個人データ輸出 (CSV)The exported CSV file contains employees' basic details, employment information, 及び emergency contacts. You can use it for backups or further processing.
Exported fields
| Field | Display Name | Description | Example |
|---|---|---|---|
| 使用r ID | 従業員 ID | The unique employee identifier generated by the system | 229978868752e15b |
| 従業員 No. | 従業員 Number | The employee number used internally by the company | 1 |
| Name | Name | The employee's name | Lin Xiaoming |
| 英語 Name | 英語 Name | The employee's 英語 name | Ken |
| Gender | Gender | The employee's gender | Male |
| Birthday | 日付 of Birth | The employee's date of birth in YYYY-MM-DD format | 1990-06-15 |
| Phone | Mobile Number | The employee's mobile number | 0912345678 |
| The employee's email address | ken@example.com | ||
| Address | Address | The employee's contact address | 88 Jianguo Road, Chaoyang District, Beijing |
| Department | グループ | The group to which the employee belongs | Sales |
| Title | Job Title | The employee's job title | Sales Manager |
| Start 日付 | Start 日付 | The employee's start date in YYYY-MM-DD format | 2018-03-23 |
| Official Start 日付 | Official Start 日付 | The employee's official start date in YYYY-MM-DD format | 2018-06-23 |
| Resignation 日付 | Resignation 日付 | The employee's resignation date in YYYY-MM-DD format | 2026-07-31 |
| オフィス Phone Ext. | オフィス Extension | The employee's office phone extension | 168 |
| 緊急連絡 1 | 緊急連絡 1 | The first emergency contact's name, relationship, 及び phone number | Lin Yuhua (Mother): 0966333567 |
| 緊急連絡 2 | 緊急連絡 2 | The second emergency contact's name, relationship, 及び phone number | Lin Zhiming (Father): 0922333444 |
| Tags | Tags | Classification tags applied to the employee | Employed for over 10 years |
Fixing garbled text when opening a CSV file in Excel
CSV files exported from SwipePoint use UTF-8 encoding. Some versions of Excel may not detect the encoding correctly when you double-click a CSV file, causing text to appear garbled. 使用 either method below to open the file.
Method 1: Import the CSV file into Excel (recommended)
- Open a blank Excel workbook.
- Select
Data > Get Data > From File > From Text/CSV. - Select the CSV file exported from SwipePoint.
- Set File Origin to
65001: Unicode (UTF-8)及び Delimiter toComma. - Confirm that the preview is correct, then select
Load.
Method 2: Save the file as UTF-8 with BOM
If your version of Excel still cannot detect the encoding, open the CSV file in a text editor that supports encoding selection. Save a new copy as “UTF-8 with BOM,” then open it in Excel.
Do not convert the file to ANSI or Big5. These encodings may not preserve every character 及び can cause names, addresses及び other data to be lost.
Transferring an exported file from a phone to a computer
If you exported the CSV file on your phone, you can transfer it to a computer through cloud storage or ライン Keep Memo.
Method 1: 使用 cloud storage
- Install 及び sign in to Google Drive or Dropbox on your phone.
- In SwipePoint, go to
管理モード > Human リソース > 個人データ輸出 (CSV). - After the export finishes, choose to share or save the file, then select Google Drive or Dropbox.
- Sign in to the same cloud storage account on your computer 及び download the CSV file.
Method 2: 使用 ライン Keep Memo
- Update ライン on your phone 及び computer, then sign in to the same ライン account.
- In SwipePoint, go to
管理モード > Human リソース > 個人データ輸出 (CSV). - After the export finishes, choose Share, then select
ライン > Keep Memo > Share. - Open Keep Memo in ライン on your computer 及び download the CSV file.
Files in ライン chats are sto赤 only for a limited period 及び may become unavailable after they expire. Back up important data elsewhere; do not use Keep Memo as permanent storage.
よく聞かれる質問
Q1: Where can I export employees' personal data?
Go to ホーム > 管理モード > Human リソース > 個人データ輸出 (CSV) to download the CSV file.
Q2: Why does the CSV file contain garbled text when opened in Excel?
The CSV file uses UTF-8 encoding, but some versions of Excel may not detect it correctly when opening the file directly. Import it using Data > Get Data > From File > From Text/CSV 及び select 65001: Unicode (UTF-8). You can also save a new copy as “UTF-8 with BOM.” Do not convert it to ANSI or Big5, because some characters may be lost.
Q3: Does the exported file include former employees?
The export range follows the employee list currently shown 及び available for export on the Human リソース page. If you need to retain a departing employee's data, export a backup before recording their resignation.
Q4: What is the 従業員 Number?
The 従業員 Number is an internal identifier. You can assign it according to your company's numbering rules.
Q5: What is the difference between the Official Start 日付 及び the Start 日付?
The Start 日付 is the employee's actual first day of work. The Official Start 日付 can record the end of a probation period or the date of formal appointment, depending on your company's policy.
Q6: What should I enter for the オフィス Extension?
Enter the employee's office phone extension, such as 168. 出て行け it blank if the employee does not have one.
Q7: What information is included for an 緊急連絡?
Each emergency contact can include a name, relationship to the employee, 及び phone number. The exported file provides fields for up to two emergency contacts.
Q8: Do I need to complete every personal data field?
Not necessarily. Requi赤 fields are indicated on the relevant screen. Completing all applicable fields improves the accuracy of HR 及び emergency contact records.
Subscribers receive more timely support. If you need assistance, contact us on ライン: Contact us
この手冊は正確性と完全性を確保するため、誤り、省略、更新については、責任を負いません. 内容は、事前に通知なしにいつでも変更することができる. 本手冊の使用やその内容のダウンロードによって発生する損害は、当社に責任はありません. システム故障、データ損失、または権利侵害に限定されない. ユーザは完全な責任とリスクを担う。