← Pivotal-Hub pivotalpath.co.uk ↗
Office · Data

Contact List Cleaner

Paste a messy pile of names, emails and phone numbers. Get back one tidy, deduplicated list. Cleaning happens in your browser — your contacts never leave your machine.

When would I use this?

Someone hands you “the mailing list”: half a spreadsheet export, a few lines copied from emails, and a colleague’s phone notes — SHOUTING names, Last, First entries, the same person in there three times with three phone formats. Paste the lot here and it becomes one clean table: duplicates merged, names properly cased and split, phones tidied — ready to download as a CSV or paste straight into a BCC field. Nothing is uploaded anywhere; it all happens on your computer.

01 Paste your messy list

Runs entirely in your browser — nothing is uploaded.
…or drop a file here, or click to browse
.txt or .csv? · read locally, never uploaded

02 Options

Dedupe by?
Name cleaning
Phone format
Good to know

Honorifics (Mr / Dr…) are dropped, extensions like “ext. 12” are stripped, and a first line that looks like a header row (“name, email, phone”) is used to map columns, then skipped. Phones that can’t be parsed pass through unchanged with a flag.

03 Clean contacts

Paste contacts above — the cleaned list appears here automatically.
Nothing to clean yet. Paste a list, drop a file, or hit “Try an example”.
Excel-friendly adds a UTF-8 BOM? so accents survive the trip. “Copy emails only” gives a deduped, comma-separated list ready for a BCC field.