Email Marketing · Import Guide

How to Import Your Agent List into Brevo

Brevo (formerly Sendinblue) prices by emails sent rather than contacts stored, which makes it a popular home for large lists. The importer accepts CSV, XLSX, and TXT, with attribute mapping and inline attribute creation.

Official Brevo import documentation

Before You Start

  • A Brevo account with a contact list created
  • Your USAgentLeads CSV — it's already UTF-8, which Brevo requires to avoid character issues

Step-by-Step

  1. 1

    Start the import

    Go to Contacts and choose the import option. Upload the CSV (Brevo also accepts .xlsx and .txt).

  2. 2

    Review the preview

    Brevo shows a preview of the parsed rows. Confirm the four columns (name, email, phone, state) separated cleanly — if not, the file's delimiter needs fixing before continuing.

  3. 3

    Map attributes

    Match each column to a Brevo contact attribute: email → EMAIL, phone → SMS or a text attribute, name → FIRSTNAME/LASTNAME or a custom attribute. Don't skip mapping — unmapped data can't be used for segmentation later.

  4. 4

    Create the STATE attribute inline

    Under Contact attributes, click 'Add a new attribute', name it STATE, and map our state column to it. Brevo lets you create attributes without leaving the import flow.

  5. 5

    Confirm the import

    Choose the destination list, confirm the file, and let Brevo process it. Every USAgentLeads row has an EMAIL value, which satisfies Brevo's identifier requirement.

Field Mapping Reference

Our CSV ColumnBrevo FieldNote
emailEMAILRequired identifier
nameFIRSTNAME / LASTNAMESplit first, or use a custom attribute
phoneSMS or custom text attributeSMS attribute expects international format; a text attribute is safer for raw US numbers
stateCustom attribute STATE (create inline)

Tips for Better Results

Brevo charges by email volume, not list size — you can store the full database and pay only for what you send.
Map phone to a plain text attribute unless you've normalized numbers to E.164 (+1...) format; the SMS field validates formatting.
Use the STATE attribute to build one segment per campaign region.
The CSV has a single name column. If you want {{first_name}} personalization, split it first: in Google Sheets, use =SPLIT(A2, " ") in a helper column, or Excel's Data → Text to Columns with a space delimiter.

Need the data first? 889,000+ verified agent contacts as a ready-to-import CSV. $49/state or $199 for all 50.

Get the Agent List

Frequently Asked Questions

Why Brevo over Mailchimp for a large purchased list?

Cost structure. Mailchimp bills by stored contacts; Brevo bills by emails sent. Storing 889K contacts is expensive on contact-billed platforms and effectively free on Brevo — you pay per campaign instead.

My import shows garbled characters — what happened?

That's an encoding issue. The USAgentLeads CSV ships as UTF-8; if you re-saved it in a spreadsheet app, export it again as CSV UTF-8 before uploading.

Other Import Guides