What is the “Split full names” tool?
“Split full names” is a free tool that splits a list of full names into family name and given name in one batch, including spaceless Japanese names like 山田太郎, which are split automatically using statistics on which kanji appear in surnames.
Problems this solves
You are about to import a lead list into HubSpot or Salesforce, but the CRM wants separate first-name and last-name fields while your list has full names joined in a single column. Instead of splitting every row by hand in Excel, paste the column here and get two clean columns back in seconds.
How it works
Each line is treated as one full name and split by the first rule that matches:
- Explicit separator: a space (half- or full-width) splits the name directly, family name first:
山田 太郎→ 山田 / 太郎. - Western names: Latin-script names are split at the last word, family name last:
John Smith→ Smith / John. Katakana names joined with・follow the same order. - Kanji statistics: spaceless Japanese names are split at the most likely boundary based on how often each kanji appears in family names versus given names.
Rows the tool cannot split confidently are highlighted as needs review, so a rare surname never slips through silently.
What each input pattern produces
Steps
- Paste your list of names, one full name per line (a column copied from Excel works as is).
- Press Split. The first run loads the splitting dictionary; after that, results update live as you type.
- Check any highlighted rows; those are the ones the tool was not confident about.
- Press Copy family & given columns and paste next to your original column in Excel or Google Sheets, or download the full result as CSV.
When to copy vs. download
Blank lines in your input are preserved as blank rows in both outputs, so pasted columns always stay aligned with your source list.
