Skip to content

Lead List Cleaner & Enricher

Try for free

Clean and enrich any lead list with any column names: remove duplicates, check emails, check and format phones, mark mobiles, add company info and social links, and score every row. Keeps your columns; CSV and Excel included.

🧹 Lead List Cleaner & Enricher

Give it any lead list (another run's results, a CSV, Excel or JSON file, a Google Sheet, or pasted rows) with any column names. It finds the email, phone, name, company and website columns by itself, removes duplicates, checks every email, checks and formats every phone number and marks mobiles, fills in missing company info and social links (LinkedIn, Facebook, Instagram, X), and gives each row a quality score. Every original column is kept, the new ones are added next to it, and you get the result as a dataset plus ready-made CSV and Excel files. No login needed.

✨ Why use Lead List Cleaner & Enricher?

  • 🧠 Any column names: Email, E-Mail, work_email, Phone 1, Telefon, Mobile Phone, Company Name, Firma, Website URL... are found from their names, and from the values when the names say nothing. You can override any guess.
  • 🔁 Duplicates removed: the same email in any case, else the same phone, else the same name at the same company is kept once.
  • 📧 Email check: syntax, typos in the domain (with a suggested fix such as gmial.com → gmail.com), mail servers, disposable inboxes and role addresses like info@.
  • 📱 Phone check: valid or not, E.164 and international format, line type, and mobile marked. Local numbers are read for each row's country when the list has a country column.
  • 🏢 Company info: name, domain, industry, employees, revenue range, headquarters, founding year and description, found from the website column or the domain of a business email. A company is only kept when it is really the lead's: the same website, or the same name in the lead's country and city.
  • 🔗 Social links: the company's own LinkedIn, Facebook, Instagram and X pages, from the company directory and from the links on the company's website. Instagram is looked up for every company, with a search of Instagram by company name as the last step. Works for small local businesses too: 68% of 1,003 Google Maps businesses got at least one link, and 58% got their Instagram.
  • ⭐ Quality score from 0 to 100 per row, with a short note on what is missing or wrong.
  • 📁 CSV and Excel files with all your columns, ready to import into a CRM.

🎯 Use cases

  • 🧲 Before a cold email campaign: drop bad and risky addresses to protect your sender reputation.
  • 📇 CRM imports: one format for every phone number and no duplicate contacts.
  • 🧾 Clean up scraped leads from Google Maps, LinkedIn, directories or trade fair lists in one step.
  • 🎯 Prioritize outreach: sort by quality score and start with complete, valid leads.

🚀 How to use

  1. Add your list: pick a Dataset from another run, add File links (CSV, Excel .xlsx or JSON; public Google Sheets, Google Drive, Dropbox and GitHub links work), paste CSV, or paste rows as JSON. You can combine them.
  2. Choose what to do: Check emails, Check and format phones (set the Default country for numbers without a + prefix), Fill in company info and Find missing social links. All four are on by default.
  3. Click Start. The log shows which columns were found. If a guess is wrong, set the column under Column names and run again.
  4. Download the dataset, or open the leads.csv and leads.xlsx files in the run's key-value store (the links are also in the OUTPUT record).

📥 Input example

{
    "rows": [
        { "Full Name": "Jason Fried", "Email": "jason@basecamp.com", "Company": "Basecamp", "Phone": "" },
        { "Full Name": "Jason Fried", "Email": "JASON@basecamp.com", "Company": "Basecamp", "Phone": "" },
        { "Full Name": "Support", "Email": "support@github.com", "Company": "", "Phone": "" },
        { "Full Name": "Jane Doe", "Email": "jane.doe@gmial.com", "Company": "", "Phone": "+44 20 7946 0958" },
        { "Full Name": "Front desk", "Email": "", "Company": "Google", "Phone": "+1 650-253-0000" },
        { "Full Name": "Sales", "Email": "sales@datadoghq.com", "Company": "Datadog", "Phone": "+44 7911 123456" }
    ],
    "defaultCountry": "US"
}

To clean the results of another run:

{
    "datasetId": "YOUR_DATASET_ID",
    "companyColumn": "name",
    "domainColumn": "website"
}

📤 Output example

Your columns stay as they are, and the new ones are added after them. One row from the example above:

{
    "Full Name": "Jason Fried",
    "Email": "jason@basecamp.com",
    "Company": "Basecamp",
    "Phone": "",
    "email_status": "good",
    "email_score": 90,
    "email_reason": "Valid address; the domain takes email (Own mail server)",
    "email_suggestion": null,
    "phone_valid": null,
    "phone_e164": null,
    "phone_international": null,
    "phone_type": null,
    "phone_is_mobile": null,
    "phone_country": null,
    "company_name": "Basecamp",
    "company_domain": "basecamp.com",
    "company_industry": "Collaboration Software, Social Media",
    "company_employees": 85,
    "company_revenue": "$5M - 25M",
    "company_headquarters": "Chicago, Illinois, USA",
    "company_founded": 1999,
    "company_description": "Basecamp is an Illinois-based SaaS platform that provides solutions such as project management and team communication to businesses.",
    "company_linkedin": "https://www.linkedin.com/company/37signals",
    "company_facebook": "https://www.facebook.com/basecampcom",
    "company_instagram": "https://www.instagram.com/basecamp_hq/",
    "company_twitter": "https://twitter.com/basecamp",
    "quality_score": 75,
    "quality_notes": "no phone",
    "enrich_error": null
}

The second Jason Fried row (JASON@basecamp.com) was removed as a duplicate, jane.doe@gmial.com came back bad with the suggestion jane.doe@gmail.com, and the UK mobile was marked phone_is_mobile: true.

A Google Maps row (a Munich bakery with no website and no directory entry) gets its Instagram from the search by name, kept because the account has the bakery's name and its Munich address:

{
    "title": "Adriatik - Bäckerei • Konditorei",
    "city": "München",
    "countryCode": "DE",
    "phone": "+49 89 55196867",
    "website": null,
    "phone_valid": true,
    "phone_e164": "+498955196867",
    "phone_type": "landline",
    "phone_is_mobile": false,
    "company_name": null,
    "company_instagram": "https://www.instagram.com/adriatikbackerei/",
    "quality_score": 40,
    "quality_notes": "no name"
}
FieldWhat it isWhere it comes from
email_statusgood, risky (role address, catch-all and similar) or badEmail check (syntax, DNS and mail server records, disposable and role lists)
email_score, email_reason, email_suggestionScore from 0 to 100, the reason in plain words, and a corrected address for typosEmail check
phone_valid, phone_type, phone_is_mobileValid or not, line type (mobile, landline, toll_free, landline_or_mobile for US and Canada...). phone_is_mobile is empty when the number itself cannot tell (US and Canada)Phone check (Google's libphonenumber data)
phone_e164, phone_international, phone_countryThe number as +14155550123 (E.164), in international format, and its country. Your original number stays in your own columnPhone check
company_name, company_domain, company_industry, company_employees, company_revenue, company_headquarters, company_founded, company_descriptionThe company profilePublic company profile directory, looked up by website or email domain, else by name
company_linkedin, company_facebook, company_instagram, company_twitterThe company's own social pages. Instagram links are always https://www.instagram.com/<handle>/The company profile, else the links on the company's home page, else (no website) a search on the networks by exact company name. Instagram: the company profile, the home page links, then a search of Instagram by company name (see Good to know). A Facebook or Instagram link in your website column is used as is
quality_score, quality_notes0 to 100 and what is missing or wrong (see below)Calculated from the checks
enrich_errorSet only when a step failed for this row; such rows are not charged

How the score is made: email good 40 (risky 20, could not be checked 10), phone valid 20 (mobile 25), a name 10, a company 10, a company domain 5, a company social page 10.

⚠️ Good to know

  • Personal emails (Gmail, Outlook, Yahoo...) are checked, but no company is looked up from them. Add a company or website column to get company info for those rows.
  • Company info is found for well-known and mid-size companies. Small local businesses are mostly not in the company directory: in 1,003 Google Maps businesses from 8 countries, 17% got company info, against 93% for lists of tech and retail companies. A company found under the same name in another country or city is not used, and neither is a booking or website platform (Setmore, Booksy, Square, Phorest...) when a shop's website is a page on it.
  • Social links came for 68% of those 1,003 businesses and 87% to 100% of the company lists. Small businesses mostly get Instagram (58%) and Facebook (43%), larger companies LinkedIn and X from the directory. A site that blocks robots or loads its links with JavaScript gives no links. For businesses without a website, a LinkedIn or Facebook profile is kept only when its handle is exactly the business name (10 letters or more), so a few of those can belong to a business with the same name elsewhere.
  • Instagram is looked up for every company: first the links on its home page, then a search of Instagram by the company name (with the city for businesses without a website). An account is kept only when its handle looks like the company name or domain and its shown name is the company name; a link on a company's home page is kept only when its handle shares the name (so spam links on taken-over domains and website-builder links are dropped). When the list has a city column, a searched account must name the lead's city. When several accounts share the name, the one whose profile links to the company's website wins; if none does, the field stays empty. In our tests Instagram filled for 34 to 35 of 36 companies (SaaS, consumer brands and cafés from 14 countries; before this lookup: 6), 578 of 1,003 Google Maps businesses from 8 countries (before: 45%), 52 of 80 Dublin Google Maps businesses (before: 40) and 49 of 69 businesses in Austin, Munich and São Paulo (before: 35). In hand checks of 30 links, 28 were the business's own account; one (huel.us) no longer exists although the company's website still links to it, and one, since fixed, was another shop in the same city. For a branch of a chain or franchise you may get the chain's main account.
  • An email marked good has a working domain and mail server; the check does not send an email, so it cannot confirm that the mailbox exists.
  • Speed: the website step reads one page per company. A few large sites take minutes to read (spotify.com took 7 minutes in our tests) and hold up that step, so 36 well-known companies took 5 to 9 minutes. The Instagram search takes a few minutes per 200 businesses. In our tests: 69 Google Maps businesses in about 3 minutes, 80 Google Maps businesses in 3 to 4 minutes, 1,154 Google Maps rows (1,003 after duplicates) in 24 minutes, and a 1,000-row list with many slow or dead websites in 19 minutes. Websites whose domain does not exist are skipped. Phone numbers without a + prefix are checked once per country, so a list from 190 countries spends about 5 minutes on phones.
  • Up to 50,000 rows per run, and files up to 50 MB. The whole list is deduplicated and written to one CSV and one Excel file in a single run, so very large lists go in several runs.
  • Each check runs in your account. The email, phone, company info, website, name search and Instagram steps you turn on run as their own runs in your account and are billed by those Actors. Each lead saved is charged once here; removed duplicates are not charged, and rows hit by a failed step are saved without a charge. Turn off Find missing social links to skip the social steps. Your spending limit covers all steps: the run only takes as many leads as the limit can pay for, with every step included.

❓ FAQ

What if my columns are not found? The log lists the columns it used. Set the right ones under Column names (email, phone, full name or first and last name, company, website, country) and run again.

Can I run it after a scraper automatically? Yes. Add an integration or webhook to the scraper that starts this Actor with datasetId set to the scraper run's defaultDatasetId.

Does it change my data? No. Your original columns and values are kept as they are; the results are added in new columns. If a new column has the same name as one of yours, it gets _enriched at the end.

Why are some new columns missing? Columns are only added for the steps you turn on: no email columns without Check emails (or when the list has no email column), no phone columns without Check and format phones, and no company profile columns without Fill in company info (the social link columns stay when Find missing social links is on).

Which file types work? CSV (comma, semicolon or tab), Excel .xlsx (the first sheet with data), and JSON (a list of rows, or an object with an items, data, rows or leads list).

//From the blog\\

Latest articles

All articles

The internet is full of data.
Start owning yours.

Scrape.ly gives you the infrastructure, the tooling, and the team to extract, process, and operationalize web data at any scale. Setup takes minutes.

No credit card. No setup calls.