Import WooCommerce Customers from an XLS File

If you have all your WooCommerce Customer details in an XLS file and you want to import the data from the XLS file to your WooCommerce store, WordPress Users and WooCommerce Customers Import Export Plugin will help you do that quickly and easily.

To import the WooCommerce customers in the XLS file using the plugin, you need to first change the XLS file into a CSV file. This can be done by saving the XLS file with the .csv file extension. Also, CSV file should also be UTF-8 encoded for proper import. Refer to this article on how to save an XLS or XLSX file to a CSV file.

After you have saved your XLS file as a CSV file, you can now use the plugin to easily import the customer data into the WooCommerce website. What you need to do is purchase the plugins, install and activate it on the website to which the data is being imported.

Let’s take a look at how we can import the WooCommerce customers into the WooCommerce website using the plugin.

Importing WooCommerce Customers

To begin importing using WordPress Users & WooCommerce Customers Import Export Plugin, go to your WooCommerce dashboard. From the dashboard, go to WooCommerce > Customer Import Export. This will take you to the plugin page.

From the plugin page, go to the Import Users in CSV Format section.

Import Window

From this section, if you wish to update the existing users in the store using the CSV file, check the Update User if exists checkbox. This will take you to the Merge Users page of the plugin.

Merge Users

If you leave the checkbox unchecked and click on the Import Users button, it will take you to the Import page. The next step in both cases is to upload the CSV file to the plugin. Now, based on the location where the file is saved, there are two methods with which you can import the customers to the website.

Method 1: Select a file from your computer.

In this method, you can click on the Choose File button and select the CSV file saved locally on your computer.

Method 2: Provide FTP Details

This method can be used if the CSV file you are importing is located on a remote server. You can upload the file from the server by giving the FTP details of the server.

After you have selected the CSV file with any of these methods, next click on Upload file and import. This will take you to the next step in import, mapping fields.

Mapping of Fields

The mapping fields are necessary for the proper import of the customer data into the WooCommerce website. This is to ensure that the column headers of the CSV file are in sync with the WooCommerce customer data fields. The mapping should be properly done if the data that are being imported are exported from some other e-commerce platform. After the mapping, click Submit which will import all the data in the CSV file to the website.

If you need more information on how to get started with the plugin to import or export WooCommerce data, then read this article.

Leave a Reply