Brevo contact import file formatter: EMAIL, FIRSTNAME, LASTNAME and SMS
In short: Upload any export (.xlsx or CSV) or paste cells. The tool writes EMAIL, FIRSTNAME, LASTNAME and SMS with lower-case emails and +country-code phone numbers, one address per contact, and merges repeats. Limit: Only EMAIL, FIRSTNAME, LASTNAME and SMS are written; add other attributes as columns.
Brevo's help center says to use the EMAIL, FIRSTNAME, LASTNAME and SMS attributes, that a contact holds one email address, and that each row needs at least one identifier such as EMAIL or SMS. Upload your export here to get that file, one address per row, with repeats merged.
Price: this tool is free. Checking a whole email list is from $9/mo, and the first 100 checks are free with Google, no card. Check your list free nowSee pricing
Used only to complete phone numbers.
Sample result
Jane's row becomes jane@example.com with SMS +14155550132, and a phone-only row is kept because it has an identifier.
- Rows
- 3 contacts
- SMS
- +14155550132
- Repeats merged
- 1
What this means for you
Brevo holds one email per contact and needs an EMAIL or SMS on each row.
- EMAIL, names and SMS
- One address per contact
- +country-code phones
- Repeats merged
- Brevo
- Contacts
- CSV
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
Check the addresses before they go into Brevo.
- Export the email column from the file you just made, or use the check button under the result.
- Upload or paste it at /verify. Every address gets a live mailbox check, and the first 100 email checks are free with a Google sign-in, no card.
How do I prepare a file for a Brevo contact import?
- Upload the export (.xlsx or CSV), or paste the cells with the header row first.
- Choose the country used for phone numbers written without a + country code.
- Check the columns found and the rows left out, then download the CSV.
- In Brevo, import contacts from a file and confirm each column maps to the attribute you expect.
Example
- You enter
- A sheet with Full Name, Work Email, Mobile, Country, Company and Website:
Jane Doe,Jane@Example.com,(415) 555-0132,United States,Northwind,https://www.northwind.example/about;Leo Martinwithleo@example.org; l.martin@example.org; a repeat row forjane@example.com; and a row with only a phone,(212) 555-0100. - You get
- Three contacts under EMAIL, FIRSTNAME, LASTNAME and SMS: Jane with
+14155550132, Leo withleo@example.org, and the phone-only row as+12125550100. The repeat is merged and Leo's second address is dropped and counted. - Limits
- Runs in your browser; nothing is uploaded. Files up to 25 MB.
What does Brevo require in a contact file?
Brevo's help center says the file should have one sheet, one contact per row and a header row whose names match contact attributes, saved as UTF-8 or Windows-1252, with each row holding at least one identifier such as EMAIL or SMS. A contact can have only one email address. See Brevo's guide to creating an import file.
How are phone numbers handled?
Brevo uses the SMS attribute for the number used for SMS and calls, and its importer applies a country code you choose to numbers that lack one. This tool writes each number with its own + and country code, using the country you pick for numbers written without one, so one file can hold several countries.
What is left out or changed?
Rows with no valid email and no phone are counted and left out. Repeats are merged. If a cell holds several addresses the first is kept and the rest are counted, since Brevo takes one per contact. CONTACT_ID is not written; Brevo's guide says to include it only when updating existing contacts.
Who uses this tool, and for what?
- Marketing teams
- Load a customer or event list into Brevo with attributes already named.
- Agencies
- Prepare each client's contacts the same way.
- Shop owners
- Combine email and SMS contacts in one file.
What can’t this tool tell you?
- Only EMAIL, FIRSTNAME, LASTNAME and SMS are written; add other attributes as columns.
- Confirm the attribute mapping on Brevo's import screen, since this page can't see your account's attributes.
- Phone numbers that can't be read are left blank and counted.
- List choice and consent are set in Brevo, not here.
Common questions
- Which attribute names does Brevo use?
- EMAIL, FIRSTNAME, LASTNAME and SMS are the default attributes its guide names for email, names and phone.
- Can a Brevo contact have two emails?
- No. Each contact has one email address, so extra addresses are dropped and counted here.
- What does each row need?
- At least one identifier such as EMAIL or SMS; rows with none are left out.
- How large can the file be?
- Brevo's guide lists under 250 MB for a file import.
- Is my list uploaded to SimpleVerifier?
- No. The file is read and rewritten in your browser.
Sources
A tidy list can still be full of dead addresses.
Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.
- Upload the cleaned file as it is: CSVs up to 100,000 rows
- A real SMTP mailbox check on every row, with catch-all detection
- Small list? Starter at $9/mo covers 2,500 emails a month, cancel anytime
Plans from $9 a month, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.