Format customer names into clean Title Case with cultural name handling
Transform SHOUTING all-caps or all-lowercase names into natural Title Case with cultural naming rule support.
🛡️ Your rows never leave your browser.
Why Onfyt: Processes fix name capitalization entirely in-browser with dedicated Web Workers so your rows never leave your machine.
Interactive Sample Data
| id | raw_name | |
|---|---|---|
| 1 | JOHN MWANGI | john@example.com |
| 2 | jane muthoni-kariuki | jane@sample.ke |
| 3 | PETER MCDONALD | peter.m@corp.com |
| 4 | ALICE O'REILLY | alice@irish.org |
How this tool works
Customer contact databases frequently suffer from inconsistent name capitalization. Users typing on mobile devices often enter their names in all-lowercase ("john mwangi"), while administrative databases frequently store records in aggressive SHOUTING ALL-CAPS ("JOHN MWANGI"). Sending personalized emails that address recipients as "Dear JOHN" or "Dear john" looks unpolished and signals automated bulk outreach.
Applying a basic spreadsheet Title Case formula (=PROPER) is better than nothing, but it routinely corrupts culturally specific naming conventions:
- Celtic names: =PROPER("MCDONALD") produces "Mcdonald" instead of "McDonald".
- Irish apostrophes: =PROPER("O'CONNOR") produces "O'connor" instead of "O'Connor".
- Hyphenated compound names: =PROPER("ANNE-MARIE") often fails to capitalize the letter after the hyphen.
- European noble particles: =PROPER("VAN DER BILT") produces "Van Der Bilt" instead of the culturally correct "van der Bilt".
This tool applies rule-based name casing algorithms:
- Converts ALL CAPS and all-lowercase names to natural Title Case.
- Corrects capitalization following "Mc", "Mac", and "O'".
- Capitalizes both halves of hyphenated names ("Muthoni-Kariuki").
- Optionally preserves lowercase particles (van, de, da, von, bin).
All processing executes locally in your browser sandbox via Web Workers. Your customer records remain confidential on your device.
From a brand reputation perspective, addressing customers with proper name capitalization in transactional emails and billing invoices establishes trust. Using basic spreadsheet Title Case formulas (=PROPER) corrupts culturally specific naming conventions—such as turning "McDonald" into "Mcdonald" or "O'Connor" into "O'connor". DataFix applies cultural capitalization heuristics that preserve Celtic prefixes, Irish apostrophes, hyphenated compound names, and European noble particles.
From a data security and regulatory standpoint, customer directories and employee rosters contain sensitive personal information that must remain protected. Uploading name lists to public web formatters violates internal compliance guidelines. With DataFix, all name capitalization logic runs locally within your browser sandbox via Web Workers, ensuring that customer identities remain completely confidential.
In personalized direct mail and high-touch enterprise sales outreach, proper name capitalization sets the tone for professional interactions. Receiving an automated cold email addressed to "HI JOHN" or "Dear jane" directly signals impersonal bulk outreach. By applying cultural name capitalization rules that respect prefixes (Mc, Mac, O'), hyphenated surnames, and international particles, sales teams ensure that automated email sequences read like thoughtful, personalized communications written by real professionals.
Things that usually go wrong
- Corrupting "McDonald" to "Mcdonald": Excel's =PROPER formula lowers the D. DataFix explicitly detects Mc prefixes and capitalizes the third letter.
- Hyphenated Surnames Missing Capital: Names like "muthoni-kariuki" should become "Muthoni-Kariuki". DataFix capitalizes after hyphens.
- Roman Numerals (III, IV): Suffixes like "John Smith III" get converted to "Iii" by naive formatters. DataFix preserves uppercase Roman numerals.
Edge cases we tested
🧪 Empty cells or missing values
Safely handled without schema corruption.
🧪 Leading or trailing cell whitespace
Sanitized prior to processing.
🧪 Large files with 25,000+ rows
Streamed via client-side Web Worker without tab freezing.
🧪 All-caps name with Mc prefix: "MCDONALD"
Capitalised to "McDonald" (Mc prefix preserved), not "Mcdonald" (naive title-case).
Frequently Asked Questions
How does it handle names with apostrophes like O'Connor?
It capitalizes the letter immediately following the apostrophe (O'Connor, D'Angelo).
Does it support hyphenated compound names?
Yes! Both sides of hyphens are properly capitalized (e.g. Mary-Ann, Muthoni-Kariuki).
Can it preserve lowercase particles like "van der"?
Yes. You can toggle the preservation of Dutch, German, and French surname particles.
Is my customer list private?
Your rows never leave your browser. All processing runs in a JavaScript Web Worker inside this tab.
Related tools
Clean
Split Full Name into First and Last
Separate full name columns into dedicated first_name and last_name columns in CSV and Excel spreadsheets.
Open Tool →
Clean
Change Text Case
Transform column text into UPPERCASE, lowercase, Title Case, Sentence case, or camelCase across your spreadsheet.
Open Tool →
Clean
Combine First and Last Name
Merge separate first and last name columns into a single clean full_name column, trimming extra spaces.
Open Tool →