How to Import WordPress Users from a CSV File

The Best WordPress User/ WooCommerce Customer Import Export Plugin

10,000+ Active Installs as per WordPress Official Plugin Repository

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

While migrating to a new WordPress website, the absolute important thing that you need in your website are the users. If you have to include all the users in your new website or you have to update the WordPress users information in bulk, doing them one-by-one is a complete waste of time. When you want to include the hundreds and thousands of users, you need an easy way to import all the users into the website.

The WordPress User & WooCommerce Customers Import Export Plugin is the best way you can import the WordPress users to your WordPress website. With this plugin, you can take a CSV file that includes all the WordPress users and user data, and import the users to the website with such ease, that it will save you a lot of time and effort.

During the import, you also have the option to map the column headers of the CSV file with the WordPress or WooCommerce user data fields. This ensures that no matter which platform you are migrating from, the users and their data will be transferred to the new website perfectly.

The plugin takes a CSV file as input. So, to import the users, you must first prepare a CSV file with all the user information. You can prepare a CSV file using a spreadsheet program like Google Sheets, Microsoft Excel, etc. Also, the CSV Import file must be in UTF-8 format. For more information about UTF-8 encoding, read How to save CSV / Excel File as UTF-8 Encoded?

Or you can use the same plugin to export the user data into a CSV file. With this plugin, you can export users based on their user roles, date ranges, etc.

This plugin helps you to import users from CSV files that are saved in different locations. You can upload the CSV file from your local computer or from a remote server by providing the FTP details.

Now let’s take a look at how you can import the users to the website using the plugin.

Import Users/Customers

If you have the users CSV file ready on your computer or on a remote server, you can follow the steps to import the user using WordPress Users & WooCommerce Customers Import Export plugin.

On the WordPress website dashboard, go to WooCommerce > Customer Import Export. It will take you to the plugin page. from the plugin page, go to the User/Customer Import tab.

User/Customer import tab

You can import all the required users by clicking on Import Users. Click Import Users, the window appears as shown below:Import window

Method 1: Select a file from your computer. Click Choose File to browse a required CSV file from your computer.

You get the mapping file option(s) for auto-mapping only if you save the mapped fields with a user-defined file name while mapping the fields. Select the required mapping file from the Select a mapping file drop-down list as shown below:

Select a mapping file

Method 2: Provide FTP Details. If your CSV file is on the server, then to import it,  you need to do FTP settings as given below:
  1. Select the checkbox to enable FTP import/export.
  2. Enter FTP Server Host/IP.
  3. Enter FTP User Name.
  4. Enter FTP Password.
  5. Enter FTP Server Path.
  6. Select the checkbox to use FTPS.

Next, you have the options to enter the delimiter which separates the mapping values. and the plugin also allows you to send emails to new users. Select the checkbox in the Send Email to New Users filed to send an Email to a new user on importing details.

After this, the next step is to click the Upload file and Import. It will take you to the Map Fields page. The import window appears as shown below:

User import map fields

The mapping of fields is important for a proper and error-free user import.

You can map the fields(WordPress/Woocommerce fields) with column headings ( CSV file header). Map a particular field of Map to a column by using Column header  drop-down list as shown below:User import map column header

Select a required option from the drop-down list. For example, here, user ID is mapped to ID.

Note: Mapping is very helpful if you are importing CSV from some other e-Commerce platform like Magento or Shopify.

The Evaluation Fields column in the mapping fields is used to fix/update the required value for the particular field. Using this field you can update the value of hundreds of users in bulk during import.

After all the required fields have been filled, click Submit. This will start importing the users in the CSV file to the website. During the import, you will see a window as shown:

User import completed

You can see the imported user on the Users Page as shown below:

Imported user on WordPress Users page

Conclusion

Following these simple steps can easily help you import the WordPress users into the website in a matter of minutes. For more information and to know what more the plugin can do, visit the product page.

The Best WordPress User/ WooCommerce Customer Import Export Plugin

10,000+ Active Installs as per WordPress Official Plugin Repository

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

Leave a Reply

Your email address will not be published. Required fields are marked *