Built by

Marc

Marketing leader who got tired of cleaning bad data

Clean Your Marketing Lists.
Right in Your Browser.

Validate and fix contact data before uploading to Salesforce Marketing Cloud Account Engagement. No servers, no uploads—your data stays 100% private.

Uploading bad data to MCAE means bounced emails, broken automations, and wasted time fixing field errors. This tool validates your contact lists before import, catching issues like invalid emails, field length violations, and data quality problems—all processed securely in your browser.

Try the Validator

Comprehensive Data Validation

🔒

Completely Private

All validation happens entirely client-side in your browser using JavaScript. Your contact data never touches our servers, never gets uploaded to the cloud, and never leaves your computer.

The tool works offline once loaded, and you can even disconnect from the internet while validating sensitive lists. Perfect for compliance-heavy industries and organizations with strict data privacy requirements.

📧

Advanced Email Validation

Goes beyond basic format checking with RFC 5322 compliance validation plus intelligent quality checks:

Catches common typos (gmail.con → gmail.com, yahooo.com → yahoo.com)
Flags role-based emails (info@, admin@, noreply@, support@)
Detects disposable email domains (tempmail, guerrillamail, 10minutemail)
Identifies personal/free email providers for B2B filtering (Gmail, Yahoo, Hotmail)
Validates domain syntax and structure
Flags company domain mismatches (john@gmail.com claiming to work at Microsoft)

📏

Salesforce Field Compliance

Prevents import failures by enforcing Salesforce/MCAE field limits and requirements:

255 character limit enforcement on all text fields (First Name, Last Name, Company, Industry)
Required field validation (Email, First Name, Last Name, Company Name, Industry must be present)
Empty row detection and removal
Character encoding validation (UTF-8 compliance, smart quotes detection)
Whitespace normalization (trim leading/trailing spaces)

🎯

Data Quality & Integrity

Identifies problematic records that will cause issues downstream:

Fake entry detection ("test test", "asdf asdf", obvious placeholders)
Name validation (flags numbers in names, all caps, single characters)
Generic company name detection ("N/A", "test", "none", "unknown")
Duplicate email detection within your upload file
Company name normalization (Inc. vs Incorporated vs Inc)
Special character detection that could break imports

⚡

Bulk Editing & Auto-Fixes

Efficient correction tools for common issues:

Inline editing: Click any cell to fix errors on the spot
Bulk delete: Remove all invalid rows with one click
Auto-fix suggestions: Apply title case to names, correct common domain typos
Select and edit multiple records simultaneously
Filter by error type to tackle specific issues in batches
Sort by validation status to prioritize critical errors

📊

Detailed Reporting & Export

Clear insights into your data quality with multiple export options:

Summary dashboard: Total records, valid records, error breakdown by type
Color-coded data grid: Green (valid), yellow (warnings), red (critical errors)
Export clean records as MCAE-ready CSV (only validated data)
Error report CSV with detailed issue descriptions for each record
Combined export with validation status column added
UTF-8 BOM encoding for Excel compatibility

How It Works

Upload & Map

Drag and drop your CSV, XLS, or XLSX file (up to 100k rows). Use the column mapper to match your spreadsheet columns to the required MCAE fields: Email, First Name, Last Name, Company Name, and Industry. The tool remembers your mappings for future uploads.

Review & Fix

Instantly see validation results in an interactive data grid. Each error is clearly labeled with severity (critical vs warning) and specific details. Filter by error type, sort by any column, and edit records inline. Use bulk actions to fix multiple records at once or apply suggested auto-fixes.

Export Clean Data

Download your validated list as a clean CSV ready for immediate MCAE import. Optionally download an error report for any records that need manual review, or export everything with a validation status column for your records. All files are formatted to MCAE specifications.