Loading page
About this tool
Clean and organize CSV leads quickly with smart filtering.
The CSV Lead Cleaner takes an uploaded lead list and returns a CRM-ready file by lower-casing every email address, dropping rows that have no email at all, and keeping only the first row for each unique email. It reports four counts — total rows read, rows kept, duplicates removed and rows discarded for a missing email — then previews the first five cleaned records and exports the result as cleaned_leads.csv with Name, Email, Phone and Company columns.
Open CSV Lead Cleaner on AltFTool — it loads instantly in your browser.
Click the 'Choose CSV File' box to pick your raw lead list; the picker accepts .csv files, and your filename replaces 'No file chosen' underneath once it is loaded.
Press 'Process CSV'. Four counters appear — Total Rows, Cleaned Rows, Duplicates Removed and Invalid Rows — above a preview of the first five cleaned records in Name, Email, Phone and Company columns.
Press 'Download Cleaned CSV' to save the deduplicated list as cleaned_leads.csv.
Addresses are lower-cased before comparison, so Sam@Acme.com and sam@acme.com collapse into a single lead rather than slipping past a literal match.
Duplicates and email-less rows are counted separately, so you can see whether a shrinking list is a dedupe win or a sign the export was broken.
Every file comes out as Name, Email, Phone, Company in that order, so repeat imports map to the same CRM fields without redoing the column matching.
The cleaner recognizes Name or Full Name; Email, Email Address or E-mail; Phone, Mobile, Phone Number, Contact or Contact Number; and Company or Organization, without regard to case or surrounding spaces. Email is the only field that must be populated — rows missing Name, Phone or Company are kept with blanks, while a row with no email is counted as invalid and dropped.
The first occurrence in file order; every later row with the same email is discarded and added to the duplicates count. If you want the newest record to win, sort your file newest-first before uploading.
No — the email address is the only key. Two rows for the same person under different email addresses will both survive, so review the output if your source lists work and personal addresses separately.
No. It checks only that the email field is non-empty, so a typo like sam@acme,com passes through. Use a deliverability or syntax-validation step before sending if bounce rate matters.