Cold email CSV checker

How it works

Paste your list, confirm which columns are email and personalization fields, then run checks. The output is a short summary plus a row-level findings table you can export as a CSV.

What it checks

It catches the structural mistakes that break personalization and create duplicate contacts when you import into Apollo, Instantly, Smartlead, Clay, Lemlist, Mailshake, HubSpot, or any mail merge. If you still need candidate addresses first, use the bulk email permutator.

• Flags missing first_name and company columns
• Catches duplicate emails and duplicate domains
• Catches invalid email syntax, role-based addresses, and free-mail domains
• Finds broken LinkedIn URLs and malformed domain formats
• Flags whitespace, non-ASCII characters, all-caps company names, and placeholder values like N/A

Clean a bare email list

Not every list arrives with columns. If all you've got is a stack of addresses, one per line or comma-separated out of a signup form or an old export, switch the tool to bare-list mode and paste them straight in. You get the same findings table, plus a deduplicated, cleaned list you can copy or download.

Each address runs through the same address-level checks. It catches typo domains like gnail.com and suggests the fix, spots disposable and temp-mail domains, marks duplicates, and flags role accounts like info@ and sales@, free-mail addresses, and stray whitespace or placeholder junk like n/a.

It's a formatting and list-quality pass, and that's the whole scope. It reads what's in each address; it doesn't contact any mail server or confirm that a mailbox exists. Treat a clean result as worth sending to, not as a guarantee the message lands.

How to fix the file before import

The report is most useful when you treat each finding as an import decision. Some rows need correction, some need suppression, and some need a separate research pass before they belong in a campaign.

Missing first name

Look up the name or add a fallback greeting rule in the sending platform.

Role-based address

Move it into a review list unless the campaign is meant for shared inboxes.

Duplicate email

Keep one row so one person does not receive the same sequence twice.

Free-mail address

Check context. It may fit freelancers or small businesses, but weakens company-account outreach.

Placeholder value

Replace or remove it before previewing the merge.

After cleanup, preview the actual message with the mail merge preview tool. A CSV can pass field hygiene checks and still produce awkward merged sentences.

What it does not do

This is a hygiene pass on the file you paste, nothing more. It reads what's already in each cell: email syntax, duplicates, role and free-mail addresses, broken LinkedIn URLs, and placeholder values. It can't confirm that an address actually receives mail, predict whether your messages reach the inbox, or judge which prospects are worth keeping. It won't fill in blank companies or push the cleaned rows into Smartlead, Apollo, or your CRM. Handle enrichment and deliverability with the tools built for that, then send.

Privacy

Your prospect list never leaves your device. Every check runs in the browser, and if you export a findings CSV it's built locally too. dreamif.ai doesn't receive the file or any of its rows.