Login / Sign up
URL / CRM / Accounting

How to prepare an email column for Mailchimp import

2026-06-21
Task

Contact emails can contain uppercase letters, spaces, or invalid text. Mailchimp needs an Email Address column.

Short answer

Create Email Address, trim and remove spaces, lowercase the value, and keep only rows that match an email regex.

How to do it in Eofferix

  1. Upload the contacts table and open the table editor.
    Email Address prepared for Mailchimp in Eofferix
    The preview shows cleaned emails, while the row without a valid address is not exported.
  2. Create Email Address from email and add Trim, Remove spaces, and Lowercase rules.
    Email cleanup rules for Mailchimp
    The rules remove spaces and lowercase the address before validation.
  3. Add an export condition after transformation: the value must match an email regex.
  4. Save the template and export the import file.

Before / after

The data below is a training example and does not belong to real user files.

Before

source data
contact_idemail
C-1001 USER@Example.TEST
C-1002sales @ shop.example
C-1003not an email

After

result
contact_idEmail Address
C-1001user@example.test
C-1002sales@shop.example

Process data faster with Eofferix

Create a free account to automate catalogs and price lists around your own rules.

Sign up