How to split full name into first and last name columns
Your contact list has full names in one column, but your CRM needs first and last names separately. Splitting names manually takes forever and middle names make it tricky.
See it in action
Prompt
"Split full_name into first_name and last_name columns"
Before
| # | full_name | company | |
|---|---|---|---|
| 1 | Sarah Johnson | sarah@email.com | Acme Inc |
| 2 | Michael David Chen | mchen@work.co | Tech Corp |
| 3 | Dr. Emily Watson III | ewatson@med.org | City Hospital |
After
| # | first_name | last_name | company | |
|---|---|---|---|---|
| 1 | Sarah | Johnson | sarah@email.com | Acme Inc |
| 2 | Michael | Chen | mchen@work.co | Tech Corp |
| 3 | Emily | Watson | ewatson@med.org | City Hospital |
Why use Magic CSV for this?
- Automatically separate first, middle, and last names
- Handles prefixes, suffixes, and complex names
- Perfect for CRM imports and mail merges
Related guides
- Split Address into Columns
Split any address format into clean, separate columns
Ready to transform your data?
Upload your CSV, describe what you want, get clean data back.