Importing users from CSV

Import Users creates or updates many users at once from a CSV file. You see a preview of every row before anything changes.

Prepare the file

One user per row, with a header row naming the columns. The columns used are user_login, user_email, first_name, last_name, display_name, nickname, user_url, description, role, user_pass, and the keys of your profile fields. Only user_email is required. Other columns are ignored.

user_email,first_name,last_name,role
amy@example.com,Amy,Lee,editor
ben@example.com,Ben,Ortiz,

Import

1. Go to Users → Import Users and choose the CSV file.
2. Under Users who already exist, choose Skip them, or Update them with the file’s values. Existing users are matched by email, then username.
3. Pick the Role when none is given. A role column overrides it for that row.
4. Tick Send each new user WordPress’s welcome email if they should set their own password.
5. Click Upload and preview.
6. The preview shows what will happen to each row: create, update or skip, with the reason for any skip (such as a missing email address). Click Import, or Cancel to change the file.

See also Profile fields and Editing roles.

Get the add-on: compare the plans for All-in-One Utilities Pro, then pick the one that fits your sites.