Skip to content

Importing Users from a CSV File to WordPress

If you need to add multiple users to your WordPress site at once, the easiest way is to import them from a CSV file. On ruachost.com, this can be done using the Import Users from CSV with Meta plugin.

  • Saves time compared to adding users manually.
  • Supports bulk onboarding for membership sites, e‑commerce, or schools.
  • Allows importing custom user metadata (roles, profile fields, etc.).
  • Can send welcome e‑mails automatically to new users.
  1. Log in to WordPress with an administrator account.

  2. In the dashboard, go to Plugins → Add New.

  3. Search for Import users from CSV with meta.

  4. Click Install Now, then Activate.

  5. In the dashboard, go to Tools → Import and Export Users and Customers.

  6. Under the Import tab, upload your CSV file.

    • The plugin auto‑detects delimiters (commas, semicolons, etc.).
    • You can set default role, send welcome e‑mails, and other options.
  7. Click Start Importing.

  8. Once complete, a summary of imported users will be displayed.

  9. Go to Users → All Users to verify the new accounts.

Your CSV file should include at least the following columns:

user_login,user_email,first_name,last_name,role
jdoe,jdoe@example.com,John,Doe,subscriber
asmith,asmith@example.com,Alice,Smith,editor
  • Additional columns can be used for custom metadata (e.g., phone, address).
  • Always back up your database before bulk imports.
  • Ensure e‑mail addresses are unique to avoid conflicts.
  • Large imports may take time avoid running during peak traffic.
  • Imported metadata can be edited later in user profiles.