Skip to content

How to clean and format a CSV for cold email (pre-send checklist)

How-to guides·1 min read·Updated 2026-05-16·5 sections

Every cold email tool will happily import a messy CSV and burn your sender reputation in 48 hours. The 10-minute pre-send checklist below is what separates 0.5% reply rates from 5%.

01

Step 1: dedupe on email

Same prospect on the list twice gets two emails — they're marked spam in 30 seconds. Excel: Data → Remove Duplicates on email column.

Rate
1 credit / email
Email Verifier
1 credit
$0.001
credits never expire
Per 1,000
$1.00
1,000 credits
RUN SIZECREDITSCOST
30 emails30$0.03
100 emails100$0.10
500 emails500$0.50
1,000 emails1,000$1.00
1 credits a email · 1 credit = $0.001 · a run that finds fewer pays less
02

Step 2: verify with Kavex

Email Verifier flags bounce/catch-all/role-based emails. Filter to "deliverable" only.

03

Step 3: split catch-alls separately

Sender tools mark catch-all as deliverable but they often bounce silently. Keep a "catch-all" tier you send to second-week, or skip entirely.

04

Step 4: split first/last names properly

"John Smith" → first_name=John, last_name=Smith. Most mail-merge fails on "Hi John Smith" — split before send.

05

Step 5: required columns

email (verified) + first_name + company_name + at least one personalisation field (industry, city, recent post text).

Written after running it
Last run
plumbers · London · Google Maps
Rows
30
Time
23s
Cost
€0.06
30 rows × 2 credits = 60 credits · 1 credit = $0.001

Every number on this page comes from that run, not from a price list.

Point it at something. See what comes back.Your first 500 Google Maps leads are on the house. No card needed.
Start scraping free