How do I add users via an Excel file?

To save time, you can choose to add your users from an Excel file so that you do not have to add your users one by one. 

⚠️ When importing an Excel file, the Boost My Mail user database is updated based on the contents of the Excel file:

• A change to a property will be applied.
• A deleted property (or one left blank) will be deleted.
• A removed user will be deleted.
• A change to a group assignment will be applied.
• ...

This means that a user who is present in the interface but not present in the Excel file will no longer appear after the import!

We recommend storing and always working with the same Excel file for your successive imports. There is no daily limit on the number of imports you can carry out!

• For a first import, the Excel template can be downloaded from your portal via the Users menu and the Users tab by clicking Add and then selecting Excel file.

• The Excel file must contain the following columns in the header:
  • firstname (first name)
  • lastname (surname)
  • mail 
  • company (company)
  • jobtitle (job title)
  • streetaddress (address)
  • city (city)
  • postalcode (postcode)
  • phone (landline telephone)
  • mobile (mobile telephone)
  • website (website)
  • usermessage (user message)
  • disclaimer (company message)
  • group (group)

If you have manually added new properties (via the Settings > Properties > Add a property menu), remember to add the corresponding columns to your Excel file.

The only mandatory field is the mail field. You do not have to fill in all the fields provided. 

⚠️ Certain conditions must be followed when filling in this file:

✅ Your entries must be in lower case.

✅ The cells in the "mail" column must contain an email address. An email address can only be entered once.

✅ The cells in the "group" column can reference several groups; they must then be separated by a comma ",".
Example: Human Resources, Marketing

✅ To avoid any confusion caused by Excel formatting the data, we recommend ensuring that the entire Excel table is in "text" mode. 
To do this, select all your cells, go to Home > Editing > Clear > Clear Formats.

Then go to Home > Cells > Format > Format Cells > Number > Text.