How To Export WooCommerce Customers to CSV, Excel, or XML

To export your WooCommerce customers, go to WP All Export › New Export in the main WordPress menu and select WooCommerce Customers. Configure your export using our Drag & Drop interface, then run the export and download your data.

WordPress Users vs WooCommerce Customers

A WooCommerce customer is a specific type of WordPress user.

When someone visits your WooCommerce site and creates a purchase, WooCommerce creates a user account for them. This user account is assigned the role customer with a set of WooCommerce-specific data attached to their account.

Step 1: Create a New Export for WooCommerce Customers

Navigate to All Export › New Export:

Export WooCommerce Customers New Export
  1. Select Specific Post Type.
  2. Choose WooCommerce Customers.
  3. Click the blue Customize Export File button at the bottom. This will call up the Drag & Drop interface.

Step 2: Configure Your WooCommerce Customer Export Columns

When exporting WooCommerce customers, most users only need a subset of the available data fields. You can select this subset in the Drag & Drop interface.

All the available data tables and fields are accessible in the Available Data panel on the right.

To export a data field, simply drag it from Available Data to the column selection area as shown below:

Export WooCommerce Customers Drag and Drop

To delete an export column, simply drag it from the column selection area to another part of the interface.

WooCommerce Customer Tables and Fields

There are four default data tables in the Available Data panel for WooCommerce customer exports: Standard, Address, Custom Fields, and Other. The address fields are actually custom fields but WP All Export creates a special listing to make them more accessible.

Standard Fields

All basic export fields tied to your WooCommerce customers are in Available Data › Standard. These fields come from the WordPress Users table but are limited users who have been assigned a customer role:

  • ID: Customer ID, which is actually the user ID assigned by WordPress
  • Username: The username the user chose when creating their account
  • User Email: Email address associated with the customer account
  • First Name: Customer's first name
  • Last Name: Customer's last name
  • User Registered: Date when the customer registered
  • User Nicename: Sanitized version of the username
  • User URL: Website associated with the customer account
  • Display Name: The name to be displayed publicly, which is selected in WordPress as either the username, first/last, or nickname
  • Nickname: A name chosen by the user to be displayed on the frontend
  • Description: A description of the user, also labeled as Biographical Info in WordPress
Export WooCommerce Customers Standard Fields

WooCommerce Customer Address Fields

Address fields tied to your WooCommerce customers are found in Available Data › Address. WooCommerce adds these address fields and stores them in WordPress as custom user metadata.

Every customer in WooCommerce has a billing address and a shipping address. WooCommerce organizes both sets of addresses the same way:

  • First Name
  • Last Name
  • Company
  • Address 1
  • Address 2
  • City
  • Postcode
  • Country
  • State
  • Email
  • Phone
Export WooCommerce Customers Address Fields

Custom Fields

Custom fields added to your WooCommerce Customers are in Available Data › Custom Fields. These contain extra information (or metadata) added by your plugins or themes. WP All Export automatically detects these.

For example, WooCommerce adds an "_order_count" custom field which keeps track of how many orders a customer has made.

Export WooCommerce Customers Custom Fields

Other Fields

Other, less-used export fields tied to your WooCommerce customers are in Available Data › Other.

Export WooCommerce Customers Other Fields

Exporting WooCommerce Customer Passwords

To include a WooCommerce customer password in the export, add the User Pass field.

This field does not include the actual customer password but instead a hash code of that password, which is basically a scrambled/coded version of the original text that cannot be interpreted by humans. The hashing process cannot be reversed. But when you import a hashed password back into WordPress, the associated customer will still be able to use their old password.

Step 3: Download Your WooCommerce Customer Export

Once you've finished setting up your export, click Continue and verify the export settings. Then click Confirm & Run Export to run the export.

Once the export is complete, click CSV to download your exported customers:

Confirm and Run Interface

You can also click Bundle, which downloads a zip file containing an import template along with the export file. You can use this template to migrate customers from one WooCommerce store to another, as it contains everything that WP All Export needs to know to import the exported customers.

Export WooCommerce Customers Advanced Topics

Exporting Customers to Excel or XML

In addition to CSV exports, WP All Export can also export users to Excel or XML.

To use Excel, open the Drag & Drop interface and...

Export WooCommerce Customers to Excel
  1. Expand the Export Type section.
  2. Select Spreadsheet.
  3. Choose Excel File XLS or Excel File XLSX.

Exporting to XML is just as simple:

Export WooCommerce Customers to XML
  1. Expand Export Type.
  2. Select Feed.
  3. Choose Simple XML Feed or Custom XML Feed.

For more information on custom XML exports, see https://www.wpallimport.com/documentation/export-wordpress-data-to-custom-xml-feed/.

Export WooCommerce Customers Advanced Options

For CSV or XML exports, an Advanced Options section will appear just above the Export Type section. Here are the options for CSV files:

Export WooCommerce Customers Advanced Options CSV

The Separator field defines the character that will be used to separate columns. This is a comma (,) by default, but you can change it to any character that you want. Just be careful that you don't use a separator that is present inside the export data itself.

The Include header row and column titles in export option determines whether the first row contains just regular data or a header row consisting of the column names.

For more information on XML options, see exporting WordPress data to XML.

How to Filter WooCommerce Customer Exports

Sometimes, you only need to export a subset of all your customers.

To do this, expand the Add Filtering Options section in the lower half of the New Export screen. Every filter rule requires three components: an Element, a Rule, and a Value:

Adding Filter Rules

This particular filter rule is designed to export only customers with a billing address in the city of Memphis.

Once you click the Add Rule button, you will see that only three customers will be exported:

Single Filter Rule

You can also combine filter rules. For example, if we add a rule to also include customers from the city of Phoenix, the number of customers to be exported rises to six:

Combination Filter Rule

Note the importance of selecting the "OR" join option for this combination filter. If we had left the default "AND" option in place, our combination filter wouldn't have returned any WooCommece customers because no customer lives in both Memphis and Phoenix.

Frequently Asked Questions

How Do I Import WooCommerce Customers?

  1. Go to All Import -> New Import.
  2. Choose the method for loading your data (i.e. upload file, use a URL, etc.).
  3. Select the file you want to import and the import target (i.e. WooCommerce Customers).
  4. Drag and drop the incoming data elements to their target WooCommerce Customer fields.
  5. Complete the import.

For more information, see Import WooCommerce Customers.

How Do I Migrate WooCommerce Customers to Another Website?

  1. Export the customers that you wish to migrate, but instead of downloading a CSV file, use the bundle option. This option will export an import template along with your export data file.
  2. Using WP All Import, import the bundle file on the target site. All you need to do after that is accept the default settings, as the bundle file contains everything that WP All Import needs to know to complete the import.

For more information, see Migration Overview.

How Do I Schedule WooCommerce Customer Exports?

To learn about the different methods of scheduling WooCommerce Customer Exports, see How to Schedule WordPress Exports.



Export WordPress users in different file formats using WP All Export.

Use WP All Export to export WooCommerce orders to CSV, Excel, or XML.

Export WooCommerce products to CSV, Excel, XML, or the Google Merchant Center.

Export WooCommerce reviews using WP All Export.

Lifetime support. Lifetime updates. Pay once.

Packages
Standalone
Import
Pro Package
$249
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Pro Package
$299
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
WooCommerce Import Package
$149
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import Standalone
$99
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Standalone
$169
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Export Standalone
$99
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
cross