Data Import
Import employee and project data from files
Employee Import
Import employee data from Excel file (PIS002.xls format)
Drop file here or click to browse
Supported formats: .xls, .xlsx, .csv
Project Import
Import project data from CSV or Excel file
Drop file here or click to browse
Supported formats: .xls, .xlsx, .csv
Sample Templates
Download sample templates to see the expected format for import files.
PIS002 Format Reference
The employee import expects the following columns from PIS002.xls:
| Column | Field | Description | Example |
|---|---|---|---|
| A | person | Nickname (unique identifier) | Note, Bank, Fern |
| B | fullName | Full name in Thai | นายเพฑาย จันทิมา |
| C | Work email address | pathay@depthfirst.co.th | |
| D | position | Job position/title | ผู้จัดการส่วนพัฒนาระบบระดับอาวุโส |
| E | role | One of: Dev, SA, BA, QA, Data, UX/UI, PM, Implementer, Support, Sales, BackOffice, Management | Dev |
| F | level | One of: Junior, Senior, Supervisor, Manager, Director, MD | Manager |