Importing accounts, contacts and leads
From the Utilities menu, you can import accounts, contacts and leads

- This feature lets you import accounts, contacts and leads into MobiCRM from a ".CSV" file.
- What makes this import original is the import file format. Usually, you have to comply with a predefined file format and strictly follow the column order of that file, which is tedious.
- That is not the case here: you simply specify the data you want to import, and the program does the rest.
- For example, if in the contacts import you only want to import the contact's name and email, you only put 2 columns in your CSV file: one column with the name (LastName) and the other with the email (ProfessionalEmail)
- The program performs the mapping based on the column names.
Importing accounts
- To import accounts, prepare a .CSV file with the data you want to import.
- Find the column name of the data to import and copy it into your Excel file
- For example, the name of an account is called CompanyName: simply create a file whose first row has a column titled CompanyName
- Example: importAccountsSimple.csv
- You can also use the sample file, which contains the names of all importable data, and delete the columns you don't need
- All importable data importAccounts.csv
- For example, the name of an account is called CompanyName: simply create a file whose first row has a column titled CompanyName
The Title column (CompanyName...) must be on the first row, otherwise the import will be rejected. We recommend testing with a few rows before running a bulk import.
How updating an existing account works
If you reimport a file with an EXTERNAL_ID that is already known, only the columns present in your file are taken into account for the update:
- Column absent from the file: the data already recorded on the account is not modified.
- Column present but empty on the row: the existing data is cleared on the account.
For example, to update only the business sector of an account, simply upload a file with only the EXTERNAL_ID, CompanyName and SECTOR columns: all the other fields of the account (address, phone, category, manager...) will remain unchanged.
⚠️ Special case of addresses, phones and emails: this information is made up of several columns that work as a block (for example for address 1: Addr1Type, Addr1StreetLine1, Addr1StreetLine2, Addr1Zipcode, Addr1City, Addr1State, Addr1Country). To update an address, a phone or an email, you must fill in all the columns of the block concerned, even those that do not change. If no column of the block is present in the file, the entire block remains unchanged on the account. But as soon as a single column of the block is present, the whole block is rebuilt from the columns in the file — any column of the block left blank will then be considered empty.
This selective update only applies when updating an existing account: when creating one, all the columns provided are used normally.
Importing contacts
- The principle is the same for contacts: prepare a .CSV file with the data you want to import.
- Find the column name of the data to import and copy it into your Excel file
- For example, the name of a contact is called LastName: simply create a file whose first row has a column titled LastName
- Example: importContactsSimple.csv
- You can also use the sample file, which contains the names of all importable data, and delete the columns you don't need
- All importable data: importContacts.csv
- For example, the name of a contact is called LastName: simply create a file whose first row has a column titled LastName
How updating an existing contact works
It works the same way as for accounts: if you reimport a file with an EXTERNAL_ID that is already known, only the columns present in your file are taken into account:
- Column absent from the file: the data already recorded on the contact is not modified.
- Column present but empty on the row: the existing data is cleared on the contact.
For example, to update only a contact's position, simply upload a file with only the EXTERNAL_ID, LASTNAME and POSITION columns: all the other fields (address, phones, emails, linked account...) will remain unchanged.
⚠️ Special case of addresses, phones and emails: as for accounts, this information is made up of several columns that work as a block (address 1: Addr1Type, Addr1StreetLine1, Addr1StreetLine2, Addr1Zipcode, Addr1City, Addr1State, Addr1Country; phones: from Phone1Type/Phone1Value to Phone5Type/Phone5Value; emails: Professionalemail, Personalemail, Email3, Email4, Email5). To modify an address, a phone or an email, fill in all the columns of the block concerned. If no column of the block is present in the file, the block remains unchanged; as soon as a single column of the block is present, the whole block is rebuilt from the columns provided.
This selective update only applies when updating an existing contact: when creating one, all the columns provided are used normally.
Importing leads
- The principle is the same for leads: prepare a .CSV file with the data you want to import.
- Find the column name of the data to import and copy it into your Excel file
- For example, the title of a lead is called Title: simply create a file whose first row has a column titled Title
- Example: importLeadsSimple.csv
- You can also use the sample file, which contains the names of all importable data, and delete the columns you don't need
- All importable data: importLeads.csv
- For example, the title of a lead is called Title: simply create a file whose first row has a column titled Title
How updating an existing lead works
The principle is the same as for accounts and contacts: if you reimport a file with an EXTERNAL_ID that is already known, only the columns present in your file are taken into account for the update; columns absent from the file leave the existing data unchanged on the lead.
ℹ️ The MANAGER_EXTERNAL_ID, ACCOUNT_EXTERNAL_ID and CONTACT_EXTERNAL_ID columns work differently: leaving them empty (column present but empty) does not remove the existing link. To remove one of these links, use the MobiCRM interface.
This selective update only applies when updating an existing lead: when creating one, all the columns provided are used normally.
Matching with your reference tables
To match a value from a reference table, simply enter in the column the position of the value in the list as a number (1 = 1st position in the list, 2 = 2nd position, 3 = 3rd position, etc...),
For example,
- In the Account Potentials table you have 6 values: P0, P1, P2, P3, P4, P5.
- If you want the import to use the value P3, enter 4 in the column (P3 being the 4th value in the list.)
- In your CSV file, you will have a Potential column with the value 4 for all the accounts you want to import and set to potential P3
The EXTERNAL_ID field: required for import
Why is this field required?
The EXTERNAL_ID field lets you give a unique identification number to each account, contact or lead you import.
Thanks to this unique number:
- You can reimport the same file without creating duplicates
- Information is automatically updated instead of being duplicated
- You stay in control of your data
What should you put in the EXTERNAL_ID column?
Choose a piece of information that uniquely identifies each item:
- For accounts: The SIRET number, your customer code, or any other number that exists only once
- For contacts: The professional email address (if each person has their own address)
- For leads: The email address or a unique reference number
⚠️ Warning
Any row whose EXTERNAL_ID column is empty will be ignored and will not be imported.
