Breakdance 2.0 Now Available
Logo
Logo

September 11, 2024

How to Easily Import WordPress Users from a CSV File

 Are you looking to import users to your WordPress website from a CSV file?

By default, WordPress does not include the feature to import users in bulk. While you can add users individually, this can be incredibly time-consuming, especially if you need to import thousands of users.

In this article, we will guide you through the process of importing WordPress users quickly and efficiently. We’ll be using the WP All Import plugin, which simplifies the import process into just a few easy steps.

Let’s get started!

Why Import WordPress Users?

There are several reasons why you might want to import WordPress users in bulk. It’s an invaluable feature for membership sites, online courses, and eCommerce websites where you may need to add thousands of users simultaneously.

You might be migrating to WordPress from another platform, merging multiple WordPress websites, or simply looking to import numerous users at once. In any of these cases, the bulk import process can save you a significant amount of time and effort. It eliminates the need for repetitive manual entry and allows you to add users in just a few steps.

Now that we know the benefits of bulk importing, let’s see how you can easily add multiple users to WordPress using the WP All Import plugin.

Create Your CSV File for Import

Before we begin the import process, we need to compile all our user data into a CSV file.

There are several ways to create a CSV file. If you’re migrating from another platform, you often have the option to export users to a CSV file. This file will usually have the correct formatting and all the required information, so you can jump straight to the import steps.

You can also create your own CSV file using any compatible application, such as Google Sheets or Excel. When creating your own CSV file, it’s important to make sure that each column represents a separate field and each row represents an individual user.

Add Your User Data to the CSV File

If you’re migrating from another platform, your import file created using WP All Export will already include all the necessary user data. However, if you’re creating the CSV file from scratch, the two required fields are the username and email address. These are crucial for WordPress to recognize and manage each user account properly.

You can also include additional user fields, such as:

  • First Name
  • Last Name
  • Nickname
  • Display Name
  • Website
  • User Role
  • Biographical Info
  • Registration Date

User Export File Example

Adding these additional fields can enhance the user profiles on your WordPress site. There may also be other user fields specific to the WordPress website you’re importing to.

For example, if it’s a business website, you might want to include additional fields such as Company and Job title. 

After you’ve added all the fields, go to File › Save As and choose CSV from the list of file types.

If you don’t want to create the file from scratch, you can use this example file from WP All Import.

Now that our CSV file is ready, let’s dive into the import process in detail.

How To Import WordPress Users Using a CSV File

Since WordPress lacks a built-in feature to import users in bulk, we’ll be using the WP All Import plugin.

It’s a user-friendly plugin that includes a wizard to help you import user data in just a few steps. Other than users, it also supports other WordPress data types such as products, orders, taxonomies, and more.

Import WordPress Users with WP All Import

Other key features include:

  • Drag-and-drop interface for easily mapping fields from your import file to WordPress user fields
  • Automate and schedule your imports to run at specified intervals.
  • Support for all data fields including custom fields created by WooCommerce and ACF.
  • Powerful filtering options to selectively import user data.
  • Run PHP functions to manipulate data on the fly.

To import user data, you’ll need the premium version of the core WP All Import plugin along with its User Add-On. 

Once you have both plugins installed, let’s look into the import process in detail.

1. Create a New Import and Upload Your CSV File

To start the import process, navigate to All Import › New Import in your WordPress dashboard and upload your CSV file containing the user information. 

Alternatively, you can add the file in other ways. If your user data file is stored on cloud services such as Dropbox or Google Drive, WP All Import supports importing files directly from a URL.

Additionally, if you have used WP All Export to export users from another WordPress site, you can simply add the export file URL generated in the final step.

Once you’ve added the file, select New Items and choose Users as the import type.

Next, click Continue to Step 2 at the bottom.

2. Review the User Data in your Import CSV File

The next step is the Review Import File page which lets you verify the records in your user import file. WP All Import will display the total user count, and you can navigate between these records individually using the gray arrows at the top.

Review Import File WP All Import

This step ensures that you verify everything before proceeding with the import. 

The same page also allows you to apply filter rules to select a specific subset of users to import. To start adding filters, expand the Manage Filtering Options panel and add the Element, Rule, and Value.

You can add as many rules as needed, and separate each one with an AND or OR condition. Want even more granular control? You can group filters by creating nested filter rules.

For example, you can apply the following filter rules to select users who are either customers or subscribers but do not have the username “admin.”

Manage Filtering Options WP All Import

Since the import data is stored outside the WordPress database, filters are applied using the XPath language.

Once you’ve verified that the data looks accurate, click Continue to Step 3.

3. Map the User data in your CSV File to Relevant WordPress Fields

This is the most important step in the import process. It allows you to map columns from your user import file to the corresponding user fields in WordPress.

WP All Import includes a drag and drop interface that allows you to drag fields from the section on the right to the appropriate field boxes on the left.

Drag and Drop User Import Fields

