How to use Person Name Splitter and Normalizer
- Paste one full name per line, or choose a UTF-8 CSV/TSV file and identify its name column. A selected file supplies the names instead of the pasted list.
- Choose the splitting rule. The automatic option recognizes a limited list of titles and suffixes; fixed token and comma rules use the boundary you select.
- Leave Title-case output off to preserve capitalization, or enable the simple display heuristic.
- Compare original, title, given, middle, family, suffix and review columns. Correct exceptions before using the downloaded CSV as contact data.
Example: Person Name Splitter and Normalizer
Apply an explicit first-token rule.
Options
- Names (one per line)
- One full name per line, up to 1,000 lines. Formula-like exported cells receive an apostrophe prefix. Review the downloaded CSV in the spreadsheet where you will use it.
- Name column
- Leave empty to detect a name column, or name the column heading (or its 1-based number) from the file.
- File delimiter
- For name splitting, choose the separator between source text cells. An automatic choice, when offered, must still be checked against quoted and multiline values.
- Splitting rule
- The detected rule moves a leading title and a trailing suffix into their own columns and keeps middle names. The token and comma rules split on a fixed boundary instead.
- Title-case output
- Applies a simple first-letter capitalization after lower-casing. This is a display heuristic, not a language rule.
Supported inputs and limits
- This is a heuristic for supplied text, not a cultural or linguistic name parser.
- Choose token, comma or extended rules, and review compound family names manually.
- Extended rules recognize a limited title/suffix list.
- Title casing is optional and can alter intentional capitalization.
- The bounded CSV and input readers preserve source values; formula guards may prefix risky exported text.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
A text split is not an identity model
Compound family names, mononyms, prefixes and suffixes can make a token rule unsuitable. Original names remain in the report so you can compare the split and correct exceptions. Do not use the heuristic result as a verified legal-name record.
Questions about Person Name Splitter and Normalizer
Can the tool know which part is my family name?
No. You choose a rule for the supplied list, then review the result with the original name beside it.
What happens to a multiword family name?
With first-token splitting, the whole remainder stays in the family field. Other rules divide at different explicit boundaries.
Should I title-case every name?
Only after reviewing the result. Preferred capitalization and particles do not follow one universal rule.