How to Enrich a CSV of Leads in Minutes

The file has been in your downloads folder for two weeks. Six hundred rows of 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 now about a fifteen-minute job, and most of that time goes on deciding which columns you actually want. This guide covers the whole path: import, map, price the run, enrich, deal with the rows that miss, then get the finished list into your CRM or a sequence.

What your file needs before you enrich a CSV of leads

Match rates are decided by what you upload, not by which provider runs. Here is what each column buys you.

The domain row is the one that matters. "Acme Inc." is a string that thousands of companies share some version of, while acme.com is an identifier. If your export only carries company names, spend the first pass filling the domain column 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 on that table is upside.

Import your CSV and map the lead columns

Upload the file and the header row is picked up automatically. Each column in the file becomes a column in the table, with the original values left alone.

Then you confirm the mapping:

1. Point the person column at the name field, or at first and last name if your export splits them.

2. Point the company column at a domain if you have one, and at company name if you do not.

3. Set the dedupe key, usually email or domain, so the same lead does not get enriched twice.

4. Check the row count that survived. Blank and malformed rows get flagged rather than silently dropped.

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.com. We see it often enough that the mapping screen warns you about it now.

What it costs to enrich a CSV of leads, before you run it

Every operation has a published credit price at $0.02 a credit, and one meter covers all of it. Pick your columns and the total for the run appears before you start.

Those figures assume every row matches, which no list ever does, so treat them as a ceiling. Rows nobody can match cost nothing.

The preview is there to change your mind while changing it is still free. A 600-row file with mobile numbers on every row is $110 before you have sent a single email. The same file with verified work emails is $34. Decide that in the preview rather than in next month's invoice.

Enrich a CSV of leads with the automatic waterfall

No single data provider 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 providers, set the order, then revisit the order when match rates drift. Oneprofile orders the waterfall by cost and hit rate: the cheapest provider likely to answer runs first, escalation happens only on a miss, and the cascade stops at the first verified match.

Verification sits inside the run rather than after it. A candidate address that fails verification does not stop the cascade, so a catch-all or a dead mailbox does not end up in your export wearing the same green tick as 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, each row shows which provider answered it. Useful later, when someone asks where a number came from.

Fix the misses: what to do with rows no provider 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 empty cells and the misses usually sort into four groups:

• No domain, or the wrong domain. The largest group by a distance. Fill the domain column and re-run just those rows.

• Very small companies. Under about ten employees, provider 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 provider databases refresh and rows that missed in March match in April at no extra cost to you.

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 vendor you bought. A number quoted without those three things attached is decoration.

Export enriched leads or sync them straight to your CRM

The finished table 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. Map columns to properties, and properties that do not exist yet get created with the right field type.

• Enrol a segment in a sequence, email and LinkedIn steps on one canvas, with every enriched column available as a personalization variable.

Any of 127 integrations works as a destination, on every paid plan. The rows arrive verified, which is the only kind worth sending to.

Try it on your own file. The free plan covers 200 credits and tables of up to 100 rows, 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.