Integrations
Import your Excel or CSV into QuickBooks Customers
Drop a messy Excel or CSV export and Importly maps every column to the exact format QuickBooks 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 QuickBooks Customers
Whatever your source file calls them, Importly matches your columns to the fields QuickBooks Customers expects:
| Field in QuickBooks Customers | Recognised from headers like |
|---|---|
| Name | name, full name, fullname, nom complet, nom et prenom, nom et prénom… |
| Company | company, company name, societe, société, entreprise, raison sociale… |
| email, e-mail, mail, courriel, adresse email, adresse e-mail… | |
| Phone | phone, telephone, téléphone, tel, tél, mobile… |
| Mobile | mobile, portable, gsm, cell, cellphone, cell phone… |
| Billing City | city, ville, town, commune, localite, localité… |
| Billing State | state, province, region, région, departement, département… |
| Billing ZIP | postal code, zip, zipcode, zip code, code postal, code_postal… |
| Billing Country | country, pays, nation… |
How to import your file into QuickBooks Customers
- 1 Upload your Excel or CSV and pick the QuickBooks 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 QuickBooks Customers. It maps on the first try.
Stop reformatting exports by hand.
Try Importly free