Integrations
Import your Excel or CSV into BigCommerce Customers
Drop a messy Excel or CSV export and Importly maps every column to the exact format BigCommerce 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 BigCommerce Customers
Whatever your source file calls them, Importly matches your columns to the fields BigCommerce Customers expects:
| Field in BigCommerce 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 Address | email, e-mail, mail, courriel, adresse email, adresse e-mail… |
| Company | company, company name, societe, société, entreprise, raison sociale… |
| Phone | phone, telephone, téléphone, tel, tél, mobile… |
| Address Line 1 | address, address1, adresse, rue, street… |
| City/Suburb | city, ville, town, commune, localite, localité… |
| State/Province | state, province, region, région, departement, département… |
| Zip/Postcode | postal code, zip, zipcode, zip code, code postal, code_postal… |
| Country | country, pays, nation… |
How to import your file into BigCommerce Customers
- 1 Upload your Excel or CSV and pick the BigCommerce 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 BigCommerce Customers. It maps on the first try.
Stop reformatting exports by hand.
Try Importly free