Skip to content
Pitchlane

What does Pitchlane's Data Cleaning Do?

Pitchlane's CSV Data Cleaning

Updated

CSV Data Cleaning for Lead Data

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.

What the Cleaner Does

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:

  1. Handles empty values If a field is missing, it’s converted to an empty string.
  2. Trims extra spaces Leading and trailing spaces are removed.
  3. Strips HTML Tags like <div> or encoded characters like &nbsp; are removed.
  4. 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
  5. 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.
  6. Removes special characters Keeps only letters, numbers, and spaces in most free-text fields.
  7. Removes digits where not needed Numbers are removed from fields like names or titles.
  8. Removes invisible characters Zero-width or non-printing characters are cleared.
  9. Removes emojis Emoji characters are stripped out of the text.
  10. Collapses extra spaces Multiple spaces are reduced to one.
  11. Final cleanup A last trim removes any leftover edge spaces.

Example

Original (company field):

"https://example-company.com"

Cleaned:

"example company"

Original (email field):

"john.doe@example.com"

Cleaned:

"john.doe@example.com"  ← No change

How to Use It

  1. Enable CSV Cleaning when importing your Lead LIst.
  2. Upload your file.
  3. The cleaner runs automatically.
  4. Your cleaned CSV gets imported.

Notes

  • Only free-text fields are cleaned.
  • Structured fields like email, phone number, and website are left as-is unless clearly misused.