The Name Splitter utility helps you split full names in your spreadsheet into separate "First Name" and "Last Name" columns using multiple algorithms. This is useful when you have a single "Name" field but need to separate it into components.
| Algorithm | Description | First Name Column | Last Name Column | Salutation Column |
|---|---|---|---|---|
| SplitBySpace | Splits by first space: 'Alice Smith' → First='Alice', Last='Smith' | SplitBySpace_FirstName |
SplitBySpace_LastName |
SplitBySpace_Salutation |
| SplitByLastSpace | Splits by last space: 'Alice B. Smith' → First='Alice B.', Last='Smith' | SplitByLastSpace_FirstName |
SplitByLastSpace_LastName |
SplitByLastSpace_Salutation |
| SplitByParentheses | Extracts from parentheses: 'Alice (Annie) Smith' → First='Alice', Last='Smith', Salutation='Annie' | SplitByParentheses_FirstName |
SplitByParentheses_LastName |
SplitByParentheses_Salutation |
| SplitByParenthesesNickname | Uses nickname in parentheses: 'Alice (Annie) Smith' → First='Annie', Last='Smith', Salutation='Annie' | SplitByParenthesesNickname_FirstName |
SplitByParenthesesNickname_LastName |
SplitByParenthesesNickname_Salutation |
| SplitByAnd | Splits by 'and': 'Alice and Bob Smith' → First='Alice and Bob', Last='Smith' | SplitByAnd_FirstName |
SplitByAnd_LastName |
SplitByAnd_Salutation |
| SplitByAndFirstOnly | Takes first name before 'and': 'Alice and Bob Smith' → First='Alice', Last='Smith' | SplitByAndFirstOnly_FirstName |
SplitByAndFirstOnly_LastName |
SplitByAndFirstOnly_Salutation |
| SplitByHyphen | Splits by hyphen: 'Alice-Smith' → First='Alice', Last='Smith' | SplitByHyphen_FirstName |
SplitByHyphen_LastName |
SplitByHyphen_Salutation |
If you have a column called "Name" with values like "Alice Smith", "Smith, Alice", or "Alice (Annie) Smith", the tool will create multiple columns showing how each algorithm splits the name. Text in parentheses will be extracted to the Salutation column (e.g., "Jack (Jackie) Smith" becomes First="Jack", Last="Smith", Salutation="Jackie"). You can then choose which algorithm works best for your data.
🔒 Privacy First: Your data is never stored. Files are processed in memory and immediately deleted after conversion.
Tip: Make sure to enter the exact name of the column as it appears in your spreadsheet headers.