Trade show lead list cleaner
Drop in the messy CSV from your badge scanner or the show's export and get a deduplicated, CRM-ready file in seconds. Your list never leaves your browser.
1. Add your leads
Showing example dataUpload the CSV from your badge scanner, lead capture app or the show's export. It's read in your browser and never uploaded.
or drop it here. Comma, semicolon and tab separated files all work.
Paste CSV text instead
2. Check the columns
We've guessed what each column holds. Fix any that are wrong. Unrecognized columns are kept as they are.
3. Flags and filters
One per line. Domains match emails and websites, including subdomains; plain names match the company field. Add your own domain to catch colleagues who scanned each other.
Clean leads ready to import
8 of 10 rows
2 duplicates merged, 5 flags raised.
Download
HubSpot and Salesforce files use those tools' standard import labels, so most columns map automatically. Salesforce leads need a last name and company, so blanks are filled with [not provided]. Columns you kept are added at the end.
What changed
- Rows in
- 10
- Rows out
- 8
- Merged by email
- 1
- Same email scanned more than once
- Merged by name and company
- 1
- Same person, different or missing email
- Names split
- 10
- Rows with casing fixed
- 4
- Emails tidied
- 1
- Lowercased, trimmed or stripped of stray characters
- Countries standardized
- 9
- Companies filled from domain
- 1
- Personal email
- 1
- Likely students
- 1
- Competitors or vendors
- 1
- Invalid email
- 1
- No email
- 1
Preview
All 8 clean rows.
| Name | Company and title | Grade | Flags | |
|---|---|---|---|---|
| Dana Lee2 scans merged | dana.lee@northwind-analytics.com | Northwind AnalyticsVP of Marketing | A | |
| Chidi Okafor | chidi.okafor@gmail.com | Brightline LabsField Marketing Manager | B | Personal email |
| Ana de la Cruz | ana.delacruz@contoso.co.uk | Contoso (from domain)Head of Events | B | |
| Tom O'Brien | tom.obrien@fabrikam.com | FabrikamSenior Director Demand Gen | C | |
| Jordan Smith | jordan.smith@stateuniversity.edu | State UniversityStudent | Likely student | |
| Alex Kim | alex.kim@rivalsoft.com | RivalSoftAccount Executive | Competitor or vendor | |
| Maria Garcia2 scans merged | maria.garcia@wingtip.io | Wingtip ToysCMO | A | |
| Chris Patel | chris.patel@@tailspin | Tailspin TravelEvents Lead | B | Invalid email |
Emails are checked for valid format only. This tool doesn't verify that a mailbox exists, so run a verification step before a large send.
Free, no sign-up. Your file is read and cleaned in your browser. It's never uploaded, saved or added to the page URL.
Next, send the follow-up: the event email templates include booth follow-up emails by lead grade.
How it works
Everything runs in your browser: the file is read on your device and the clean CSV is created there too. Nothing is uploaded or saved, so the leads in this tool aren't in the page URL either. The example shows a typical badge-scan export with the usual problems.
1. Columns are matched to standard fields
header name → first name, last name, full name, email, company, title, phone, address, grade or notes
Common names from lead retrieval apps and show exports are recognized (EMAIL, Full Name, Organization, Job Title, Rating). Qualifying questions are added to notes. Anything else is kept as its own column unless you drop it.
2. Each row is cleaned
trim spaces → fix ALL CAPS or lowercase → split full names → lowercase emails → standardize countries
Casing is only changed when a value is all capitals or all lowercase, so names like DeAndre or McKenzie stay as typed. Honorifics and suffixes (Mr, Dr, Jr, PhD) are removed when splitting names, and "Lee, Dana" becomes Dana Lee.
3. Rows are flagged
personal domain · .edu or student title · your competitor and vendor list · invalid or missing email
Flags are added to a column in the export, not used to delete anything, unless you tick a filter.
4. Duplicates are merged
same email, then same first name + last name + company
Merged rows keep the first row's values, fill gaps from the duplicates, keep the highest grade (A beats B beats C) and combine notes. A Times Scanned column shows how often each person was scanned.
When to use software instead: if you exhibit often, a lead retrieval app with qualifying questions and a native CRM sync avoids most of this clean-up. Compare options in lead retrieval apps and lead capture and retrieval.
For context: what the research says
Published figures on what happens to trade show leads after the show. More in our event marketing statistics.
49%
49% of marketers had delayed or lost follow-ups after a trade show or conference.
Source: Cvent, The 2026 Event-Led Growth Report (2026). Survey of 1,000+ marketers in the US and UK.
46%
46% of marketers report inconsistent lead capture at trade shows and conferences, and 47% end up with messy or incomplete lead data afterwards.
Source: Cvent, The 2026 Event-Led Growth Report (2026). Survey of 1,000+ marketers in the US and UK.
91%
97% of B2B event leaders say getting the right attendees is a priority, 92% are focused on demonstrating event ROI and 91% are looking to improve event follow-up.
Source: Forrester, The Global State Of B2B Events, 2025 (2025). 269 marketing professionals (Forrester Q1 2025 State Of B2B Events Survey).