Before importing your deals or companies, you have to prepare the import file that contains all the information that you want to upload. Each ESP or CRM has its own requirements on how attributes should be formatted to be recognized and imported correctly.
File format rules
- Include only one type of object in your file: deals or companies.
- We recommend you include a header row in which each column header corresponds to a deal or company attribute in Brevo. Column headers are optional but make it easier for our system to match your data to the corresponding deal or company attributes. They can be organized in any order without affecting the import.
- Each deal or company must have its own row.
- Separate each value in your import file by a semicolon
;, a comma
,or a tab. If you don't specify a delimiter, your file won't be uploaded as our system won't be able to recognize each value.
- Only include one sheet in your file.
- Save your file in a CSV, XLSX, or TXT format.
- If your file contains special characters, encode it in a UTF-8 format to ensure that all characters appear correctly.
- There is no limit on the number of companies or deals you can import at once. However, make sure your file is smaller than 250 MB.
Attribute format rules
Whether they are default or custom attributes, each attribute belongs to one of the following types: Text, Number, Boolean, Date, or Category.
Each type of attribute has to follow specific format rules:
Text attributes are used to store a string of any alphanumeric characters, such as a word, a phrase, or a sentence. When used in an import file, text attributes have no character limit.
You can use a text attribute to import a company's name or language preferences.
Number attributes are used to store number values written in decimals.
You can use a number attribute to import a company's number of employees or revenue.
BooleanBoolean-type attributes are used to store values with a Yes/No format.
You can use a boolean attribute to import information about if a company had their first meeting with you yet or not.
Date-type attributes are used to store date values. Keep the format of the values under this attribute similar to the format selected under the default settings of your Brevo account (DD-MM-YYYY or MM-DD-YYYY).
You can use a date attribute to import the date when you first contacted or met a company.
Category-type attributes are used to store values from a defined set of possible values and where each value corresponds to a number.
You can use a category attribute to import a company's country and define possible values as "France", "Spain", "Germany", etc. The attribute Country of each company will then only contain one value among the ones you specified.
In an import file, you should only include the number of the value:
- 1 if the COUNTRY attribute is "France".
- 2 if the COUNTRY attribute is "Spain".
- 3 is the COUNTRY attribute is "Germany".
To import the Owner attribute, include the email address of the Brevo user you want to assign as the owner of the deal or company.
Prepare your import file
To format your deals or companies import file:
- [Recommended] In a spreadsheet, include a header row and use your Brevo default or custom attributes as your column headers.
- Paste the data of your deals or companies into the relevant fields.
- Save your import file.
Once you're done, your import file should look like one of the following examples:
|Example for deals|
|Example for companies|
➡️ What's next?
🤔 Have a question?
💬 Was this article helpful?
Thank you! Your feedback helps us improve this article for everyone.