The file has been in your downloads folder for two weeks. Six hundred names and company names from a Sales Navigator export or a conference badge scan, and the campaign has not gone out because looking up six hundred email addresses by hand is worse than not sending it at all.
To enrich a CSV of leads is a short job now, and most of the time goes on deciding which fields you actually want. This guide covers the whole path: import, map, price the run, enrich, deal with the leads that miss, then get the finished list into your CRM or a sequence.
If you want to follow along with your own file, import it into a free workspace and keep this page open beside it.
What your file needs before you enrich a CSV of leads
Match rates are decided by what you upload, not by which data source runs. Here is what each column buys you.
Column in your file | Needed? | What it makes possible |
|---|---|---|
Company domain | Yes, in practice | Firmographics, and the match that finds the email |
Full name, or first and last | For person-level data | Work email, mobile phone, LinkedIn profile |
LinkedIn profile URL | Optional | The best single input for a phone lookup |
Job title | Optional | Cleaner matching on common names |
Existing email | Optional | Verification, and person enrichment from the address |
The domain is the one that matters. "Acme Inc." is a string that thousands of companies share some version of, while acme.example is an identifier. If your export only carries company names, spend the first pass filling in the domain and everything downstream gets cheaper.
If all you want to do is add emails to a lead list, a name and a domain is the whole requirement. Everything else is upside.
Import your CSV and map the lead columns
Upload a .csv or .xlsx file under 50MB. The first row becomes the column names, and every column arrives with a guessed type, such as Text, Number, Date, or Email.
Then you confirm the mapping:
Point the person column at the name field, or at first and last name if your export splits them.
Point the company column at a domain if you have one, and at company name if you do not.
Untick any column you do not need, and fix a type that was guessed wrong.
Read the distinct and empty counts sitting on each column. Click one and you can page through its values exactly as your file wrote them, leading zeros and odd spacing included.
Check the row count on Create table. After the import, a banner says how many rows were added and lists any that could not be read, with the reason.
Duplicates are a separate step. Once the table exists, open the email or domain column's header menu and choose Remove duplicates, so the same lead is not enriched twice.
Most first runs that go badly go badly here, and it is nearly always the same thing: a company column holding "Acme Inc." instead of acme.example. Check that column's values before you run anything.
What it costs to enrich a CSV of leads, before you run it
Preview what the run will cost before you start it. Every enrichment publishes the most one lead can cost, at $0.02 a credit, and one meter covers all of it. A lead is charged the price of the data source that answered it, so most leads cost less than the figure below.
Field you add | Up to, per matched lead | Up to, per 1,000 matched leads |
|---|---|---|
Work email plus Verify email | 10.8 credits | $216 |
Verify email only | 0.8 credits | $16 |
Company firmographics, from a domain | 15.0 credits | $300 |
Person enrichment, from an email | 10.0 credits | $200 |
Phone number | 39.4 credits | $788 |
No list matches every lead, and a lookup that finds nothing costs nothing. The run also holds the most it could cost and releases what it did not use when it finishes.
The preview is there to change your mind while changing it is still free. A 600-lead file with phone numbers for every lead can cost up to $472.80 before you have sent a single email. The same file with verified work emails is up to $129.60. Decide that in the preview rather than in next month's invoice.
Enrich a CSV of leads with the automatic waterfall
No single data source covers everyone. One database is strong on US tech and thin across Europe, the next is the reverse, and the way coverage climbs is by asking several of them in order until one answers.
Most tools hand you that chain to build. You pick the data sources, set the order, then revisit the order when match rates drift. Oneprofile sets the order itself, most accurate first. The waterfall asks data sources one at a time and stops at the first one that returns an answer, so the next data source runs only on a miss.
Verification is its own step, and it belongs beside the email lookup rather than in a second tool afterwards. Add Verify email next to Find work email and every address gets a Deliverability verdict, so a catch-all or a dead mailbox is labelled catch-all or invalid instead of sitting in your export looking like a real address. For a founder sending from their own domain, that is the difference between a campaign and a deliverability problem.
While the run works, the email lookup shows what it has spent so far and the average per lead. Useful early, when a list is quietly resolving on the expensive rungs.
Fix the misses: what to do with leads no data source matched
Nobody hits 100%, and any csv enrichment tool that implies otherwise is selling you an average from somebody else's list. Filter to the leads with missing data and the misses usually sort into four groups:
No domain, or the wrong domain. The largest group by a distance. Fill in the domain and re-run just those leads.
Very small companies. Under about ten employees, data source coverage thins out fast, whatever the marketing says.
Personal addresses only. Consultants and founders on Gmail exist in no work-email database.
Recent job changes. Someone who moved companies six weeks ago is often still filed under the old employer.
Group one is worth an hour of your time. The rest are worth a re-run in thirty days, because data source databases refresh and a lead that missed in March can match in April. You pay only when it does.
Anyway, one industry habit worth complaining about while we are here: the single coverage percentage. Coverage depends on geography, company size, and seniority far more than it depends on which tool you bought. A number quoted without those three things attached is decoration.
Export enriched leads or sync them straight to your CRM
Your finished list leaves in whichever direction you need:
Download it as a CSV with the enriched columns appended to your original ones.
Push it to your CRM. Create any custom properties in the CRM once, then map the enriched fields to them.
Enrol a segment in a sequence: email and LinkedIn steps on one canvas, with all the enriched research ready to personalize each message.
Every integration that accepts data can take the finished list, on every paid plan. With Verify email beside the lookup, every address arrives with its Deliverability verdict, so you send to the valid ones and hold back the rest.
Try it on your own file. The free plan covers 200 credits a month, three tables, and up to 100 rows per table, enough to run a genuine sample end to end, and credits never expire whether you upgrade or not. The $20 Team plan takes tables to 10,000 rows when the sample convinces you. Get started free and run the first hundred leads today.