---
title: "How to Import WooCommerce Customers from CSV"
url: "https://wpimportexport.com/import-woocommerce-customers-csv/"
description: "Import WooCommerce customers from a CSV with billing addresses, country and state codes and registration dates. Update existing customers by email."
type: post
published: 2026-11-08T15:00:31+00:00
modified: 2026-11-14T10:41:23+00:00
categories: ["Import Guides", "Tutorials", "WooCommerce"]
tags: ["CSV import", "Import Export by RockStarLab", "WooCommerce", "WordPress import"]
docs_topics: ["WooCommerce"]
---

# How to Import WooCommerce Customers from CSV

You have a list of customers in a spreadsheet: exported from a CRM, an old shop, a mailing tool or typed in by hand. To see them in WooCommerce with their addresses, so checkout is filled in and orders can be assigned to them, each one needs a WordPress account with the customer role and WooCommerce billing and shipping fields. Below: importing customers from a CSV file, updating the ones that already exist, and avoiding the usual problems with country names, passwords and welcome emails.

We tested it with a 5-customer CSV 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. Importing WooCommerce customers is a PRO feature.

## Short Answer

1. Make a CSV with at least an **Email** column. Add names, phone, company and address columns if you have them.
2. Back up the site.
3. Go to **Import Export → Import**, choose **WooCommerce Customers** and upload the file.
4. Click **Auto Map** and check the mapping.
5. Keep **Check for Existing Items by Field: Email** and **If Match Found: Update**, then start the import.
6. Send password reset links from **Users** when you are ready to tell customers about their accounts.

## The CSV File

Our file came from a CRM. It has the usual columns, with country and state written out as names, and a “Customer Since” date:

