Export reference

Shopify CSV export: every column, and where it goes

Shopify is an ecommerce platform. Its export has 15 columns, and 6 ready-made templates map it into 6 CRMs.

By Operelio teamUpdated September 26, 2026

Shopify import templates, by CRM

How to export from Shopify

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

Shopify

Export customers from Shopify

From your Shopify admin, go to Customers and click Export.
Choose the current page, all customers, selected customers or those matching your filters.
Optionally include customer tags or metafields.
Choose the CSV for spreadsheet programs, or Plain CSV file.
Click Export customers.

File: CSV

Exports of more than 50 customers are emailed to you rather than downloaded.

Shopify: Importing and exporting customer lists

Every column in a Shopify 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.

Shopify 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, Copper
Last Name	Last Name: HubSpot, Salesforce Leads, Zoho Contacts, Freshsales Name: Pipedrive, Copper
Email	Email: HubSpot, Salesforce Leads, Pipedrive, Zoho Contacts, Freshsales, Copper
Phone	Phone Number: HubSpot, Copper Phone: Salesforce Leads, Pipedrive Mobile: Zoho Contacts Mobile Number: Freshsales
Company	Company Name: HubSpot, Freshsales, Copper Company: Salesforce Leads Organization: Pipedrive Account Name: Zoho Contacts
Address1	Street: Salesforce Leads, Copper Street Address: HubSpot Mailing Street: Zoho Contacts Address: Freshsales
City	City: HubSpot, Salesforce Leads, Freshsales, Copper Mailing City: Zoho Contacts
Province	State: Freshsales, Copper State/Region: HubSpot State/Province: Salesforce Leads Mailing State: Zoho Contacts
Zip	Postal Code: HubSpot, Copper Zip/Postal Code: Salesforce Leads Mailing Zip: Zoho Contacts Zip Code: Freshsales
Country	Country: Salesforce Leads, Freshsales, Copper Country/Region: HubSpot Mailing Country: Zoho Contacts
Total Spent	Description: Salesforce Leads, Freshsales Notes: HubSpot
Total Orders	Description: Salesforce Leads, Freshsales Notes: HubSpot
Tags	Description: Salesforce Leads, Freshsales Notes: HubSpot
Note	Description: Salesforce Leads, Zoho Contacts, Freshsales Notes: Pipedrive Details: Copper

1 column no template uses

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

Accepts Email Marketing

Shopify's own CRM integrations

HubSpot
HubSpot documents a two-way sync between Shopify customers and HubSpot contacts.
HubSpot data sync

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

Shopify export questions

What columns are in a Shopify export?

15 columns, starting with First Name, Last Name, Email, Phone, Company, Address1. The full list, and where each column lands in each CRM, is on this page.

How do I export Shopify data to CSV?

From your Shopify admin, go to Customers and click Export. Choose the current page, all customers, selected customers or those matching your filters. Optionally include customer tags or metafields. Choose the CSV for spreadsheet programs, or Plain CSV file. Click Export customers. The file comes out as CSV.

Which CRMs can I import a Shopify export into?

There are ready-made templates for HubSpot, Salesforce, Pipedrive, Zoho CRM, Freshsales and Copper: 6 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 Shopify integrate with CRMs directly?

Yes, Shopify 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

Shopify 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