Export reference

WooCommerce CSV export: every column, and where it goes

WooCommerce is the ecommerce plugin for WordPress. Its export has 15 columns, and 5 ready-made templates map it into 5 CRMs.

By Operelio teamUpdated September 26, 2026

Get started free See every column

WooCommerce import templates, by CRM

How to export from WooCommerce

From WooCommerce's own help pages, checked September 2026. Menu names can move, so the linked guide is the one to trust if they differ.

WooCommerce

Export WooCommerce customers

Install WooCommerce's Customer / Order / Coupon Export extension.
Go to WooCommerce, then Export.
Choose to export customers in CSV format.
Run the export and download the file.

Core WooCommerce's only customer download is the Customers report under Analytics, which uses different column names. This template reads the column names WooCommerce's Customer / Order / Coupon Export extension writes, such as first_name and billing_phone.

File: CSV

Every column in a WooCommerce export, and where it goes

For each column, the field it fills and the CRMs that field is in. Each CRM name opens its template. Columns no template uses are listed after the table.

WooCommerce export columns, the CRM field each one fills and the CRMs with that field
Column	FieldCRMs
first_name	First Name: HubSpot, Salesforce Leads, Zoho Contacts, Freshsales Name: Pipedrive
last_name	Last Name: HubSpot, Salesforce Leads, Zoho Contacts, Freshsales Name: Pipedrive
email	Email: HubSpot, Salesforce Leads, Pipedrive, Zoho Contacts, Freshsales
billing_phone	Phone: Salesforce Leads, Pipedrive Phone Number: HubSpot Mobile: Zoho Contacts Mobile Number: Freshsales
billing_company	Company Name: HubSpot, Freshsales Company: Salesforce Leads Organization: Pipedrive Account Name: Zoho Contacts
billing_address_1	Street Address: HubSpot Street: Salesforce Leads Mailing Street: Zoho Contacts Address: Freshsales
billing_city	City: HubSpot, Salesforce Leads, Freshsales Mailing City: Zoho Contacts
billing_state	State/Region: HubSpot State/Province: Salesforce Leads Mailing State: Zoho Contacts State: Freshsales
billing_postcode	Postal Code: HubSpot Zip/Postal Code: Salesforce Leads Mailing Zip: Zoho Contacts Zip Code: Freshsales
billing_country	Country: Salesforce Leads, Freshsales Country/Region: HubSpot Mailing Country: Zoho Contacts

5 columns no template uses

Each template page lists the columns it leaves out and why.

shipping_address_1
shipping_city
shipping_state
shipping_postcode
shipping_country

WooCommerce's own CRM integrations

HubSpot
The WooCommerce Marketplace lists a third-party extension, by We Connect Code, that syncs customers, orders and products to HubSpot.
WCC HubSpot for WooCommerce

A live integration suits records that should keep flowing into HubSpot as they change. A template suits a file you already have, a CRM WooCommerce doesn't connect to (Salesforce, Pipedrive, Zoho CRM and Freshsales) or records you want cleaned and mapped before they go in.

WooCommerce export questions

What columns are in a WooCommerce export?

15 columns, starting with first_name, last_name, email, billing_phone, billing_company, billing_address_1. The full list, and where each column lands in each CRM, is on this page.

How do I export WooCommerce data to CSV?

Install WooCommerce's Customer / Order / Coupon Export extension. Go to WooCommerce, then Export. Choose to export customers in CSV format. Run the export and download the file. The file comes out as CSV.

Which CRMs can I import a WooCommerce export into?

There are ready-made templates for HubSpot, Salesforce, Pipedrive, Zoho CRM and Freshsales: 5 in all, each mapping the export column by column. Any other CRM can take the file too, mapped by hand in the CRM Formatter.

Does WooCommerce integrate with CRMs directly?

Yes, WooCommerce has its own integrations with HubSpot, each linked on this page. For a file you already have, or records you want cleaned and mapped first, use a template here.

Templates for other exports

Lead data and prospecting

Email marketing and ecommerce

Contacts, events and forms

Moving from another CRM

WooCommerce export

Map the export into your CRM

Pick the template for your CRM, upload the file and check every column before it goes in. The CRM Formatter runs on the Free plan, no credit card needed.

Get started free See all templates