Lead Formatter - Clean & Enrich Leads

Lead Formatter - Clean & Enrich Leads

Clean, format, and enrich your leads for cold email in one run. Upload a CSV, Excel, or JSON file and get back a standardized dataset with formatted names, job titles, company names, phone numbers, and optional AI-generated personalization. No code required.

Cold email outreach fails when your lead data is messy: inconsistent job titles, unformatted phone numbers, and missing company context. This tool takes your raw leads file and automatically cleans and standardizes it, so every row is ready for your email campaign. It also offers optional AI enrichment to generate personalized lines, company descriptions, and industry tags, helping you increase reply rates.

Who uses it	What they scrape Lead Formatter for
Sales development reps	Prepare a clean, deduplicated lead list for cold email outreach
Marketing teams	Segment leads by country, job title, or industry for targeted campaigns
Recruiters	Format candidate contact details and generate personalized outreach lines

What it does

This Actor uploads a leads file, cleans and formats the contact fields, optionally removes blanks and duplicates, and returns a structured dataset with each lead as a flat row.

• 🧹 Data cleaning: remove blank leads, remove duplicates by email, and standardize phone numbers to E.164 format.
• ✍️ Formatting: capitalize job titles and company names, strip business suffixes like Inc. or LLC.
• 🤖 AI enrichment: generate company descriptions, personalized opening lines, case studies, and industry tags.
• 🔍 Web search: enable real-time web search to enrich leads with up-to-date company info.
• 📁 Segmentation: group leads into separate datasets by any field, e.g., country or job title.

Results export to CSV, JSON, Excel, or XML, or straight from the API.

What you can do with Lead Formatter data

📈 Prepare a clean lead list for cold email.

A sales team uploads a messy CSV of prospects and gets back a formatted, deduplicated list ready for their email tool.

🎯 Segment leads for targeted outreach.

A marketer segments leads by country and job title to run region-specific campaigns with tailored messaging.

✉️ Generate personalized email openers.

A founder enables AI personalization to create unique opening lines for each lead, increasing response rates.

🏢 Enrich company data for better context.

A researcher generates company descriptions and industry tags to understand each prospect's business before reaching out.

Why choose this scraper

	What you get
Clean data	Standardized names, job titles, company names, and phone numbers for professional outreach.
Deduplication	Remove duplicate leads by email to avoid contacting the same person twice.
AI personalization	Generate tailored opening lines and company descriptions to boost reply rates.
Segmentation	Split leads into separate datasets by country, job title, or industry for targeted campaigns.

How it compares

Unlike Skool member scrapers that only pull raw profiles, this tool cleans and enriches your existing leads with formatting and AI personalization.

Feature	ParseForge	SKOOL | Members/Groups | Discovery Search | Scraper (PPE)
Upload your own leads file	Yes	Not listed
Remove duplicates by email	Yes	Not listed
Format job titles and company names	Yes	Not listed
AI-generated personalized lines	Yes	Not listed
Email verification	Yes	Not listed

Configure the run

Feed the Actor a leads file (CSV, Excel, or JSON) and configure cleaning options like removing blanks or duplicates, formatting fields, and enabling AI enrichment. Filters run as each lead is processed, so only the cleaned and enriched data reaches your dataset. The Input tab lists every parameter.

A first run with the defaults:

{
  "leadsFile": "https://api.apify.com/v2/key-value-stores/rFlGez0FeHA0VgeU0/records/test-incomplete-leads.csv",
  "segmentBy": [],
  "fieldConfigurations": {},
  "temperature": "0.3"
}

Pricing

Pay-per-result: $0.0095 per result collected. You pay only for the results written to your dataset.

Results collected	Approximate cost
100 results	$0.95
1,000 results	$9.50
10,000 results	$95.00

New Apify accounts start with $5 in free credit.

Free users

Free-plan runs return up to 10 results as a preview. Upgrade your Apify plan to collect more results per run.

Run it

1. Create a free Apify account with $5 in credit.
2. Open the Lead Formatter - Clean & Enrich Leads.
3. Set your inputs and any filters, then click Start.
4. Export the results as CSV, Excel, JSON, or XML from the Dataset tab.

Run it programmatically through the Apify API (run-sync-get-dataset-items) or the ApifyClient for JavaScript and Python.

Use with AI agents (MCP)

Give an AI agent live access to Lead Formatter through the Model Context Protocol. Add the Actor to Claude, Cursor, or any MCP client:

$claude mcp add --transport http apify "https://mcp.apify.com?tools=parseforge/lead-formatter"

Then prompt it in plain language to run the scraper and read back the results.

Troubleshooting

Why am I getting no results?

Check that your file has an 'email' column and that the leads are not all blank. If you enabled 'Remove Blank Leads', empty rows are deleted.

Why are some phone numbers not formatted?

Phone formatting works best with US numbers. For international numbers, ensure they include the country code.

Why is AI enrichment slow?

AI features take longer to process. You can disable web search or reduce the number of AI fields to speed up the run.

FAQ

Question	Answer
What file formats can I upload?	You can upload CSV, Excel (XLSX), or JSON files. The tool automatically detects column names, so you can use variations like 'First Name' or 'first_name'.
How does email verification work?	If you provide a Million Verifier API key, each email is checked and a 'verifiedEmail' field is added with statuses like 'valid', 'invalid', or 'disposable'.
Can I remove duplicate leads?	Yes, enable the 'Remove Duplicates' option to keep only the first occurrence of each email address.
What does AI enrichment cost?	AI features like generating company descriptions or personalized lines increase the run cost slightly. You can enable only the ones you need.
Can I customize the AI output?	Yes, use the 'Field Configurations' option to set custom prompts and output column names for each field.
How do I segment leads?	Use the 'Segment By' option to list fields like 'country' or 'jobTitle'. Each segment is saved to a separate dataset.

Related actors

Browse the full ParseForge collection for more scrapers.

🆘 Need help? Email parseforge@protonmail.com with your run ID, your input, and what you expected.

⚠️ Disclaimer. This Actor is unofficial and is not affiliated with, endorsed by, or sponsored by Lead Formatter. It collects only publicly available data. You are responsible for using the collected data in compliance with the source's terms of service and applicable data-protection laws, including GDPR, CCPA, and PIPL. Do not use it to collect personal data unlawfully.