Name cleaner

Fixes casing, strips honorifics, credentials and emojis, splits first and last names and flags entries that are not names.

12 names, one per line
Runs in your browser. The list never leaves your device.
Ken cleans names on every list you import.
No more "Hi JOHN," or "Hi Sales Team," in a first line.
Start free - 1,000 credits, no card

What the name cleaner does

It turns the name in your export into the name you would write after "Hi". "JOHN SMITH, MBA 🚀" becomes John and Smith.

  • Strips prefixes such as Dr., Mr. and Ms.
  • Strips suffixes and credentials: Jr., III, PhD, CPA, MBA, PMP.
  • Removes emojis, pronouns in parentheses and nicknames in quotes.
  • Fixes casing with the usual exceptions: McDonald, O'Brien, van der Berg.
  • Splits a full name into first and last when the export merged them.

How to read the result

Each row shows the original, the cleaned first name and the cleaned last name. Rows that do not look like a person, such as "Sales Team" or "Accounts Payable", are flagged as non-names. Those are almost always role inboxes and should not get a first-name greeting.

How to use it

Paste a list with one name per line, or drop a CSV and pick the name columns. If the export has separate first and last columns, map both. If it has one full-name column, map that and the tool splits it. Download the cleaned file with the new columns next to the originals, then send flagged non-names to a different template or drop them.

Why it matters for cold email

The greeting is the first thing the reader sees in the preview. "Hi JOHN,", "Hi Dr. Jane Doe PhD," and "Hi Sales Team," each say the email came from a list, and that ends the read before your first sentence. LinkedIn and data vendor exports carry these problems in a share of rows on almost every list, so the pass is worth running every time.

Questions

How do I fix names in all caps?
Paste them here. The cleaner converts to normal case and keeps the exceptions a plain PROPER() formula gets wrong: McDonald, O'Brien, and particles like van, de and von, which stay lowercase in the middle of a name.
How do I split a full name into first and last name?
Map the full-name column and the cleaner splits it after removing prefixes, credentials and emojis, so "Dr. Jane van der Berg, PhD" gives Jane and van der Berg. Multi-part last names stay together.
What does it do with nicknames?
A nickname in quotes or parentheses, as in Robert "Bob" Smith, is removed from the first name, so the greeting uses the name the person put first. If you would rather greet by the nickname, check those rows in the result before you download.
Why does it flag some rows as non-names?
Because the value describes a team or a function, not a person: Sales Team, Info, Accounts Payable, Customer Service. Greeting those by first name reads badly, and they usually sit on role addresses that rarely reply.
Does it work for names outside English?
Casing and splitting work on any Latin-script name, and accented letters are kept. Name order is assumed to be first then last. For lists where family name comes first, check the split before you send.

More in CSV tools

14 tools.