Import clients from Excel or CSV file
Only admins can import data. Firstly, create the database in Excel that you want to import and create the required statuses and fields in MiniCRM. If it is necessary, change the already existing field values.
You can customize statuses within the selected module by clicking on the Wrench icon next to Pipeline.
For more information, see: Customizing Statuses (processes)
If a field has a value (it depends on its type), you have to set it according to the import. For example, by using Dropdown list or Checkbox fields, you have to enter the values that can be found in the table into MiniCRM as well.
For more information, see: Customizing Fields
During import the names written in the Excel table’s columns are imported as fields into MiniCRM, and the values written in cells are imported as field values. Namely, every row is equal to a client’s card and every column is equal to a field in MiniCRM.
If there is a difference in:
- the name of the Owner, the system is unable to recognize which owner should be set
- the name of the Status, the card will be imported into that status that you gave as default
- the Field value, the system will leave out/doesn’t check the value
Keep in mind that cells should only contain values, so don’t enter links to other cells, formulas etc.!
To download a sales module sample, click here: MiniCRM Sales Module Import Sample
To download a normal module sample, click here: MiniCRM Normal Module Sample
Structure of Excel tables
It is possible to add an owner separately to every card, that will be added, by creating a (Module item name): Owner field.
For example, in the Sales module it will be the following: Opportunity: Owner. If you enter an active user into the Owner column of the table, that user will be set as the owner of the card. If you don’t enter an owner, the system will select one randomly from those active users who have access to the given module and checked the “Default Sales resp. for new clients” option on their Profiles.
To load cards into different statuses, create a (Module item name): Status column in the table and type the name of the required status into the row belonging to the client.
For example, in the Sales module it will be Opportunity: Status.
Company data [1.1.]
- Company: Business name (e.g. Example Ltd.)
- Company: Email (e.g. firstname.lastname@example.org) - You can add more addresses to a contact (cell) by separating them with commas or semicolons. Keep in mind that you should only use commas OR semicolons in one cell. However, if you have used only commas in one cell, you can use only semicolons in another one.
- Company: Email type (e.g. work)
- Company: Phone (e.g. 087 017 001 615) - You can add more numbers to a contact (cell) by separating them with commas or semicolons. Keep in mind that you should only use commas OR semicolons in one cell. However, if you have used only commas in one cell, you can use only semicolons in another one.
- Company: Phone type (e.g. work
- Company: Description (e.g. medium-sized company with 12 employees…)
- Company: Website (e.g. www.example.com)
- Company: Industry (e.g. Consulting)
- Company: Region
Address data [1.2.]
- Address1: Type (e.g. Headquarters)
- Address1: Country (e.g. United States)
- Address1: Postal code (e.g. 32826)
- Address1: City (e.g. Orlando)
- Address1: Address (e.g. 70 Phillips Street)
Addresses are added to the company (not to the contact person) or, in case of a private individual, to the person.
The values of these columns’ cells will be added to the following fields of the card:
Import more address data [1.3.]
If you load several addresses simultaneously, you have to connect them in the Excel table by using numbers.
The rows belonging together should appear like this:
- Billing address:
The rows of columns connected by the same numbers will appear like this [1.3.]:
If you click on the arrow next to the Address type field, you can set the type of addresses. After selecting the required type, enter the selected value into the Address1: Type column of the Excel table.
Contact Persons’ Data [1.4.]
- Person1: First Name (e.g. John)
- Person1: Last Name (e.g. Smith)
- Person1: Email (e.g. email@example.com) - You can add more addresses to a contact (cell) by separating them with commas or semicolons. Keep in mind that you should only use commas OR semicolons in one cell. However, if you have used only commas in one cell, you can use only semicolons in another one.
- Person1: Email type (e.g. work)
- Person1: Phone (e.g. 087 017 001 615) - You can add more numbers to a contact (cell) by separating them with commas or semicolons. Keep in mind that you should only use commas OR semicolons in one cell. However, if you have used only commas in one cell, you can use only semicolons in another one.
- Person1: Phone type (e.g. work)
- Person1: Position (e.g. Sales) The values of these columns’ cells will be added to the following fields of the card:
Import more Contact persons’ data [1.5.]
You can import more contact persons to a card. You can connect their data by using numbers.
- Default Contact Person:
- Second Contact Person:
After importing, the data of contact persons will appear like this:
In the system the Position field is a dropdown list that contains various values. After selecting the required value, you can enter it into the Person1: Position column of the Excel table.
The following field types exist:
The name of the Excel table’s columns has to be equal to fields, and the cells should be filled out based on the values of the dropdown list.
It is not enough to create only the field in the system, you also have to set the values.
The name of the Excel table’s columns has to be equal to fields.
More values can be checked simultaneously. The values in cells should be separated by commas. Their sequence can be reversed, and you can type spaces after commas.
It is not enough to create only the field in the system, you also have to set the values. It is not allowed to write only numbers in this field type so type some words as well into the table.
Text box [2.3.]
Any values can be written in this field type, so it is enough to create the field in the system, you don’t have to give it a value.
The name of the Excel table’s columns has to be equal to fields and you can type the content into the cells.
Date and Time [2.4.]
You should type the date in the following format: DD-MM-YYYY-HH:MM / 08-10-2014 10:00.
You have to create Date and Time fields before the import, but they only get values during the import.
Number field [2.5.]
The name of the Excel table’s columns has to be equal to fields and you should type the numbers into the cells.
You also have to create the fields in the system before the import.
For more information, see: Customizing Fields
You can only import .XLS, .XLSX, .ODS or .CSV files. The file has to contain min. 3 columns.
Creating XLS and XLSX
In Microsoft Excel click on File > Save.
In OpenOffice click on File > Save.
In Microsoft Excel and OpenOffice click on File > Save as. In Google Docs select the File > Download as > CSV option.
MiniCRM accepts .CSV files using the following code pages:
If you are using Windows operating system and Microsoft Excel, select the Comma-separated values (CSV) option.
If you are using Apple OS X operating system and Microsoft Excel, select the Specialty Formats / Windows Comma Separated option instead of Common Formats / Comma Separated Values.
If you are using Linux operating system and OpenOffice Calc or LibreOffice Calc select the Text CSV (.csv) option.
If the .CSV file is created, you can start the import.
Follow-up sequences can be connected to Statuses and to saved Filters as well. Before starting the import, check whether the clients that will be imported are affected by active follow-up sequences or not, and that they can receive the messages or not.
If it is necessary, modify the follow-up sequences before the import.
For more information, see: Automated follow-up (Email, SMS, Task)
Email addresses can be imported into the system as active and inactive.
Email addresses of newsletter subscribers will be imported as active into the system.
Email addresses of those clients who have unsubscribed will be imported into the system as inactive.
The email addresses of those clients who haven’t subscribed yet will be also imported as inactive.
For more information, see: Structure of Excel Tables
To activate Not Subscribed addresses, you need to send an email manually containing an activation link by using MiniCRM.
If a client clicks on the link, their email address becomes activate and will receive emails sent automatically by MiniCRM. (It is possible to send emails manually to Not subscribed addresses.)
To send an activation link, you need a written or verbal permission from the client. You cannot send them an email asking for their permission because that is also spam.
For more information, see: Spam: Zero tolerance
Steps of import
To import the client database, click on the [New…] > [Import] option [3.1.] within the selected module.
The steps are the following:
You can upload .XLS, .XLSX, .ODS or .CSV files by clicking on Upload file [4.1.] link.
If you click on the Copy directly from Excel spreadsheet link [4.2.], a text box appears [4.3.] to which you can copy data directly from a spreadsheet (Microsoft Excel, OpenOffice, Google Spreadsheet).
Choose this option if you want to import a small amount of data into the system. If you want to import a large amount of data, choose the Upload file option.
If you have finished, click on [Next »] [4.4.].
You can set a Status for clients. If you want to import clients into different statuses, create a Status column in the Excel table.
For more information, see: Structure of Excel tables
If you have created a Status column in the table, clients will be imported into the status given in the table, not into the status set in this field.
Activate emails [5.2.]
Identified action [5.3]
You can set how new data will be handled after the identification of clients’ email address if the company or person already exists in the system.
There are 3 options:
- Add new Card each time
- Update available Card
- Error message when Card exists.
If you have finished, click on [Next »] [5.4.].
You can join the name of Excel columns and the field names in MiniCRM [6.1.].
In case of a Dropdown list and a Checkbox it is not enough to create fields in the system, you also have to set the values.
For more information, see: Preparing MiniCRM
If you have already set the values during preparation, you can continue the import by clicking on [Next »] [6.2.].
To explore problems, MiniCRM runs a test [7.1.]. After that, you should correct the errors and restart the import. If everything is all right, click on [Next »] [7.2.].
The most common error messages are the following:
“Invalid choosable value…”
Reasons: Spelling mistake or missing value. These rows won’t be processed during import.
“Company name or Contact1 name not found in this line…”
It is obligatory to give Company or Person1 name. If there are Company: columns in the Excel table, and any columns’ cells contain a value, the system examines the Company: Business name column. If none of the cells contain a value or there is no such column in the table, the system examines the Person1 name. If none of them exists, these rows won’t be processed during import.
Invalid email format
Rows containing invalid email formats won’t be processed during import.
Email already exists
You have to declare that the owners of email addresses gave you their contacts and permitted you to send them mass emails, and that they really gave you the permission and not to a third party.
For more information, see: Spam: Zero Tolerance
If you accept the terms and take responsibility for your sendouts, check this field [8.1.].
To import data, click on the [Import] button [8.2.]. By clicking on the Imported clients [9.1.] link, you can see the new cards listed within the selected module.
On the Import page, you can see imports for one week [10.1.] and you can undo them by clicking on the Delete link [10.2.]. Only those cards are deleted that weren’t modified after the import.
“(Company) data shown in pictures were only created for testing.”