Workflow · Clean · Opening soon

Split full names into first and last

Split the full name column into first and last name from your exported contacts file. Keep middle initials and name parts like de la, and flag rows that need a check.

Book a demo

Someone typed

“show every contact from the contacts file with first name and last name split from full name, dropping titles like mr., ms., dr., jr., and prof.; keep middle initials and last-name bits like de la, and a Status that says "Agrees" when the split looks right, else what's off”

The agent read it as

show every contact from the Contacts file with first name and last name split from full name, dropping titles like mr., ms., dr., jr., and prof.; keep middle initials and last-name bits like de la, and a Status that says "Agrees" when the split looks right, else what's off

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

File

Contacts

CSV export · 18 rows

Step

Split names

Step 1

Result

Split contact names

18 rows · 2 flagged

Schedule

Runs when you say

Proposed

File
Contacts
CSV export · 18 rows
Step
Split names
Step 1
Result
Split contact names
18 rows · 2 flagged
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 18 rows came out.

Download Contacts sample (18 rows)Spreadsheet: Contacts tab > File > Download > CSV

What you get back

The result of that run, the rows to look at first.

Split contact namesSample data18 rows

16 agrees1 check split1 missing name

Contact id	Full name	First name	Last name	Status
ct_0018	·	·	·	Missing name
ct_0013	Dr. Renée Du Bois	·	·	Check split
ct_0001	Dr. Evelyn Harper	Evelyn	Harper	Agrees
ct_0002	Ms. Priya Menon	Priya	Menon	Agrees
ct_0003	Mr. Thomas J. Caldwell	Thomas J.	Caldwell	Agrees
ct_0004	Ana María López	Ana María	López	Agrees
ct_0005	Jordan Lee	Jordan	Lee	Agrees
ct_0006	Prof. Samuel O'Connor	Samuel	O'Connor	Agrees
ct_0007	Nadia Hassan	Nadia	Hassan	Agrees
ct_0008	Mr. Miguel de la Cruz	Miguel	de la Cruz	Agrees
ct_0009	Lily Chen	Lily	Chen	Agrees
ct_0010	Avery Brooks	Avery	Brooks	Agrees

18 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you split the full name column into first name and last name?

Upload your exported contacts spreadsheet and run the name split step. It separates first name and last name, drops titles like Mr., Ms., Dr., Jr., and Prof., and keeps middle initials and last-name parts like de la. Each row gets a Status so you can see what looks right and what needs a check.

How it works

How to use the Split contact names workflow

1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Split contact names: questions

What file should you export for this workflow?

Export the spreadsheet that has your contacts and a full name column. Use the file that holds the names you want to split, then upload it to the workflow.

What happens to rows that do not fit the split rule?

Those rows stay in the output and get marked for review. The Status field shows what looks wrong, such as a missing name or a split that needs a check.

How do you change the name-split rules?

Edit the rule text to say which titles to drop, which name parts to keep, and how to handle special cases. Then run the workflow again on the same exported file or a new one.