Mailfois
Tools / Data & lists / First & last name splitter
Free tool

First & last name splitter

Paste a column of full names and split each one into first name and last name, ready to drop back into your spreadsheet as two columns. Perfect for setting up personalisation. Runs in your browser; nothing is uploaded.

Input — full names
Output
Results will appear here…

Make Mailfois yours — save your favourite tools for quick access, store your presets and get early access to Pro.

Get early access →

Why split names for email

Personalisation lives and dies on clean data. If your list stores names as a single "full name" field, you can't send "Hi Jane" — the best you can do is "Hi Jane Smith", which reads like a form letter. Splitting full names into separate first and last name columns unlocks proper first-name personalisation, the single most common merge tag in email marketing.

How the split works

Each name is split on the first space. Everything before it becomes the first name; everything after becomes the last name. That rule keeps middle names and double-barrelled or multi-word surnames together in the last-name column, rather than dropping them. A name with no space is treated as a first name with a blank surname.

How to use it

Paste your column of full names, one per line. The tool splits them instantly into a two-column preview. Use Copy both to grab them tab-separated — paste that into a spreadsheet and it lands neatly across two columns — or copy the first or last names on their own. Everything runs in your browser, so your subscriber names are never uploaded.

Frequently asked questions

How do I split full names into first and last name?

Paste the names one per line; each splits on the first space into first and last name, ready to copy back.

What about middle names or double-barrelled surnames?

The split is on the first space only, so everything after the first name stays together in the last-name column.

Is my data uploaded?

No — it runs entirely in your browser and is never uploaded or stored.

Tidying data for a send? Pair this with the case converter and the list cleaner.

Every pre-send check in one place.

Open the pre-send checker