Split full names into first and last

One name column in and two clean columns out.

Free for files up to 2,000 rows and 10 runs a day. Sign up for Dedupely to go further.

A Full Name column beside the First Name and Last Name columns it becomes, with Dr. and PhD set aside.

Handle the names a formula gets wrong

A text-to-columns split breaks on the second space. Maria van der Berg becomes three people. Dr and Jr end up as first names.

This tool keeps particles with the surname and sets prefixes and suffixes aside.

Fix the field the form got wrong

A web form sends one Name field. The CRM drops the whole name into First Name and leaves Last Name empty. The same person already has a record with it right.

Dedupely finds the record that already exists for that person and merges the two.

A web form submission with the whole name Maria van der Berg in First Name and Last Name empty, beside the contact record with the name split into the two fields.

Use it from a script or an AI agent

Use in Claude

POST https://dedupe.ly/tools/api/name-splitter
{ "names": ["Dr. Maria van der Berg PhD", "Crosby, Ellis"] }

MCP  https://dedupe.ly/tools/mcp   (tool: split_names)
Docs https://dedupe.ly/tools/api/openapi.json

OpenAPI document · API index · llms.txt