---
title: "Add missing phone numbers to a lead list, before and after"
description: "Add missing phone numbers to a lead list in Pipecorn. Enrich the whole list, compare the same rows before and after, and read your phone coverage. Video inside."
canonical: "https://pipecorn.com/pipeschool/before-after"
---
# Add missing phone numbers to a lead list, before and after

> Add missing phone numbers to a lead list in Pipecorn. Enrich the whole list, compare the same rows before and after, and read your phone coverage. Video inside.

Source: https://pipecorn.com/pipeschool/before-after

To add missing phone numbers to a lead list, import the file in Pipecorn under **Leads › Import leads › From CSV**, then open the list, click **Enrich leads**, pick **All in list**, tick **Work email** and **Mobile phone** and click **Enrich**. The empty Phone column fills in row by row, and the phone counter next to the total leads tells you how many mobiles you got.

This tutorial is about seeing the difference on the same file. You look at the list before enrichment, run it, then read the result. A work email costs 3 credits and a mobile 30, and a contact that comes back Not found costs nothing. To import and enrich in one pass instead, see [Enrich a lead list you already have](https://pipecorn.com/pipeschool/lead-list-enrichment).

## What you need

Phone enrichment is open to owners, admins and managers. A member can enrich phones only if the workspace allows members to.

* **A file of leads** as a CSV or Excel file, with first name, last name and company for each person. A LinkedIn URL is optional but recommended.
* **A Pipecorn account.** The free plan works and comes with 150 credits a month.
* **Credits for the mobiles.** At 30 credits a mobile, the free plan's 150 credits cover 5 mobiles, so test on a slice of the file first.
* **Room in your monthly leads.** Each import counts toward your plan's leads: 500 on Free, 5,000 on Build and 25,000 on Grow.

## Add missing phone numbers to a lead list, step by step

1. ### Look at what your file already has  
Your file knows who your leads are. What it usually lacks is a way to reach them, with a phone column that's empty or half filled by another tool. Keep that in mind, because the mapping in the next step has no phone field. The numbers already in your file aren't imported, so every mobile you see afterwards is one Pipecorn found.  
![A lead file q4-prospects.csv open in a spreadsheet with first_name, last_name, company_name, linkedin_url and a phone column only about half filled](https://res.cloudinary.com/dqqyl36ed/video/upload/so_9.5,c_fill,ar_16:9,w_1280,f_auto,q_auto/pipecorn/university/before-after.jpg)  
The file before Pipecorn, with a half-empty phone column
2. ### Import the file as a CSV and leave the boxes unticked  
In **Leads**, click **Import leads**, then **From CSV**, and drop your file. On **CSV fields mapping**, Pipecorn matches your headers to **Company Name**, **Lead Firstname**, **Lead Lastname** and **Lead Profile Linkedin Url** for you. Check the example data next to each field.  
Leave **Find contact info for the whole list** unticked and click **Import leads**. Importing without contact info costs no credits, and it gives you the list as it is before enrichment.  
![The CSV fields mapping screen with Company Name, Lead Firstname and Lead Lastname mapped to company_name, first_name and last_name, and Find contact info for the whole list left unticked](https://res.cloudinary.com/dqqyl36ed/video/upload/so_15.6,c_fill,ar_16:9,w_1280,f_auto,q_auto/pipecorn/university/before-after.jpg)  
Your columns, mapped for you
3. ### Read the list before enrichment  
The list opens in **Leads**, named after your file. The **Work email** and **Phone** columns are empty, and each cell shows an **Enrich email** or **Enrich phone** button. The email and phone counters at the top both read 0.  
![The imported list q4-prospects in Pipecorn Leads with the Work email and Phone columns highlighted, every cell showing Enrich email or Enrich phone](https://res.cloudinary.com/dqqyl36ed/video/upload/so_19,c_fill,ar_16:9,w_1280,f_auto,q_auto/pipecorn/university/before-after.jpg)  
Before, with nothing in Work email or Phone
4. ### Click Enrich leads and pick All in list  
Click **Enrich leads** at the top of the list. It shows how many people are in the list. Pick **All in list** among **All in page**, **All in list**, **Only qualified** and **Custom**, then click **Continue**.  
![The Enrich leads menu open on the q4-prospects list with All in list selected and the Continue button](https://res.cloudinary.com/dqqyl36ed/video/upload/so_23.2,c_fill,ar_16:9,w_1280,f_auto,q_auto/pipecorn/university/before-after.jpg)  
Enrich leads › All in list
5. ### Tick Work email and Mobile phone  
The panel reads **Everyone in this list**. Tick **Work email**, then **Mobile phone**. Under each one, a line says how many people don't have one yet and the most it can cost. The button then reads **Enrich · up to N credits**, and the line below it says **Credits are only charged for the contacts we find.**  
Leave **Personal email** as it is. It's a separate option at 9 credits that has to be turned on in settings first.  
![The enrich panel with Work email and Mobile phone ticked, the Enrich button showing the maximum credits, and the note that credits are only charged for the contacts found](https://res.cloudinary.com/dqqyl36ed/video/upload/so_29,c_fill,ar_16:9,w_1280,f_auto,q_auto/pipecorn/university/before-after.jpg)  
The ceiling shows before you click
6. ### Click Enrich and watch the same rows fill in  
Click **Enrich**. Each cell shows **Enriching…** and then turns into an email, a mobile or **Not found**. A badge next to the counters follows the phones, from **Enriching phones** to **Phone enrichment finished**.  
![The q4-prospects list during enrichment, with work emails filled in, some phone cells still Enriching and others showing numbers or Not found](https://res.cloudinary.com/dqqyl36ed/video/upload/so_34.2,c_fill,ar_16:9,w_1280,f_auto,q_auto/pipecorn/university/before-after.jpg)  
The same rows, filling in
7. ### Read your phone coverage from the counters  
When the badge says **Phone enrichment finished**, look at the top of the list. The phone counter shows how many mobiles were found, and the people counter next to it shows the total leads. Pipecorn shows the two counts, not a percentage, so divide one by the other to get your phone coverage for this file.  
![The enriched q4-prospects list with the cursor on the phone counter, next to the total leads, qualified and emails counters, and the Phone enrichment finished badge](https://res.cloudinary.com/dqqyl36ed/video/upload/so_36.3,c_fill,ar_16:9,w_1280,f_auto,q_auto/pipecorn/university/before-after.jpg)  
Mobiles found, next to the total leads
8. ### Download the list or push it to your CRM  
Open the **⋮** menu at the top right of the list. **Download** exports the enriched list. **Push leads to** sends the leads to a CRM or sequencer, among them HubSpot, lemlist, Instantly and Smartlead.  
![The list's More actions menu open with Push leads to expanded, listing Sales Navigator, Lemlist, Instantly, Smartlead and Hubspot](https://res.cloudinary.com/dqqyl36ed/video/upload/so_43.2,c_fill,ar_16:9,w_1280,f_auto,q_auto/pipecorn/university/before-after.jpg)  
⋮ › Download, or Push leads to

## What filling the phone column costs

Importing the file is free in credits and counts toward your monthly leads. Enrichment is charged per contact found: 3 credits for a work email and 30 for a mobile. A row that comes back **Not found** costs nothing, so the figure on the **Enrich** button is a ceiling and the real cost depends on how many contacts Pipecorn finds.

Paid plans add credits every month and roll unused ones over. See [Pricing](https://pipecorn.com/pricing) for the plans and the price per mobile on each one.

## Read the result the right way

* **The ☎ hover isn't your coverage.** Hovering the phone counter opens **Providers**, where each provider's share is a share of the phones found, not a find rate. Your coverage is the phone count divided by the total leads.
* **Tick Mobile phone alone if you only need phones.** The ceiling on the button drops to 30 credits a person.
* **Compare tools on the same file.** Run the rows another tool left blank and compare the phone count. Pipecorn asks one provider after another until one has the contact. [Run the waterfall and check what's deliverable](https://pipecorn.com/pipeschool/waterfall) shows the providers behind each result.
* **Pushing to a CRM needs Grow.** HubSpot, Salesforce and Pipedrive sync come with Grow and Scale.
* **Compare phone tools before you commit.** [Best phone number enrichment tools for cold calling](https://pipecorn.com/blog/best-phone-number-enrichment-tools-for-cold-calling) compares them, and [how to verify phone numbers before you dial](https://pipecorn.com/blog/phone-number-verification-service) covers the checks.

## Questions

### Does Pipecorn keep the phone numbers already in my file?

No. The CSV fields mapping has no phone field, so the file's own numbers aren't imported. Every mobile in the enriched list is one Pipecorn found.

### How do I see what percentage of my leads got a mobile?

Divide the phone counter by the total leads counter at the top of the list. Pipecorn shows both counts but not the percentage.

### Can I enrich a list I imported earlier without contact info?

Yes. Open it in Leads, click **Enrich leads**, pick **All in list**, tick what you want and click **Enrich**. You don't need to import the file again.

### Do I pay for the leads where no mobile is found?

No. A mobile costs 30 credits and a work email 3, only when Pipecorn finds it. A cell that says Not found costs nothing.

### What's the difference with importing and enriching in one step?

Ticking Work email and Mobile phone under Find contact info for the whole list on the mapping screen starts the enrichment at import, as in [Enrich a lead list you already have](https://pipecorn.com/pipeschool/lead-list-enrichment). Importing first lets you see the list before and run the enrichment when you choose.

### Can I enrich only part of the list?

Yes. In **Enrich leads**, pick **All in page**, **Only qualified** or **Custom** instead of **All in list**.

## Video transcript

1. Here is the same file of leads, before and after Pipecorn, with the share of mobiles it found.
2. Your file knows who your leads are. The phone column is empty, or half filled by another tool.
3. In Leads, import it as a CSV. Pipecorn maps the columns for you.
4. Here is the list before. The Work email and Phone columns are empty.
5. Click Enrich leads and pick All in list. Then tick Work email and Mobile phone.
6. A work email costs three credits and a mobile thirty, only for the ones we find.
7. Click Enrich. The same rows fill in with emails and mobiles as they're found.
8. After. The phone counter shows the mobiles found, next to the total leads in your list.
9. Then download the list, or push the leads to your CRM.

## Steps

1. In Leads, import your file as a CSV. Pipecorn maps the columns.
2. Click Enrich leads, pick All in list and tick Work email and Mobile phone.
3. Click Enrich. The rows fill in as contacts are found.
4. Read the phone counter for the mobiles found against the total leads.
5. Download the list or push it to your CRM.

## What you need

* Works on the Free plan
* Credits: 3 credits per email, 30 per mobile, only when found
[Compare the plans ](https://pipecorn.com/pricing)

## Watch next

[![](https://res.cloudinary.com/dqqyl36ed/video/upload/so_30.5,c_fill,ar_16:9,w_800,f_auto,q_auto/pipecorn/university/waterfall.jpg)Only deliverable emails0:57Run the waterfall and check what's deliverableRun the waterfall on a lead list, see which provider found each contact, and export only the deliverable emails.](https://pipecorn.com/pipeschool/waterfall)[![](https://res.cloudinary.com/dqqyl36ed/video/upload/so_12,c_fill,ar_16:9,w_800,f_auto,q_auto/pipecorn/university/wrong-number.jpg)Fix a wrong number0:36Report a wrong number and get another oneReport a mobile that reached the wrong person, and Pipecorn removes it and looks for another one.](https://pipecorn.com/pipeschool/wrong-number)[![](https://res.cloudinary.com/dqqyl36ed/video/upload/so_16,c_fill,ar_16:9,w_800,f_auto,q_auto/pipecorn/university/crm-sync.jpg)Leads in your CRM0:50Push your leads to HubSpotConnect HubSpot, map the fields and the owner, then push a list. Salesforce works the same way.](https://pipecorn.com/pipeschool/crm-sync)

[All 16 tutorials →](https://pipecorn.com/pipeschool)

## Still stuck?

Book a call and we'll walk through it with you on your own account. Or read the docs, every feature and the API are there.

[Book a call with us](https://zcal.co/t/pipecorn/discussion)[Read the docs](https://docs.pipecorn.com/)