Integrations
Import your Excel or CSV into Magento Customers
Drop a messy Excel or CSV export and Importly maps every column to the exact format Magento 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 Magento Customers
Whatever your source file calls them, Importly matches your columns to the fields Magento Customers expects:
| Field in Magento Customers | Recognised from headers like |
|---|---|
| email, e-mail, mail, courriel, adresse email, adresse e-mail… | |
| firstname | first name, firstname, first_name, prenom, prénom, given name… |
| lastname | last name, lastname, last_name, nom, surname, family name… |
| _address_telephone | phone, telephone, téléphone, tel, tél, mobile… |
| _address_company | company, company name, societe, société, entreprise, raison sociale… |
| _address_street | address, address1, adresse, rue, street… |
| _address_city | city, ville, town, commune, localite, localité… |
| _address_region | state, province, region, région, departement, département… |
| _address_postcode | postal code, zip, zipcode, zip code, code postal, code_postal… |
| _address_country_id | country, pays, nation… |
How to import your file into Magento Customers
- 1 Upload your Excel or CSV and pick the Magento 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 Magento Customers. It maps on the first try.
Stop reformatting exports by hand.
Try Importly free