Person Name Splitter and Normalizer

Split names using stated token rules, with title, middle-name and suffix fields.

On-device No sign-up Free to use

Split names controls

Showing an example. Edit to see your own.

?

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.

Drop your CSV file here

or choose one from your device

One UTF-8 CSV or TSV whose first row holds the column names. The column named name or full name is used; otherwise the first column is read. Use either this or the pasted list.

    ?

    Leave empty to detect a name column, or name the column heading (or its 1-based number) from the file.

    ?

    Used only when a file is chosen, so a semicolon or tab export reads the same as a comma one.

    ?

    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.

    ?

    Applies a simple first-letter capitalization after lower-casing. This is a display heuristic, not a language rule.

    Processed in your browser. Your inputs stay on this device.

    Result

    Showing an example.

    Apply an explicit first-token rule.

    The rows contain Ada/Lovelace and Grace/Hopper, alongside their original full names.

    Loading the tool. Your result will appear here.

    https://usefreetools.net/person-name-splitter · 20 November 2026

    Was this helpful?

    How to use Person Name Splitter and Normalizer

    1. 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.
    2. 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.
    3. Leave Title-case output off to preserve capitalization, or enable the simple display heuristic.
    4. 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.

    You add
    Names: Ada Lovelace Grace Hopper. Rule: first token is given name. Capitalization: preserve.
    You get
    The rows contain Ada/Lovelace and Grace/Hopper, alongside their original full names.

    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.

    Page updated · Project managed by Tony Hines · Report a problem with Person Name Splitter and Normalizer