Importing WordPress Users from an Excel 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 your WordPress website, or when you are adding more information to your WordPress website, you need to import data to your website. If you wish to import users to your WordPress site, and you have all your data in an Excel file, the plugin WordPress Users & WooCommerce Customers Import Export Plugin has got your back.

With this plugin, exporting the user data in an Excel file is really easy. All you need to do is save your Excel file with the .csv extension, that’s as simple as clicking Save As and selecting Comma Separated Values from the file type drop-down list.

This will save all the data in the Excel file in a CSV file format. The plugin takes the CSV file as input to import the data into the WordPress website.

Following are the steps to import users using WordPress Users & WooCommerce Customers Import Export Plugin.

Import WordPress Users

From the WooCommerce website admin dashboard, go to WooCommerce > User Import Export. From the plugin page, go to the Import Files in a CSV Format section under User/Customer Import tab and click Import Users. 

This will take you to the Import page of the plugin.

Import window

Now, there are two methods depending on the location of your CSV by which you can import the WordPress users.

Note: Before you import the users, make sure that the CSV Import file is in UTF-8 format. For more information about UTF-8 encoding, read How to save CSV / Excel File as UTF-8 Encoded?

Method 1: Select a file from your computer

In this method, you can select a file from your local computer. Click Choose File to browse a required CSV file from your computer.

Method 2: Provide FTP Details

In this method, you can select a CSV file that is located on a remote server by providing the FTP details.
First, you have to check the box to enable FTP and then give the FTP details. You also have the option to use FTPS.

After choosing any of the two methods, enter the delimiter that is used in the CSV file and select whether you want to send email to new users or not. Then, click on Upload file and import.

Now, we are half way there in importing all the users. Next, the important half is the mapping fields.User import map fields

To make sure that the right data is imported into the right user fields, you have to map the column headers of the CSV to match the WooCommerce user data fields. This is especially useful when you are migrating from a different platform like Magento, Shopify etc.

Then in the final step, click Import. Now all the users in the CSV file will be imported to the WooCommerce store.Import completed successflly

The imported users will be reflected on the WordPress Users page.

Imported users on the WordPress Users page

Update Existing Users

The plugin also helps you to update the existing users. This way, if you want to update a lot of users in the WooCommerce store in bulk. The user data can be easily be changed using a CSV in bulk and the next thing you need to do is reflect the changes on the website.

For this, you just have to check a little box before clicking Import Users on the plugin page. Check the Update User if exists checkbox and continue with the import.

Update users while importing

This way you can update the existing users in the WooCommerce store with the information in the CSV.

Exporting WordPress users from an Excel file is really task with WooCommerce with WordPress Users and WooCommerce Customers Import Export Plugin. For more details on setting up the plugin to your WordPress website, read the documentation.

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 *