---
title: "How to Export WooCommerce Customers to CSV"
url: "https://wpimportexport.com/export-woocommerce-customers-csv/"
description: "Export WooCommerce customers to CSV or Excel with addresses, registration dates and totals. Filter by total spent, order count, country or date."
type: post
published: 2026-11-08T15:00:35+00:00
modified: 2026-11-14T10:41:26+00:00
categories: ["Export Guides", "Tutorials", "WooCommerce"]
tags: ["Import Export by RockStarLab", "WooCommerce", "WordPress export"]
docs_topics: ["WooCommerce"]
---

# How to Export WooCommerce Customers to CSV

Sooner or later every shop needs its customer list in a spreadsheet: for a newsletter tool, an accountant, a CRM, a “thank you” offer to the best customers or a move to another store. WooCommerce Analytics can download a basic customer report, but without phone numbers, street addresses, company names or shipping addresses, and without the filters below. You can export them to CSV or Excel with the columns you choose, filtered, for example, to customers who spent more than 100 or never ordered.

We tested it on a store with 9 customer accounts and 8 orders using [Import Export by RockStarLab](https://wordpress.org/plugins/import-export-by-rockstarlab/) 2.1.25 with the **PRO** add-on 2.1.5, WooCommerce 11.2 and WordPress 7.1. Exporting WooCommerce customers is a PRO feature.

## Short Answer

1. Go to **Import Export → Export** and choose **WooCommerce Customers**.
2. Add filters if you want part of the list, for example **Total Spent** greater or equal 100.
3. Drag the columns you need into **Export File Structure**: email, names, billing address, Date Created, Order Count, Total Spent.
4. Choose **CSV** or **XLSX** and download the file.

## Which Customers Are Exported

The export lists WordPress accounts with the **Customer** role, plus accounts with the **Subscriber** role, because a subscriber who logs in and buys keeps that role. On our store that made 11 accounts: 9 customers and 2 subscribers.

Guest orders are not accounts, so a guest buyer does not appear in a customer export. To get guest buyers’ names and emails, export orders instead and use the billing columns; see [How to Export All WooCommerce Orders into CSV or Excel](https://wpimportexport.com/how-to-export-all-woocommerce-orders-into-csv-or-excel/).

## Step 1: Choose WooCommerce Customers and the Columns

Open **Import Export → Export**, choose **WooCommerce Customers** and click **Next Step**. Skip the filters for a full list and click **Next Step** again. On **Select Fields**, drag the fields you want from **Available Fields** into **Export File Structure**, in the order you want the columns:

![Export Select Fields step for WooCommerce Customers: 12 columns in Export File Structure: Email, First Name, Last Name, Billing Company, Billing Phone, Billing Address 1, Billing City, Billing Postcode, Billing Country, Date Created, Order Count, Total Spent](https://wpimportexport.com/wp-content/uploads/2026/11/01-select-customer-fields-scaled.webp)

_Drag the customer, billing and shipping fields you need into the export._

The fields are grouped:

- **Customer:** Email, Username, First Name, Last Name, Display Name, Date Created (the registration date), Paying Customer, Order Count, Total Spent and Last Order ID, plus the account ID in four “reference” fields that are used when you move customers to another site.
- **Billing** and **Shipping:** name, company, phone, address lines, city, state, postcode and country. Billing also has its own email.
- **Meta:** Customer Meta JSON, the other fields stored with the account (for example data from other plugins), as one JSON column.

**Add all** next to a group adds every field in it. For a mailing list, Email, First Name, Last Name and Billing Country are usually enough.

## Step 2: Download the File

On the next step choose the format: **CSV** for most tools, or **XLSX** to open it in Excel without import settings. Click **Start Export**, then **Download Export File**. Our file:

![Exported customers CSV as a table: email, first and last name, billing company, phone, address, city, postcode, country code, date created, order count and total spent for 9 customers](https://wpimportexport.com/wp-content/uploads/2026/11/02-customers-csv-all-scaled.webp)

_The exported file: country codes, registration dates, order counts and paid totals._

- Column names are the field names (`billing_city`, `total_spent`). Rename them in the spreadsheet if your mailing tool expects other names.
- Countries are WooCommerce codes: HU, GB, DE, US. States are codes too (TX, ON).
- **Date Created** is when the account was registered. Customers imported from another system show the date that came with them, such as 2021-08-19 for Ben.
- **Order Count** counts the customer’s orders. **Total Spent** counts only paid orders (Processing and Completed). Carla has 1 order on hold and Elena 1 cancelled order, so both have Order Count 1 and Total Spent 0.00.

## Filter: Customers Who Spent 100 or More

On **Filter Data**, click **Add Filter**, choose **Total Spent**, **Greater or Equal** and type 100. The counter shows how many customers match before you export:

![Export Filter Data step: filter Total Spent, Greater or Equal, 100; total items available 1](https://wpimportexport.com/wp-content/uploads/2026/11/03-filter-total-spent-100.webp)

_Total Spent greater or equal 100: one customer matches._

One customer matched: Anna, with 236.00 from two orders. Order Count and Total Spent compare as numbers, so 54 is less than 100 even though “54” sorts after “100” as text.

More filters you can combine:

- **Date Created** greater than a date: accounts registered after that day, for example everyone who signed up in the last quarter.
- **Billing Country** in `DE, AT, CH`: customers in German-speaking countries. Not in excludes them.
- **Billing Phone** is empty: accounts to ask for a phone number.
- **Email** contains `@yourcompany.com`, or does not contain it to leave your own test accounts out.

All filters must match, so two filters narrow the list down.

## Filter: Customers Without Orders

**Order Count** less than 1 lists accounts that never ordered: people who registered and left, or customers you imported before the shop opened. That is a list for a first-order discount:

![Exported CSV of customers with Order Count less than 1: Laura Fischer DE, Daniel Okafor US, Sophie Martin FR, Chloe Nguyen CA with order_count 0](https://wpimportexport.com/wp-content/uploads/2026/11/04-customers-without-orders.webp)

_Accounts that never placed an order._

Carla and Elena are not on this list: they have an order, even though it was never paid. To find customers like them, combine **Order Count** greater or equal 1 with **Total Spent** less than 0.01; on our store that returned exactly Carla and Elena.

## Before You Send the File Anywhere

A customer list is personal data. Export only the columns the receiving tool needs, keep the file out of shared folders and email, and delete it when the import on the other side is done. If you upload it to a mailing tool, export only customers who agreed to receive emails; WooCommerce does not store newsletter consent unless a plugin adds it, and in that case it is usually in the Meta group.

## Moving Customers to Another Store

For a move to another WooCommerce store, add the Billing and Shipping groups and Date Created to the export. On the other store, import the file as **WooCommerce Customers**: the column names match the import fields, customers are matched by email, and the registration date is kept. Step by step: [How to Import WooCommerce Customers from CSV](https://wpimportexport.com/import-woocommerce-customers-csv/). For orders, products and customers together, see [How to Migrate WooCommerce Store Data to Another Site](https://wpimportexport.com/how-to-migrate-woocommerce-store-data-to-another-site/).

## FAQ

### Does the export include passwords?

No. Passwords are not exported, and Customer Meta JSON leaves out login sessions, roles and other private account data.

### Can I export guest customers?

Not as customers, because they have no account. Their names and emails are in the order export.

### Why does Total Spent differ from WooCommerce Analytics?

Total Spent counts paid orders of the account. Analytics can use other date ranges and order statuses, and it also includes guest orders, so the numbers do not always match.

### Do I need PRO?

Yes, WooCommerce customers are a PRO export.

## Related Guides

- [How to Import WooCommerce Customers from CSV](https://wpimportexport.com/import-woocommerce-customers-csv/)
- [How to Export All WooCommerce Orders into CSV or Excel](https://wpimportexport.com/how-to-export-all-woocommerce-orders-into-csv-or-excel/)
- [How to Migrate WooCommerce Store Data to Another Site](https://wpimportexport.com/how-to-migrate-woocommerce-store-data-to-another-site/)
- [WordPress Export Data Filters: Examples and How to Use Them](https://wpimportexport.com/wordpress-export-data-filters-examples-how-to-use-them-effectively/)

Get the free plugin on [WordPress.org](https://wordpress.org/plugins/import-export-by-rockstarlab/).
