Apollo.io B2B Leads Export Sample CSV (Dirty + Clean)
A realistic Apollo.io lead list (300 contacts) engineered with the exact data quality issues that destroy cold email deliverability. The 'dirty' version includes: duplicate emails from overlapping searches, role-based addresses (info@, admin@) that trigger spam filters, catch-all domains falsely marked as 'verified', and mixed-case names resulting in 'Hi jOHN' personalization disasters. The 'clean' version shows the output after deduplication and name normalization. Ideal for testing cold email platform imports (Instantly, Smartlead) to protect domain reputation, or CRM deduplication workflows in HubSpot and Salesforce. All processing happens locally — your lead data stays private.
Live Interactive Preview
Live Data Preview
See how this messy apollo data looks before downloading. All processing happens locally in your browser.
💡 Pro Tip: Apollo says 'verified' — your email provider says 'spam trap'. Run this list through Apollo Leads Cleaner to strip role-based emails, kill duplicates, and normalize names before it torpedoes your domain.
⚡ Next Step: Drowning in duplicates from overlapping Apollo exports? Hit it with CSV Deduplicator. Fuzzy-match on email, keep the richest row, discard the rest.
Data Schema Definition
| Column | Type | Description |
|---|---|---|
| First Name | string | Often mixed case (jOhn, MARY). Must be Title-Cased before {{first_name}} merge tags or risk looking unprofessional. |
| Last Name | string | May contain prefixes (de, van, von). Splitting on space breaks compound surnames. |
| Title | string | Job title. Inconsistent abbreviations (VP vs V.P. vs Vice President) break seniority segmentation. |
| Company | string | Inconsistent suffixes (Inc., LLC, Inc, L.L.C.) and missing spaces. Normalize before ABM tier assignment. |
| string | B2B work email. Duplicate across overlapping search exports; requires case-insensitive dedup. | |
| Email Status | string | Enum: Verified | Guessed | Unavailable. 'Guessed' has 40%+ bounce rate; filter before sending. |
| Catch-All | boolean | TRUE if domain accepts any prefix. High bounce risk even when Email Status = Verified. |
| LinkedIn URL | string | Profile URL. Often truncated or missing https:// prefix; validate before CRM enrichment. |
| Phone | string | Mixed formats: +1-xxx, (xxx), xxx.xxx. Standardize to E.164 before dialer integration. |