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 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
- Make a CSV with at least an Email column. Add names, phone, company and address columns if you have them.
- Back up the site.
- Go to Import Export → Import, choose WooCommerce Customers and upload the file.
- Click Auto Map and check the mapping.
- Keep Check for Existing Items by Field: Email and If Match Found: Update, then start the import.
- 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:

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

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:

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

Step 4: Check the Customers
In Users, filter by the Customer role. The new accounts have the role Customer:

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:

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.
- Shopify: upload Shopify’s customer export as it is; it is recognized and converted. See Shopify to WooCommerce: Import Products via CSV.
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.
- 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.
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
- How to Export WooCommerce Customers to CSV
- How to Migrate WooCommerce Store Data to Another Site
- Shopify to WooCommerce: Import Products via CSV
- Export and Import WordPress Users with ACF Custom Fields
- How to Import WooCommerce Products from CSV or Excel
Get the free plugin on WordPress.org.

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