CleanMySheet guide
Split names in a CSV (Last, First and First Last)
Name splitting runs only on columns whose header looks like Name / Full Name (not City). Last, First becomes First + Last; First Middle Last uses the last token as surname. Original name is kept; new columns are inserted.
Name split will be in Review after scan.
Drop CSV or Excel here
Tap to choose a file. Parsing stays on this device.
Parsing stays on this device. Optional: drop a .cleanmysheet.json recipe with it.
Steps
- Upload contacts
- Apply Extract first/last name or the CRM Cleanup bundle
- Lock ID columns
- Export
We do not split San Francisco
Two-word cells are not assumed to be people. Targeting is header-based so product names and cities stay intact.
Related searches this page answers
- split names excel
- split full name csv
- first last name column