![customers.csv with 5 customers: First Name, Last Name, Email, Phone, Company, Address, Address 2, City, State, Postcode, Country, Newsletter, Customer Since; countries written as Germany, United States, France, United Kingdom, Canada](https://wpimportexport.com/wp-content/uploads/2026/11/01-customers-csv-scaled.webp)

_A customer list from a CRM, with country and state names instead of codes._

What the columns can contain:

- **Email** is required. It identifies the customer, so a second import with the same email updates the account instead of creating a new one.
- **First Name, Last Name, Company, Phone** go to the customer’s name and billing details.
- **Address, Address 2, City, State, Postcode, Country** become the billing address. If your file has a separate delivery address, map those columns to the shipping fields.
- **Country** can be a name (“Germany”, “United States”, “UK”) or a code (“DE”, “US”). **State** can be a name (“Texas”, “Ontario”) or a code (“TX”, “ON”). The import stores the codes WooCommerce uses.
- **Customer Since** (or Registered, Date Registered) becomes the account’s registration date.
- **Username** is optional. Without it, the part of the email before the @ is used, with a suffix if that name is taken.

Columns that WooCommerce has no field for, such as our “Newsletter” column, can stay in the file; leave them unmapped and they are ignored.

## Step 1: Back Up the Site

The import creates and changes user accounts. Make a backup first: UpdraftPlus **Backup Now**, your host’s backup, or ask an AI agent to run `rsl-ie/updraftplus-backup-start`. See [How to Create a WordPress Website Backup and Restore It](https://wpimportexport.com/how-to-create-a-wordpress-website-backup-and-restore-it/).

## Step 2: Upload and Map the Columns

Open **Import Export → Import**, choose **WooCommerce Customers**, upload the CSV and go to **Field Mapping**. Click **Auto Map**. In our file, 12 of 13 columns were matched: Email, names, Phone, Company, the address columns and Customer Since. Only Newsletter was left out:

![Field Mapping after Auto Map: 12 of 13 fields mapped; Email to email, Phone to billing_phone, Company to billing_company, Address to billing_address_1, Address 2 to billing_address_2, City to billing_city, State to billing_state, Postcode to billing_postcode](https://wpimportexport.com/wp-content/uploads/2026/11/02-auto-map-customer-columns.webp)

_Auto Map matches the usual customer columns to the WooCommerce billing fields._

Check two things before you go on: **Email** is mapped to `email`, and the address columns went to `billing_*` (or `shipping_*` if that is what your file holds). You can drag any column to another field by hand.

## Step 3: Match by Email and Import

On **Import Options**, keep **Email** in **Check for Existing Items by Field**:

![Import Options: Check for Existing Items by Field set to Email (required, matches existing customers), If Match Found Update, If No Match Found Create](https://wpimportexport.com/wp-content/uploads/2026/11/03-import-options-email.webp)

_Customers are matched by email._

- **If Match Found: Update** changes the existing account: names, addresses and phone. **Skip** leaves existing customers as they are. WordPress allows only one account per email, so **Create** also updates.
- **If No Match Found: Create** adds new customers. Choose **Skip** if the file should only update customers you already have.

Start the import. Four customers were created and one was updated: Ben Turner already had an account with the same email, so he got the new address and phone instead of a second account.

![Import Completed Successfully: 5 successful, 1 updated, 4 created, 0 skipped, 0 failed](https://wpimportexport.com/wp-content/uploads/2026/11/04-import-result-4-created-1-updated.webp)

_Four new customers and one existing customer updated._

## Step 4: Check the Customers

In **Users**, filter by the **Customer** role. The new accounts have the role Customer:

![WordPress Users list: ben.t, chloe.nguyen, daniel.okafor, laura.fischer and sophie.martin with the role Customer](https://wpimportexport.com/wp-content/uploads/2026/11/05-imported-customers.webp)

_The imported customers in Users._

Open a customer and scroll to **Customer billing address**. The file said “United States” and “Texas”; WooCommerce has US and TX, so the country and the state show in their drop-downs, and checkout, shipping zones and taxes recognize the address:

![Customer billing address of Daniel Okafor: Okafor Design, 410 Congress Ave, Suite 300, Austin, 78701, Country United States (US), State Texas](https://wpimportexport.com/wp-content/uploads/2026/11/06-billing-address-us-texas.webp)

_"United States" and "Texas" from the file are stored as US and TX, so the drop-downs show them._

The other rows worked the same way: Germany became DE, France FR, United Kingdom GB, Canada CA and Ontario ON. A value WooCommerce does not know is saved as it is, so check customers from unusual countries or regions. The “Customer Since” dates became registration dates, for example 30 January 2024 for Daniel.

An existing user keeps their role. If an email in the file belongs to an administrator or a shop manager, that person is not turned into a customer.

## Passwords and Welcome Emails

The import gives every new account a random password and sends no emails. That is on purpose: you decide when customers hear about their new accounts.

When the shop is ready, go to **Users**, filter by **Customer**, select the customers and choose **Send password reset** from **Bulk actions**. Each customer gets a link to set a password. Customers can also use **Lost your password?** on the My Account page at any time. Passwords from another system cannot be moved with a CSV, because they are stored encrypted.

## Customers from Another Store

- **Another WooCommerce store:** export customers there with **Import Export → Export → WooCommerce Customers** (with Date created, billing and shipping fields) and import that file here, matched by email. For a whole store, see [How to Migrate WooCommerce Store Data to Another Site](https://wpimportexport.com/how-to-migrate-woocommerce-store-data-to-another-site/).
- **Shopify:** upload Shopify’s customer export as it is; it is recognized and converted. See [Shopify to WooCommerce: Import Products via CSV](https://wpimportexport.com/shopify-to-woocommerce-import-products-csv/#customers).

## Common Mistakes

- **Rows without an email.** They fail with “A valid customer email is required”. Add the email or create those customers by hand.
- **The same email twice in the file.** The second row updates the account created by the first. Remove duplicates before importing if the rows differ.
- **Opening the CSV in Excel and saving it again.** Postcodes with leading zeros (01234) and phone numbers starting with + can change. Format those columns as text or edit the file in a text editor. Accented names need the file saved as CSV UTF-8; see [CSV Import Shows Broken Characters](https://wpimportexport.com/csv-import-broken-characters-utf8-excel-accents/).
- **Billing columns mapped to shipping or the other way round.** Check the mapping list; WooCommerce uses the billing address for invoices and taxes.
- **Sending a password reset to everyone on day one.** Do it after the shop is live, or customers will log in to an empty store.

## FAQ

### Can I import order history with the customers?

Not with the customer import. Total spent and order count are calculated by WooCommerce from the orders that belong to the customer. Orders are a separate import; see [How to Import WooCommerce Orders from CSV](https://wpimportexport.com/import-woocommerce-orders-csv/).

### Does it work without WooCommerce billing fields, just names and emails?

Yes. Only Email is required. You can add addresses later with another import, matched by email.

### Can I import into a different role, such as wholesale customer?

New accounts get the Customer role. Existing users keep their roles. To move customers to another role afterwards, use **Users → Change role to**.

### Do I need PRO?

Yes, WooCommerce customers are imported with the PRO add-on.

## Related Guides

- [How to Import WooCommerce Orders from CSV](https://wpimportexport.com/import-woocommerce-orders-csv/)
- [How to Export WooCommerce Customers to CSV](https://wpimportexport.com/export-woocommerce-customers-csv/)
- [How to Migrate WooCommerce Store Data to Another Site](https://wpimportexport.com/how-to-migrate-woocommerce-store-data-to-another-site/)
- [Shopify to WooCommerce: Import Products via CSV](https://wpimportexport.com/shopify-to-woocommerce-import-products-csv/)
- [Export and Import WordPress Users with ACF Custom Fields](https://wpimportexport.com/export-import-wordpress-users-acf-custom-fields/)
- [How to Import WooCommerce Products from CSV or Excel](https://wpimportexport.com/how-to-import-woocommerce-products-from-csv-or-excel/)

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