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