The fields are organized into different tabs such as User Account Info, Other User Info, and Custom Fields. You can expand these tabs to map the relevant fields.

If you’ve created the import file from scratch, the data inside it might not always be formatted in the way you need it.

WP All Import includes advanced features that allow you to use custom PHP to modify the values in your import file to meet your requirements. You can refer to WP All Import’s documentation to learn more about using custom PHP code.

Once you’ve mapped everything, click Continue to Step 4 to proceed to the next step.

4. Configure Advanced Settings

The Import Settings page appears next and allows you to configure various advanced settings of WP All Import. These settings include assigning a unique identifier, blocking welcome email notifications to users, speed optimization options, and scheduling.

The first option is to set the unique identifier that allows WP All Import to differentiate between users. You can click the Auto-detect option to let WP All Import automatically select the best identifier.

Define Import Settings

If you prefer, you can also manually select it from the user information box on the right. The identifier is crucial when you run the same import with an updated file. There are also a few additional options to control what happens when WP All Import finds new or changed data.

By default, when a new user is imported, WordPress sends a welcome email with a password reset link. If your user data file is an export from another website and you want your users to use their current passwords, you can check the box to block email notifications during the import process.

Email Notifications for Imported Users

WP All Import also includes an automatic import feature that works on a fixed schedule. This allows you to automatically sync new user data from the import file.

The scheduling option only works when you select the “Download from URL” or “Use Existing File” option in the first step of the import. Since we uploaded the CSV file, this option is not available for this import. But if you were to schedule your import, here’s how it would look.

Automatic Scheduling Service

WP All Import also includes speed optimization features that let you specify the number of records to import in each batch and whether to split a large file into multiple smaller files.

Configure Advanced Settings WP All Import

After configuring these settings, click Continue to move to the next step.

5. Run the User Import

In the final step, WP All Import provides a summary of all the previous steps and settings applied. If you spot any mistakes, you can go back to the previous step to correct them.

Import Summary WP All Import

If everything looks good, click Confirm & Run Import at the top to start the import. Depending on the number of users in your import file, WP All Import may take a few minutes to complete. Once the import is finished, you will get a confirmation that shows how many records were imported and how many were updated.

Import Complete WP All Import

To verify that the users were correctly imported, navigate to Users > All Users from your WordPress menu. Open a few newly added users to ensure all details were imported correctly.

Review Imported Users in WordPress

Next: Import Other WordPress Data Types

WP All Import is a single plugin for all your import needs. It supports importing data for custom post types such as WooCommerce products, customers, orders, coupons, and reviews, as well as WordPress posts, pages, taxonomies, and much more.

New Import for Other Post Types

The general process remains the same across different data types, meaning you only need to learn one method to handle all your import requirements.

Ready to effortlessly import user and other data into WordPress? Download and install the WP All Import plugin today!

Import WordPress Users From a CSV File – Frequently Asked Questions

How To Upload Bulk Users in WordPress?

Importing more than one user is a bulk import process. Just follow the same steps outlined in this guide. 

  1. Navigate to All Import > New Import.
  2. Choose how you want to load your data (i.e., upload a file, use a URL, etc.).
  3. Select New Items and choose Users as the import type.
  4. Use the Drag & Drop interface to map incoming data to your WordPress user fields.
  5. Run the import.

How Do I Import Customers From CSV to WooCommerce?

Importing customers with WP All Import is similar to importing regular WordPress users. The only difference is that you need to select WooCommerce Customers as the import type in the first step of the process. 

How Do I Export All Users to CSV in WordPress?

To export users from an existing WordPress website in CSV format, use the WP All Export plugin and follow these steps:

  1. Navigate to All Export › New Export and select Users as the export type.
  2. Use the Drag & Drop interface to add fields to your export file.
  3. Run the export.
  4. Download your export file.

How Do I Import Users From One WordPress to Another?

To migrate users from one WordPress site to another, you can use the combination of WP All Export and WP All Import. First, use WP All Export to export users from your source site. Then, use WP All Import to import these users to your destination site.

    Experience the Breakdance difference.
    Upgrade your WordPress editing experience with Breakdance, the visual builder for WordPress that's both easy-to-use and exceptionally powerful.
    • Unlimited Sites
    • 60-day Money Back Guarantee
    • Premium Support
    • Only $199.99/Year

    Experience the Breakdance difference.

    Unlimited license.
    Unlimited websites.

    Get maximum flexibility with unlimited licensing and domain activations.

    60-day money back guarantee.
    No questions asked.

    Get your money back within 60 days of purchase, no questions asked. It's risk-free!

    Premium support.
    Get all the help you need.

    We offer premium support to ensure the ultimate customer experience.

    Just $199.99/year for
    unlimited sites.

    For a limited time, we're offering an unlimited site license for just $199.99/year. Buy now to lock in this price.

    We ❤️ WordPress. Our plugin stack »
    © Soflyy. All rights reserved