HRM Core

Import and Export Employees

Import many employees at the same time from a CSV file. You can also export your employees to a CSV file, for example to use in a spreadsheet.

Before you start

  • You must be a WordPress administrator or an HR manager.
  • Each employee in the file needs a different email address.
  • You can import up to 500 employees in one file.

Import employees

Step 1: Open the Import window

  1. In your WordPress admin, go to WP ERP → HR → People → All Employees.
  2. Click the small arrow next to Export.
  3. Click Import.
The Import option next to the Export button

Step 2: Get the sample file

  1. Click Download Sample CSV. WP ERP downloads the file employees-template.csv.
  2. Open the file in a spreadsheet program.
  3. Add one employee on each row. Keep the column names in the first row.
  4. Save the file as CSV.
The Import Employee window

Step 3: Upload the file

  1. Click Choose File, and select your CSV file. You can also drag the file into the window.
  2. Look at Map Properties. WP ERP matches each column in your file to an employee field.
  3. If a column has the wrong field, select the correct field in the list.
Map Properties after the upload

Step 4: Import

  1. Click Import Employee.
  2. When the import is complete, click Done. To import one more file, click Import another file.
The import result

If some rows fail, the window shows "Import finished" and a list of the rows that failed, with the reason.

The columns in the CSV file

Only first_name, last_name, and email are necessary. All other columns are optional.

ColumnWhat to put in it
first_name, middle_name, last_nameThe name of the employee.
emailThe work email. It must be different for each employee.
employee_idYour own ID for the employee.
typepermanent (Full Time), parttime, contract, temporary, or trainee.
statusactive, inactive, terminated, deceased, or resigned.
hiring_date, end_date, date_of_birthA date in the format YYYY-MM-DD, for example 2026-11-23.
department, designation, locationThe ID number of the department, job title, or location. See the note below.
reporting_toThe ID number of the manager. See the note below.
pay_rateA number, for example 5800.
pay_typehourly, daily, weekly, biweekly, monthly, or contract.
hiring_source, phone, mobile, gender, marital_statusOptional personal and work details. Use male, female, or other for gender.

Note: In WP ERP 2.0.0, the import reads department, designation, location, and reporting_to only as ID numbers. If you type a name, the import adds the employee but keeps this field empty. Then you can set the field on the profile of each employee.

Each location must exist before you import. To add one, see Add an office location.

Export employees

  1. Go to WP ERP → HR → People → All Employees.
  2. Click Export.
  3. All fields are selected. To export fewer fields, clear the fields that you do not need.
  4. Click Continue.
The Export Employee window

WP ERP downloads the file employees.csv and shows "Export ready. Check your downloads." The file has the active employees only.

What changed in WP ERP 2.0

  • Import is now in the menu next to the Export button on the employee list.
  • After you upload a file, a Map Properties step lets you match your columns to the employee fields.
  • In earlier versions, the import matched departments, job titles, and locations by name, and made new ones if they did not exist. WP ERP 2.0.0 does not do this. It reads these columns as ID numbers only.
  • In earlier versions, you added the manager by email in Reporting to. WP ERP 2.0.0 reads this column as an ID number only.

Was this article helpful to you?

How can we help?