Integrations
Import your Excel or CSV into Shopify Customers
Drop a messy Excel or CSV export and Importly maps every column to the exact format Shopify Customers expects, cleans the values, and hands you a file that imports on the first try — no manual reformatting, no failed rows.
Column headers Importly recognises for Shopify Customers
Whatever your source file calls them, Importly matches your columns to the fields Shopify Customers expects:
| Field in Shopify Customers | Recognised from headers like |
|---|---|
| First Name | first name, firstname, first_name, prenom, prénom, given name… |
| Last Name | last name, lastname, last_name, nom, surname, family name… |
| email, e-mail, mail, courriel, adresse email, adresse e-mail… | |
| Phone | phone, telephone, téléphone, tel, tél, mobile… |
| Default Address Company | company, company name, societe, société, entreprise, raison sociale… |
| Default Address Address1 | address, address1, adresse, rue, street… |
| Default Address City | city, ville, town, commune, localite, localité… |
| Default Address Province Code | state, province, region, région, departement, département… |
| Default Address Zip | postal code, zip, zipcode, zip code, code postal, code_postal… |
| Default Address Country Code | country, pays, nation… |
How to import your file into Shopify Customers
- 1 Upload your Excel or CSV and pick the Shopify Customers profile.
- 2 Importly renames the columns, cleans every value — dates, phone numbers, amounts, countries — and drops duplicates and empty rows.
- 3 Download the cleaned file and import it into Shopify Customers. It maps on the first try.
Stop reformatting exports by hand.
Try Importly free