How to bulk import members in WordPress

Create a database and file backup before importing anything. Test the backup or use a staging site if the member data is important.

Do not start with the full file. Keep a copy of the original CSV, then prepare a separate working copy so you can undo spreadsheet changes.

Keep one member per row and use a header row. Include a reliable identifier such as user_email, user_login or an existing user ID. Add names, role, membership level, start date, expiry date and custom fields only when your membership plugin supports those fields.

Check for duplicate email addresses, blank required values, invalid email addresses, hidden spaces and spreadsheet dates that have been converted into the wrong format. Save the file as UTF-8 CSV. A common failure is a column shifting because a name or address contains a comma that was not quoted correctly.

Set up the membership levels, courses, groups or access rules before importing members. Record the exact names, IDs or slugs that the importer expects.

Decide whether the import should create new WordPress accounts, update existing accounts, assign access to existing users, or all three. Do not assume that a column called “membership” will be understood automatically; the importer must map it to a real membership field.

For the core user accounts, administrators with command-line access can use wp user import-csv /path/to/users.csv. The standard CSV can contain fields such as user_login, user_email, display_name and role. Existing users matched by email or login are updated unless you use the option that skips updates.

This route is fine for creating a small number of ordinary WordPress users, but it does not by itself understand membership levels, subscription records, course enrolments or plugin-specific custom fields. You must assign those records through the membership plugin or a custom integration, which makes the manual route slow and easier to get wrong on a large migration.

Import five to ten representative rows first. Include a new member, an existing user, a member with custom fields and a member with an expiry date if those cases exist in your file.

Check the user account, membership status, protected content, welcome email behaviour and any subscription information before importing the remaining rows. If the importer reports invalid emails or missing fields, fix the CSV rather than repeatedly uploading the same file.

For a large Paid Memberships Pro migration, Paid Memberships Pro – Import Members From CSV is the fast route. Install Paid Memberships Pro first, then install and activate its import add-on from the WordPress admin. The add-on is designed to assign membership levels and map supported user fields from a CSV.

Upload the cleaned file, map each column, review the preview and run the import in batches if the site or host has tight time limits. Keep the error log and compare the imported count with the source count. The add-on documentation notes that existing users need a matching user ID, login or email field, so omitting those identifiers can create duplicates instead of updating accounts.