Split full names into first and last name
Paste names or upload a CSV and this tool splits each full name into prefix, first, middle and last name, suffix and nickname. It handles titles like Dr, suffixes like Jr. and PhD, the Last, First order, and surname particles such as van or de la, and flags rows a person should check. It runs in your browser.
Sample result
Dr. Jane A. Doe Jr. splits into Dr., Jane, A., Doe and Jr.
- Name
- Dr. Jane A. Doe Jr.
- First / last
- Jane / Doe
- Prefix / suffix
- Dr. / Jr.
What this means for you
Clean first-name columns mean greetings like 'Hi Jane' instead of 'Hi Dr. Jane A.'.
- Prefix, first, middle, last, suffix, nickname
- Reads Last, First order
- Keeps van and de la with the surname
- Flags companies and one-word names
- Names
- Split
- CSV
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
How do I split full names into first and last name?
- Paste one full name per line, or upload a CSV with a column headed Name, Full Name or Contact. Other columns are kept. Files can be up to 25 MB.
- Leave the case option on to turn JOHN MCDONALD into John McDonald; names already in mixed case are never changed.
- Press Split names and read the Check column: one-word names, company names and email addresses are flagged rather than guessed at.
- Download the CSV with prefix, first_name, middle_name, last_name, suffix and nickname columns added.
Example
- You enter
- Two names:
Dr. Jane A. Doe Jr.andSmith, John. - You get
- Dr. Jane A. Doe Jr. splits into prefix Dr., first Jane, middle A., last Doe and suffix Jr.; Smith, John is read in Last, First order as first John, last Smith.
- Limits
- Built for Western name order. Runs in your browser with no row cap; an uploaded file can be up to 25 MB.
How do I split a full name into first and last name in Excel?
For simple two-word names, use =TEXTBEFORE(A2," ") for the first name and =TEXTAFTER(A2," ",-1) for the last, or Data, Text to Columns with a space delimiter. Both break as soon as a list has middle names, titles, suffixes or two-word surnames, which real lists always do.
Dr. Jane A. Doe comes out with Dr. as the first name; Martin Luther King Jr. with Jr. as the last; Ludwig van Beethoven with Beethoven as the surname. This tool reads the whole name instead: honorifics come off the front, generational and professional suffixes off the end, and particles such as van, von, de, de la, bin and al stay with the surname.
How are names written Last, First handled?
When a comma separates two parts, the part before it is read as the surname: Smith, John gives first name John and last name Smith. A comma that only introduces a suffix, as in John Smith, Jr. or Mr John Smith, PhD, is recognised as a suffix rather than a reversed name.
Nicknames in quotes or brackets, like Robert "Bob" Smith, go into their own column, so you can choose to greet people the way they introduce themselves.
Can every name be split into first and last?
No. Splitting by position assumes a given name first and a family name last, which isn't true everywhere. Chinese, Japanese, Korean and Hungarian names often put the family name first, many Indonesian and Burmese people have a single name, and Arabic names can carry several lineage parts. The W3C's guide to personal names around the world covers the variety.
So treat the split as a draft for mail merge, not a source of truth. Rows flagged in the Check column are the ones most likely to be wrong; for a greeting, the first_name column is what matters, and it's right far more often than the rest. If you collect names yourself, a single "what should we call you" field avoids the problem entirely.
Is this better than Text to Columns in Excel?
| Name | This tool | Text to Columns (space) |
|---|---|---|
| Dr. Jane A. Doe | Dr. | Jane | A. | Doe | Dr. | Jane | A. | Doe in four columns, no labels |
| Smith, John | John | Smith | Smith, | John |
| Ludwig van Beethoven | Ludwig | van Beethoven | Ludwig | van | Beethoven |
| Martin Luther King Jr. | Martin | Luther | King | Jr. | Four unlabeled columns |
Who uses this tool, and for what?
- Cold emailers
- Turn a scraped Full Name column into the {{first_name}} your sequencer needs, without greeting anyone as "Hi Dr."
- Event and webinar teams
- Split registration exports that only collected one name field before importing them into a CRM with separate first and last fields.
- CRM admins
- Fix records imported in ALL CAPS or Last, First order in one pass, and use the Check column to find the companies hiding in the contact list.
- Recruiters
- Prepare candidate lists for a personalised mail merge from an ATS export that stores the full name in one cell.
What can’t this tool tell you?
- Rule-based and written for given-name-first order; family-name-first, single and multi-part lineage names can be split wrongly.
- A two-word first name like Mary Ann is read as first and middle name.
- Initials and unusual titles not in the built-in list are treated as name parts.
- The case fix only applies to names written entirely in capitals or lower case, and can't know every spelling (Macdonald vs MacDonald).
Common questions
- How do I split a full name into first and last in Excel?
- For clean two-word names, =TEXTBEFORE(A2," ") gives the first name and =TEXTAFTER(A2," ",-1) the last. For real lists with middle names, titles, suffixes and Last, First order, save the column as CSV and split it here, then open the result in Excel.
- How do I split a full name in Google Sheets?
- =SPLIT(A2," ") puts each word in its own column, which works only when every name has exactly two words. To get consistent first, middle and last columns from messy names, paste the column here and copy the result back.
- What is the formula to split name and surname?
- In Excel 365, =TEXTBEFORE(A2," ") for the name and =TEXTAFTER(A2," ",-1) for the surname. In older Excel, =LEFT(A2,FIND(" ",A2)-1) and =RIGHT(A2,LEN(A2)-FIND(" ",A2)). All of them treat Dr., Jr. and van as name parts, so check the results.
- How do I split a full name into two cells?
- Press Split names above and download the CSV: first_name and last_name are separate columns, with middle names, titles and suffixes in their own columns so they don't end up in the wrong cell.
- How do I split a full name in SQL?
- Most databases can take the text before and after the first space, for example SUBSTRING_INDEX in MySQL or SPLIT_PART in PostgreSQL, but they share the formula's problems with titles and two-word surnames. Exporting the column, splitting it here and importing the result is usually more accurate.
Sources
A tidy list can still be full of dead addresses.
Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.
- Upload the cleaned file as it is: CSVs up to 100,000 rows
- A real SMTP mailbox check on every row, with catch-all detection
- Small list? $9 one-time covers 2,500 emails, no subscription
One plan, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.