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 data

Upload 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
Loaded: Example badge-scan export, 10 rows, 11 columns

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.

Remove from the export

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.

NameEmailCompany and titleGradeFlags
Dana Lee2 scans mergeddana.lee@northwind-analytics.comNorthwind AnalyticsVP of MarketingA
Chidi Okaforchidi.okafor@gmail.comBrightline LabsField Marketing ManagerBPersonal email
Ana de la Cruzana.delacruz@contoso.co.ukContoso (from domain)Head of EventsB
Tom O'Brientom.obrien@fabrikam.comFabrikamSenior Director Demand GenC
Jordan Smithjordan.smith@stateuniversity.eduState UniversityStudentLikely student
Alex Kimalex.kim@rivalsoft.comRivalSoftAccount ExecutiveCompetitor or vendor
Maria Garcia2 scans mergedmaria.garcia@wingtip.ioWingtip ToysCMOA
Chris Patelchris.patel@@tailspinTailspin TravelEvents LeadBInvalid 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).

FAQ

How do I clean up a lead list after a trade show?
Export the scans from your lead retrieval app as a CSV, then fix the basics before import: trim spaces, fix ALL CAPS names, split full names, lowercase emails, remove duplicate scans and flag competitors, students and personal emails. This tool does all of that in your browser and gives you a file with HubSpot or Salesforce column names.
How do you remove duplicate leads from a CSV?
Match on email first, since it's the most reliable key, then on first name, last name and company for rows with a missing or different email. When two rows match, keep one and merge the rest into it: fill empty fields, keep the highest lead grade and combine the notes, so nothing a booth rep wrote down gets lost.
Should I remove Gmail and other personal email addresses from my lead list?
Usually not. Plenty of real buyers scan in with a personal address, especially at shows where registration asks for any email. Flag them instead, so sales knows to confirm the company, and keep them out of account-based routing that depends on a business domain. Remove them only if your CRM rules require a work email.
Is it safe to upload my lead list to this tool?
Nothing is uploaded. The file is read and cleaned by JavaScript in your browser tab, and the clean CSV is created on your device. No names, emails or notes are sent to our server or anyone else, and nothing is saved after you close the page. You can even disconnect from the internet once the page has loaded.
What columns does HubSpot need to import contacts?
HubSpot needs at least an email or a first and last name to create a contact. Using its default property labels (First Name, Last Name, Email, Company Name, Job Title, Phone Number) lets the importer match columns automatically. Custom columns such as event notes or lead grade need an existing or new property to map to during import.
Does this tool verify email addresses?
No. It checks that each email is formatted correctly and fixes common problems like stray spaces, capital letters and mailto prefixes, but it can't tell whether a mailbox exists. That would need a paid verification service. If the list is large or old, run it through your email platform's verification step before sending.