How to Export WooCommerce Customers to CSV, XML & Excel

Export WooCommerce customers to CSV for backups, migration, marketing, or reporting. Learn how to use the native WooCommerce export option and WebToffee’s plugin for advanced fields, filters, guest customers, and formats.

Exporting WooCommerce customers helps you manage customer records, back up store data, migrate users to another website, or prepare customer lists for marketing and reporting.

WooCommerce gives store owners a basic way to download customer data as a CSV file. However, if you need more control over fields, filters, guest customers, custom user meta, or file formats like Excel and XML, you may need a dedicated customer export plugin.

In this guide, we’ll show you how to export WooCommerce customers using the native WooCommerce customer export option and the WebToffee WooCommerce customer export plugin for advanced exports. By the end, you’ll know which method works best for your store and what customer data you can export.

Before getting into the methods, it’s worth noting the range of reasons store owners export customer data, because the right method depends on your use case:

• Site migration: Moving to a new host, domain, or WordPress installation, and need to bring customers across
• CRM integration: Importing customers into Mailchimp, Klaviyo, HubSpot, or another marketing platform
• Email marketing: Building a segmented list of customers who purchased in a specific date range or spent above a threshold
• GDPR / data subject requests: A customer requests a copy of their personal data — you’re legally required to provide it
• Backup: Keeping an offline copy of your customer records independent of your database backup
• Analysis: Pulling customer data into Excel or Google Sheets for reporting on lifetime value, order frequency, or geography

Before exporting, it’s important to know what data you can expect in the file. The exact fields depend on the method you use.

Field	Native Export	Plugin Export
Name (first, last)	✅	✅
Email address	✅	✅
Billing address	✅	✅
Shipping address	✅	✅
Phone number	✅	✅
Total orders	✅	✅
Total spend	✅	✅
Average order value	✅	✅
Registration date	✅	✅
User role	❌	✅
Custom meta fields	❌	✅
Guest customer data	❌	✅
Hidden meta (plugin data)	❌	✅
Export format choice	CSV only	CSV, TSV, XML, XLS, XLSX
Scheduled/automated export	❌	✅

For simple customer email exports, the native option may work. For store migration, CRM imports, customer segmentation, or custom user data, the premium plugin is usually the better option.

Method 1: Native WooCommerce Customer Export (No Plugin Required)

WooCommerce includes a built-in customer export tool that most store owners don’t know exists. It’s found directly in the Customers screen, not under Tools, and produces a CSV file you can open in Excel or import into most CRMs.

Step 1: Go to WooCommerce > Customers

From your WordPress dashboard, navigate to WooCommerce > Customers. You’ll see a table listing all registered customers with columns for name, email, location, orders, total spend, and more.

Step 2: Apply Filters (Optional)

Use the Advanced filters option in the Show dropdown to narrow your export by:

• Country or region
• Date registered
• Number of orders
• Total spend (above or below a threshold)
• Email address

You can also sort the list by clicking any column header before exporting.

Step 3: Download the CSV

Once your filters are set, click the Download button at the top right of the Customers screen. WooCommerce exports the filtered customer list as a CSV file directly to your computer.

That’s it — no configuration needed for a basic export of your registered customer list.

What the CSV includes: Username, first name, last name, email, country, postcode, number of orders, total spend, average order value, and date of last order.

Method 2: Export WooCommerce Customers Using WebToffee Plugin

We will be using the premium version of the WooCommerce Customers Import Export plugin.

After purchasing, you will receive an email to download the plugin zip file. You can also download the plugin file from the My Account page.

Step 1: Install WooCommerce Customers Import Export Plugin

Once you have downloaded the plugin file,

• Go to Plugins > Add New from your WordPress dashboard.
• Click on Upload Plugin and then upload the plugin zip file.
• Then, Install and Activate the plugin.

Step 2: Select User/Customer as Post Type to Export

After installing the plugin,

• Go to WebToffee Import/Export(Pro) > Export.
• Choose the post type as Users/Customers.
• Proceed to the next step.

Step 3: Select an Export Method

There are three different options to choose from to continue with your export:

• Quick export
• Pre-saved template
• Advanced export

Quick Export

The Quick Export option allows you to export the basic/standard fields of customer data with just a single click.

If you select this option, you can either

• Directly export customers by clicking on Export.
• Click the Filter data button to proceed to the next step of the export process.
• To include fields from Meta(custom fields) and Hidden meta select the respective group’s checkboxes.

You can skip to Step 5 of this article to learn more about Advanced options/Batch export/ Scheduling options.

Advanced Export

This option will take you through a detailed process of filtering, column selection, and advanced options that may be required for your export.

Step 3: Filter Customer Data for Export

Here, you can set up filters to include only the customers you want in your export file using the criteria below.

• Click on Step 4 to proceed further.

• Click on Step 4 to proceed further.

Step 4: Map and Reorder Customer Export Columns

Here, you can map and reorder the export columns under the following three fields:

• Default fields: The column names appearing in this section can be edited if required. The preferred names and last saved choices can be viewed when choosing a pre-saved template. One can also move the columns to reorder the arrangement.
• Meta(custom fields): Includes additional user data added by plugins or custom code, allowing flexible data export.
• Hidden meta: Contains system or plugin-generated data not normally visible in the dashboard. Include these only if required for migration or integration.

Step 5: Configure Advanced Export Options

This is the final step for exporting users. Here, you have many options to configure the customer export data.

• Export guest users: Enable or disable whether you want to export data related to guest customers.
• Export file format: Choose an export format – CSV, TSV, XML, XLS, or XLSX.
• Delimiter: Set a separator to differentiate the columns in the CSV file. By default, it assumes ‘,’.
• Export file name: Specify the filename of the exported file. If left blank, the system generates a default name.
• Export location: Choose Local, FTP/SFTP, or E-mail. If you opt for FTP/SFTP, choose an FTP profile, specify the export path, or use the default path.

• Save the template file for future exports, if needed.
• Click on Export to finish.

This will then export all of your WooCommerce customers into the selected export file.

Exporting customer data in WooCommerce makes it easier to manage records, back up data, and migrate to different platforms, ensuring your customer information remains accessible and secure.

Using the right tools, such as the WooCommerce Customer Export plugin we covered above, can make this process quick and efficient. We hope this guide assists you in exporting your customer data without any issues.

If you have any questions or feedback, please comment below, and we will be happy to assist you!