Prepare the file

One row per person, the column names on the first row. Only the e-mail address is required. The page reads these columns:

Column What it holds
email The person’s e-mail address (required)
first_name, last_name Their first and last name
group The name or the ID of one of your user groups
lang Their language, as a two-letter code such as fr
phone_number Their phone number
business_name, account_type Their company, and individual, company, soletrader or non_profit
address_line1, address_line2, address_zipcode, address_city, address_country Their address; the country as a two-letter code such as FR
external_id Their ID on your former platform

Click Download the template for a file with these columns and an example row. The users export uses the same names, and French names work too (prénom, nom, groupe, ville, pays…). Commas, semicolons and tabs are all read, and a CSV saved by Excel keeps its accents. A file holds up to 5,000 rows: split a larger one.

Check the file

  1. In the menu, click Users, then Import users.
  2. Under CSV or Excel file, choose your file.
  3. Under Group of the users the file does not give one, choose the group of the rows whose group cell is empty.
  4. Click Check the file.

Nothing is created at this step. The page shows how many accounts to create, how many addresses already have an account, left as they are, and how many rows that cannot be imported, then lists the Rows to look at with what happens to each, and the first accounts to create. If a row is wrong, fix the file and send it again.

Create the accounts

Click Create … accounts. The import starts within a minute and runs in the background: the page shows its progress, and you can leave it. Once it says Done, click See the users to find them in your users list.

Your latest imports stay listed on the import page, with the number of accounts created.

What your users see

  • Imported users have an active account straight away, in the group of their row. They receive no e-mail: to sign in the first time, they click the forgotten-password link of the login page and choose their password.
  • Existing users see no change: an import never changes an account that already exists.

Edge cases and limits

  • An address already used: the row is left out and the existing account stays as it is, even when the file holds other details for it.
  • The same address twice in the file: only the first row is imported; the other says on which line it already is.
  • Telling your users: since no e-mail is sent, let them know yourself, for example in a newsletter, and point them to the forgotten-password link.
  • Up to 5,000 rows per file: a larger file is refused; split it and import each part.