Clean, standardize, and dedupe your CRM data

CRM Data Cleaner is an Excel tool that turns messy contact exports into clean, import-ready data — no formulas, no manual fixes.

Pay once, use it forever. No subscriptions, no renewals.

Every version cleans

Click any type for the full detail. The tool auto-suggests fixes wherever it can — you review and approve each one.

Emailscase, typos, validation, fakes▼

Far more than lowercasing. Each address gets a status (Valid, Typo, Invalid, Fake, Disposable, Multiple, Empty) with a suggested fix when possible:

Case & whitespace — lowercases and trims stray spaces.
Typo correction — 59 common domain misspellings across Gmail, Yahoo, Outlook, Hotmail, AOL, and iCloud.
Validation — flags malformed addresses (missing @, no domain, bad structure).
Fake detection — catches placeholder junk like test@test.com, asdf@asdf.com.
Disposable detection — flags throwaway inbox domains.
Multiple emails — keeps the first, moves extras to their own column.

JOHN@GMAIL.COM → john@gmail.com
dg@gmial.com → dg@gmail.com (Typo)
sue@hotmial.com → sue@hotmail.com (Typo)
test@test.com → flagged Fake
bob@x.com; sue@y.com → bob@x.com + 1 more

Phone numbers10-country formatting▼

Standardizes numbers to the format you choose, with country-aware detection for US, UK, Germany, France, Mexico, Brazil, India, Japan, China, and Australia.

Format styles — (555) 123-4567, 555-123-4567, 555.123.4567, or +15551234567.
Default country — fallback for numbers with no prefix; a Country column takes priority if present.
Country code column — optionally split the detected code into its own column.

5551234567 → (555) 123-4567
5551234567 → 555.123.4567
5551234567 → +15551234567
+44 20 7946 0958 → CC: +44 | 020 7946 0958

Namescase, split, merge, titles, suffixes▼

Handles names in whatever shape your data arrives — one full-name column or separate first/last.

Proper casing — fixes ALL CAPS or lowercase (optional; preserve intentional casing if you prefer).
Split full names — break “Dr. Jane Smith III” into Title / First / Last / Suffix columns.
Merge — combine First + Last into one Full Name column (handy for CRMs like Pipedrive).
Titles — Dr., Mr., Mrs., Ms., Miss, Prof., Rev., Hon., Sgt., Capt., and more.
Suffixes — Jr., Sr., II, III, IV, Esq., PhD, MD, DDS, CPA, and more.

john SMITH → John Smith
Dr. Jane Smith → Dr. | Jane | Smith
James Wilson III → James | Wilson | III
First: john + Last: SMITH → Full: John Smith

Datesauto-detect, reformat, time handling▼

Turns a column of inconsistent dates into one uniform format.

Auto-detection — reads mixed input formats automatically.
Ambiguity resolution — set MDY / DMY / YMD so 03/04/2024 is never guessed wrong.
Target formats — YYYY-MM-DD, MM/DD/YYYY, DD/MM/YYYY, MM-DD-YYYY, or “March 15, 2024”.
Time handling — strip the time, move it to its own column, or keep it inline.

03/15/2024 → 2024-03-15
March 15, 2024 → 2024-03-15
15/03/2024 (DMY) → 2024-03-15
2024-03-15 14:30:00 → Date: 2024-03-15 | Time: 14:30:00

Addressesparse, split, multiple formats▼

Parses free-form addresses and outputs them the way your destination needs.

Output formats — separate Street/City/State/ZIP columns; Street + combined City-State-ZIP; a single full-address column; or normalize-only.
Apt/unit splitting — pulls Apt, Unit, Suite, Ste, #, Bldg, Floor, Rm, Dept, and more into a separate column.
ZIP handling — keep as 5-digit ZIP or preserve ZIP+4.

123 Main St Apt 4B, Springfield IL 62704-1234
→ Street: 123 Main St  Apt: 4B
→ City: Springfield  State: IL
→ ZIP: 62704  (or 62704-1234)
or → single: 123 Main St Apt 4B, Springfield, IL 62704

Duplicatesfind & remove by any field▼

Find and remove duplicate records based on whichever field matters to you.

Match on any column — email, phone, name, or any field in your data.
Review groups — see matched records grouped together before anything is removed.
Keep one, remove the rest — clear out the extras based on your chosen match column.

3 rows with john@gmail.com → review group, keep 1, remove 2
match on Phone → same number across rows grouped & deduped

Free

Try the whole thing on small data.

no card needed

Includes

✓ All cleaning tools
✓ All 5 CRM exporters
✓ Find & remove dupes

Capped at 100 rows for both cleaning and exports.

Download free

CRM Data Cleaner

Clean and dedupe unlimited data. Export your cleaned file and import it wherever you need.

$99

pay once · 2 computers

Unlimited

✓ Email, phone, name, date, address cleaning
✓ Find & remove duplicates
✓ Export your cleaned data as Excel or CSV

Buy $99