First & Last Name Splitter
Free First & Last Name Splitter: split names into first, middle and last-name columns, including comma-order names and common surname particles.
"Last, First" order is detected automatically, and particles like van or de stay with the surname.
| First | Middle | Last |
|---|---|---|
| Ada | Byron | Lovelace |
| Grace | Hopper | |
| Martin | Luther | King |
| Ludwig | van Beethoven |
How it works
In Excel or Google Sheets, split names into first, middle and last-name columns, including comma-order names and common surname particles.
Paste one full name per line, using either natural order or `Last, First Middle` order.
Review the first, middle and last-name columns, especially compound names and suffixes.
Copy the tab-separated output and paste it into adjacent spreadsheet columns.
What this does
The splitter accepts one name per line. It recognizes both natural order and `Last, First Middle` order, keeps common particles such as van or de with the surname, and adds a middle-name column when at least one row contains a middle part.
A worked example
Enter `Ludwig van Beethoven`. The output is first name `Ludwig` and last name `van Beethoven`. With this input alone, no middle-name column appears. Names do not follow one universal structure. Check titles, suffixes, compound given names and unfamiliar particles before using the output as a final name list.
Common mistakes
- Treating every final word as a complete surname; recognized particles are kept with the last name.
- Assuming titles and suffixes have universal positions; review those rows manually.
- Mixing multiple people on one line, which the tool treats as one name.
FAQ
Does the splitter handle `Last, First` order?
Yes. Text before the first comma becomes the last name; text after it supplies the first and optional middle names.
What happens to surname particles such as van or de?
Recognized particles immediately before the surname stay in the last-name column.
Why is there sometimes no middle-name column?
The middle-name column appears only when at least one entered name has a middle part.
Related guides
Built in your browser when you click. Nothing is uploaded, no signup, free for commercial use.