Exporting Employees
Export your employee roster to CSV for payroll systems, audits, or bulk updates
The Export function downloads your current employee data as a CSV file. Use it to back up employee records, prepare data for external payroll or accounting systems, perform bulk edits and re-import, or run HR audits.
How to Export
- Go to Group → Employees.
- Click Export (top-right, next to Import).
- Choose your export scope:
- All employees: every active employee across the group
- Current company: employees in the currently selected company only
- Filtered view: only employees matching the active search/filter
- Click Download.
A .csv file downloads immediately to your browser.
What the Export Contains
The CSV uses the same column structure as the import template, so you can edit and re-upload it directly.
| Column | Notes |
|---|---|
first_name | Legal first name in English |
last_name | Legal last name in English |
first_name_th | First name in Thai script (if set) |
last_name_th | Last name in Thai script (if set) |
email | Login email address |
employee_id | Internal HR code |
hire_date | Format: YYYY-MM-DD |
employment_type | full-time, part-time, contract, or intern |
company | Company name |
department | Department name |
position | Position name |
monthly_salary | Numeric, no currency symbol |
pay_type | salary, hourly, or daily |
national_id | 13-digit Thai national ID |
birthday | Format: YYYY-MM-DD |
gender | male, female, or other |
phone | Phone number |
status | active, inactive, or terminated |
The send_invite column is not included in exports. It is only relevant during import.
Editing and Re-importing
The export-edit-reimport workflow is the fastest way to make bulk changes:
- Export the current employee list.
- Open the CSV in Excel or Google Sheets.
- Edit the values you want to change (e.g. update salaries, change departments).
- Save as CSV.
- Import the file via Group → Employees → Import.
When you re-import, Hopshift matches rows by email address. Existing employees are updated rather than duplicated. Rows with emails that do not exist in the system will create new employee profiles.
Do not change the email column when re-importing for updates. Email is the unique key used to match the row to the existing employee. If you change it, a duplicate profile will be created.
Filtering Before Export
You can narrow the export using the employee list filters:
- Filter by status (e.g. Active only) before exporting to exclude terminated staff
- Filter by department to export a single team
- Filter by company if you are working at the Group level
Only the employees visible in the filtered list are included in the export.
Terminated Employees
Terminated employees are excluded from the default export. To include them:
- In the employee list, set the Status filter to All or Terminated.
- Then click Export.
Related
- Importing Employees: add or update employees in bulk from a CSV
- Employee Management: manage individual employee profiles