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.
| Pain | How this tool solves it |
|---|---|
| HubSpot / Salesforce imports require separate first/last name fields | Paste the name column, copy the family & given columns, and paste them back into your import sheet |
| Email tools need the family name for “Dear Mr. ◯◯” personalization | Use just the split family-name column as your merge field |
| Event or seminar attendee lists arrive as spaceless names like 山田太郎 | Kanji statistics split them automatically |
| Address-label and direct-mail software stores family and given names separately | Download the full-name / family / given CSV and import it directly |
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
| Input | Detected as | Family / Given |
|---|---|---|
| 山田 太郎 | Space separator (family first) | 山田 / 太郎 |
| 山田太郎 | Kanji statistics | 山田 / 太郎 |
| 勅使河原蒼佑 | Kanji statistics (long surname) | 勅使河原 / 蒼佑 |
| John Smith | Western order (family last) | Smith / John |
| ジョン・スミス | Western order (family last) | スミス / ジョン |
| やまだたろう | Low confidence | flagged for review |
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
| Action | Contents | Best for |
|---|---|---|
| Copy family & given columns | Two tab-separated columns, no header | Pasting next to the source column in a spreadsheet |
| Download CSV | Full name, family, given, with a header row | Keeping a standalone file or importing elsewhere |
Blank lines in your input are preserved as blank rows in both outputs, so pasted columns always stay aligned with your source list.
