How to Fix Salesforce INVALID_EMAIL_ADDRESS Errors on CSV Import

Why does Salesforce throw an INVALID_EMAIL_ADDRESS error on CSV imports?

Salesforce rejects rows with INVALID_EMAIL_ADDRESS when the email cell contains characters that violate RFC 5322 email syntax — most commonly a hidden leading or trailing space. The Data Import Wizard does not auto-trim, so it drops the entire record.

When spreadsheets are exported from other systems or edited in Excel, invisible whitespace is often appended or prepended to text fields. A single trailing space in an email cell (e.g., john@example.com ) looks identical to a valid address in a spreadsheet, but Salesforce's import validation engine treats the space character as a syntax violation. Since the RFC 5322 email specification does not permit spaces, Salesforce rejects the entire row and logs it in an errors file.

What is the fastest way to strip trailing spaces from a lead list before Salesforce import?

Drop the CSV into CleanCrumbs and it automatically trims leading and trailing whitespace from every email column, entirely in your browser, before you re-export a Salesforce-ready file.

CleanCrumbs processes your data with a Web Worker running locally on your device. You stay in complete control — no data is uploaded to a server. The tool applies these transformations automatically:

• Whitespace trimming on all fields, especially email and phone
• Email-keyed deduplication to merge duplicate contacts
• Name case normalization (fixes all-caps and lowercase issues)
• Character encoding repair for accented names and international characters

Does CleanCrumbs guarantee my lead data stays private during cleaning?

Yes. All processing runs inside a Web Worker in your browser. Raw file data never leaves your device — this is enforced by a strict Content Security Policy that blocks all outbound data connections.

CleanCrumbs is a privacy-first SaaS tool. Unlike traditional data-cleaning services that upload your lists to a server, all sanitization happens client-side. Authentication is handled by Clerk (which receives only session tokens, never your data), and your cleaned CSV is exported directly to your device. You can inspect our privacy policy for details.

Can I validate my cleaned data against Salesforce import rules before uploading?

Yes. CleanCrumbs includes a Salesforce NPSP readiness scan (available on the Pro plan) that validates your entire dataset against Salesforce's import rules before you upload.

The Pro plan ($29 one-time or $7.99/month) includes dedicated validation scans for Salesforce Nonprofit Success Pack (NPSP) and HubSpot. These scans check field formats, required fields, and known import blockers specific to each CRM. The scan results appear row-by-row so you can see exactly which records might fail import and why.

How CleanCrumbs fixes this in your browser

CleanCrumbs fixes this problem by automatically trimming whitespace, normalizing character encoding, and deduplicating your lead list before export. Because all processing runs locally in your browser using a Web Worker, your data stays private — no upload to a third-party server, no data-handling agreements to negotiate. You can scan your cleaned data against Salesforce NPSP import rules before re-exporting to confirm the import will succeed. Start free with up to 3,000 rows per file.