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 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
- Go to Import Export → Export and choose WooCommerce Customers.
- Add filters if you want part of the list, for example Total Spent greater or equal 100.
- Drag the columns you need into Export File Structure: email, names, billing address, Date Created, Order Count, Total Spent.
- 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.
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:

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:

- 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:

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:

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. For orders, products and customers together, see 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
- How to Export All WooCommerce Orders into CSV or Excel
- How to Migrate WooCommerce Store Data to Another Site
- WordPress Export Data Filters: Examples and How to Use Them
Get the free plugin on WordPress.org.

Comments 0
Have a question or a tip to share? Leave it below.