CSV tools for lead lists
14 free tools to clean, combine and prepare a lead list before you import it. Drop a CSV or Excel file. Everything runs in your browser, and the file never leaves your device.
Clean
6 tools
Fix every column
Combine
4 tools
Join and split
Prepare
4 tools
Ready to import
Clean
6 tools. Names, company names, titles, domains and phone numbers, cleaned for a merge tag.CSV list cleaner
Drop a lead list and Ken cleans names, companies, titles and domains, removes duplicates and flags freemail, role and disposable emails, in your browser.
Company name cleaner
Turns "ACME LOGISTICS, LLC" into "Acme Logistics": strips legal suffixes, fixes casing and keeps the brand, ready for personalization.
Name cleaner
Fixes casing, strips honorifics, credentials and emojis, splits first and last names and flags entries that are not names.
Job title normalizer
Cleans job titles and tags each with a seniority and a department, so your filters and personalization work.
Domain normalizer
Turns URLs, emails and LinkedIn links into clean root domains and handles, with a dedupe key for each row.
Phone number formatter
Formats every phone number in your list to E.164, using a country column or a default country.
Combine
4 tools. Remove duplicates, merge files, split a big list and drop your suppression list.Remove duplicates from CSV
Removes duplicate rows by email, domain, LinkedIn URL or company name and keeps the most complete row.
Merge CSV files
Combines several CSV or Excel files into one, lining up columns that have different names.
Split CSV
Splits a big CSV into smaller files by row count or by the value of a column.
Suppression list
Removes every row that also appears in a second list: customers, do-not-contact or people you already emailed.
Prepare
4 tools. Catch empty merge tags, convert columns for your sending tool and fix broken characters.Merge tag checker
Finds the rows that would send "Hi ," because a field your template uses is empty.
CSV converter
Converts an export from Apollo, Instantly, Smartlead or HubSpot into another tool's import format, or Ken's.
Email extractor
Pulls every email address out of pasted text, a page's HTML or a messy CSV column.
CSV encoding fixer
Repairs broken characters like "José" in a CSV, so names and companies read right again.
Ken cleans every list before it sends.
Import a CSV and Ken fixes names, removes risky addresses and checks every email. Start free with 1,000 credits, no card.
Why clean a list before you send
A raw export from Apollo or Sales Navigator is full of things that hurt a campaign: "ACME TECHNOLOGIES, INC." in a merge tag, duplicates across files, personal inboxes, role addresses and broken characters from a bad export. Each one costs replies or deliverability.
Runs in your browser
Every CSV tool here reads the file in your browser. Nothing is uploaded, so you can clean a list with personal data without sending it anywhere. Files up to 200,000 rows work without freezing the tab.
Questions
Is my file uploaded?
No. The file is read and cleaned in your browser and never leaves your device. If you email yourself a summary, it carries counts, never rows. The list cleaner's summary adds the file name and its column names.
Which files work?
CSV and Excel files, from Apollo, Sales Navigator, HubSpot, Instantly, Smartlead or a spreadsheet. Columns are matched automatically.