Free Name Splitter

Split a full name into first, middle and last name — one at a time or a whole list at once. Handles titles, suffixes and comma format, free and with no signup.

Enter a full name

Split any full name into first, middle and last — one at a time or a whole list at once. 100% in your browser: your names are never uploaded.

How it works

1

Pick a mode

Choose a single name, or bulk to split a whole list at once.

2

Enter the names

Type one full name, or paste a column of names, one per line.

3

Split

Get the first, middle and last name — titles and suffixes separated out.

4

Copy or export

Copy a part, copy the table as TSV, or download the CSV.

Split a full name into first and last name

A name splitter separates a full name into its parts: first name, last name, and anything in between. This tool reads the whole name and works out which token is which — so 'Mary Jane Watson' becomes first name Mary, middle name Jane, last name Watson.

It handles the awkward cases plain formulas miss. Two-word and particle surnames like 'van Beethoven', 'de la Cruz' and 'von Humboldt' are kept together as the last name. Names written 'Last, First' are detected by the comma and swapped back. Honorifics (Mr, Mrs, Dr, Prof) are pulled into a prefix, and generational or post-nominal suffixes (Jr, Sr, III, PhD, MD) into a suffix — so your first and last name fields stay clean.

Split names in a spreadsheet — Excel or Google Sheets

The usual way to split full names in Excel or Google Sheets is a formula (LEFT/RIGHT with FIND, or SPLIT) or Text to Columns. Both split purely on position or the space character, so a middle name, a two-word surname or a 'Last, First' entry quietly lands in the wrong column.

Skip the formulas: switch to bulk mode, paste your whole name column, and the tool splits every row correctly. Copy the result as TSV to paste straight into first / last columns, or download a CSV — no FIND, LEFT, RIGHT or Text to Columns required.

Clean your lead list before you personalize

First-name accuracy is what makes personalization work. If your merge tag pulls 'Dr. Maria' or 'van Beethoven' into the greeting, an outreach email opening with 'Hi {{first_name}}' instantly reads as automated — and gets ignored or marked as spam.

Split your list here first so every {{first_name}} is just the first name, then put it to work: build a sequence with the follow-up email generator or start from proven cold email templates.

Common questions about splitting names

How do I split a full name into first and last name?


Paste the full name into the tool and it instantly separates the first and last name (plus any middle name, title or suffix). For a whole column of names, switch to bulk mode, paste one name per line, and download the split first / last columns as a CSV.

How does the tool handle middle names, two-word last names and 'Last, First'?


A middle name is anything between the first and last name. Two-word or particle surnames like 'van Beethoven', 'de la Cruz' or 'von Trapp' are kept together as the last name. And when a name is written 'Smith, John' the tool detects the comma and swaps it back to first name John, last name Smith.

Can I split a whole list or CSV of names at once?


Yes. Switch to bulk mode, paste one full name per line (up to 10,000), and the tool returns a first / middle / last table. Copy it as TSV straight into a spreadsheet, or download it as a CSV. It's the fast way to split a name column without writing formulas.

How do I split names in Excel or Google Sheets?


The classic way is a formula or Text to Columns, which breaks on middle names and two-word surnames. Instead, paste your name column here, let the tool split it correctly, then copy the first / last columns back into your sheet — no formula required.

Does it handle titles like Dr. and suffixes like Jr. or PhD?


Yes. Leading honorifics (Mr, Mrs, Ms, Dr, Prof) are pulled into a prefix field, and trailing suffixes (Jr, Sr, II, III, IV, PhD, MD) into a suffix field, so they never get mixed into the first or last name.

Is my list of names uploaded anywhere?


No. The entire tool runs in your browser with JavaScript — your names are never sent to a server, uploaded or stored. You can even use it offline once the page has loaded.

Ready to 10x your pipeline?

Send your first cold email campaign today, risk-free.

Try for free