Free tool
Split a Full Name column into First + Last.
CSVTidy detects your name column and creates 'First Name' and 'Last Name' columns beside it. It handles honorifics (Dr., Mrs.), suffixes (Jr., III), and the 'Doe, John' comma-separated form.
Everything runs in your browser. Nothing is uploaded.
Drop a CSV or Excel file here
Or choose a file — nothing leaves your browser.
After you drop a file, you'll see the Split name column action highlighted for you.
Common questions
How does it handle middle names?
Middle names go into the First Name field. That matches most CRM imports (Salesforce, HubSpot). If you need a separate Middle column, use the AI custom rules coming to Pro.
What about 'Doe, John'?
When the first token ends with a comma, it's treated as the last name and the remainder becomes the first name.
Are single-word names handled?
Yes. A single-word entry goes into First Name; Last Name is left blank.