Skip to main content

Importing clients

Bring in, in one go, the client list you kept in a spreadsheet or in another tool, from a CSV file. You see what would be created before anything is imported.

Prepare the file​

From the client list, click Import, then Download the template to get an example file to fill in. You can also start from your previous tool's export.

The file holds one line per client, and its first line names the columns. The columns can come in any order and only the Nom (name) column is required.

ColumnWhat it holds
NomThe client's name. Required.
TypeEntreprise (business, the default) or Particulier (private individual). Company and Individual work too.
SIRETThe client's SIRET. Required for a business.
NΒ° TVAIts VAT number.
E-mail, PrΓ©nom, Nom du contactThe contact to write to: e-mail address, first name, last name. The contact is created when the line carries an e-mail address.
Site webThe client's website.
Adresse, ComplΓ©ment d'adresse, Code postal, Ville, PaysIts address: street, second line, postcode, city, country. The country is written in full or as its code (France or FR).
DeviseIts currency code (EUR). See Client currency.

The usual titles are recognised as well, in French and in English: "Raison sociale", "Company", "Zip"… A column that is not recognised is ignored, and the preview tells you so.

info

The separator (semicolon or comma) and the file's encoding are detected: a file saved by Excel as "CSV" works as it is. A file holds 2,000 lines and weighs 1 MB at most.

Check the preview​

Choose your file, then click See the preview. Nothing is imported at this point. The preview shows:

  • how many clients would be created;
  • the clients already there: a line whose name already exists among your clients, archived ones included, is left out;
  • the lines refused, with their number in the file and what stands in the way.

A line is refused when it breaks a rule of the client form: a business without a SIRET, a malformed e-mail address, an empty name. The rules are those of creating a client.

tip

To bring in a refused line, fix it in the file and import the file again: the clients already created are recognised and are not created twice.

Import​

Click Import these clients. The account that follows gives the same figures, this time for what was done, and See the clients takes you back to the list.

The import only ever adds: it never changes or deletes an existing client.