Why Your Mailchimp Contact Import Fails (and How to Fix It)

You exported your contacts, opened Mailchimp's import wizard, and got a vague error or an import that completed with half your subscribers missing. Mailchimp is unusually strict about file formatting, and the errors it reports rarely point at the real problem. The good news: almost every failed import comes down to a handful of fixable issues in the file itself.

What File Format Mailchimp Actually Accepts

Mailchimp imports a comma-separated CSV file or a tab-delimited TXT file. It does not accept Excel workbooks (.xlsx or .xls), vCard (.vcf), or other formats. If you upload an Excel file directly, the import fails before it starts. Always use "Save As" and choose CSV first.

The Five Issues That Break Mailchimp Imports

1. Wrong Encoding (Corrupted Names and Accents)

Mailchimp expects UTF-8 encoding. Files saved as ANSI, Windows-1252, or Latin-1 either fail outright or silently corrupt accented characters, so "José" becomes "José" in your campaigns. In Excel, choose "CSV UTF-8 (Comma delimited)" from the format dropdown, not the plain "CSV (Comma delimited)" option, which uses your system's local encoding.

2. Semicolon Delimiters (European Settings)

Mailchimp only reads comma-separated files. Excel installed with French, German, Dutch, Spanish, or other European regional settings defaults to semicolons as the list separator, which produces a file Mailchimp can't parse into columns. If every contact lands in a single field, your delimiter is the culprit.

3. Invalid Email Syntax

The email column is required, and each contact needs exactly one address. Mailchimp rejects rows with missing emails, leading or trailing spaces, unsupported characters, or two addresses crammed into one cell. A stray space before an address (" name@example.com") is enough to flag the row.

4. Files That Are Too Large

Files over roughly 200 MB or about one million contacts can trigger import errors. If a large import keeps failing, split it into several smaller files and import them one at a time.

5. Overlong Text Fields

Text fields are capped at 255 bytes. Anything longer is clipped. Note that emoji and many accented or non-Latin characters use more than one byte each, so a field can hit the limit well before it reaches 255 visible characters.

Step-by-Step: Prep Your List Before You Upload

The Faster Way: Automated Cleanup

Manually fixing encoding, delimiters, and stray spaces across thousands of rows is slow and error-prone. PipeSheets re-encodes your file to UTF-8, normalizes the delimiter, trims whitespace, and drops empty rows automatically. Upload your export, run Quick Clean, and download a Mailchimp-ready CSV in seconds.