When you upload lead data in a CSV file, you have the ability to clean your data. The cleaner removes unnecessary or unwanted content from text fields. This helps standardize the data for outbound messaging and other workflows.
The cleaner processes each row in your CSV and targets free-text fields like names, job titles, and company names. It avoids making changes to structured fields such as email addresses or phone numbers unless clear adjustments need to be made.
Here’s what it removes or adjusts in those free-text fields:
Handles empty values
If a field is missing, it's converted to an empty string.
Trims extra spaces
Leading and trailing spaces are removed.
Strips HTML
Tags like <div> or encoded characters like are removed.
Removes URLs from text fields
If a URL is mistakenly placed in a company name or job title, it is stripped out.
Example: https://company.com → company
Removes email addresses from text fields
If an email address appears in a field like first_name, it will be removed.
Email fields themselves remain untouched.
Removes special characters
Keeps only letters, numbers, and spaces in most free-text fields.
Removes digits where not needed
Numbers are removed from fields like names or titles.
Removes invisible characters
Zero-width or non-printing characters are cleared.
Removes emojis
Emoji characters are stripped out of the text.
Collapses extra spaces
Multiple spaces are reduced to one.
Final cleanup
A last trim removes any leftover edge spaces.
Original (company field):
"https://example-company.com"Cleaned:
"example company"Original (email field):
"john.doe@example.com"Cleaned:
"john.doe@example.com" ← No changeEnable CSV Cleaning when importing your Lead LIst.
Upload your file.
The cleaner runs automatically.
Your cleaned CSV gets imported.
Only free-text fields are cleaned.
Structured fields like email, phone number, and website are left as-is unless clearly misused.