Got a big list of email addresses and no names? This tool is for you.
This tool extracts the first name and last name from an email address and outputs it in separate columns. It’s super useful when you’ve been given a list of corporate emails but no first name and last name but want to send an email with a “Hi {name}” opening. It also works if you want to update your CRM but didn’t collect a name on the form.
Used 15 times
(Of course, if the email address is something like cooldude84@gmail.com then no amount of sourcery is going to find the person’s name!)
Discovered any problems with this tool? Let me know in the comments!
How it works
Paste your list
One email per line, or paste a column straight from a spreadsheet.
Check the guesses
Rows worth a look are flagged: initials, single words and role addresses. Click any name to edit it, or fix ticked rows in bulk.
Copy or download
Copy pastes straight into a spreadsheet as columns. The CSV opens cleanly in Excel, accents included.
Questions
How does it work out the name?
It splits the part before the @ on dots, underscores and hyphens, drops numbers and +tags, then capitalises each part. It handles double-barrelled names like Mary-Jane, prefixes like McDonald and multi-word surnames like Van Dijk.
What about addresses like asmith@ or poleary@?
With no separator the tool can't tell where the first name ends. Tick those rows and use "Asmith → A Smith" or "Oleary → O'Leary" to fix them in one go.
Why are some names blank?
Addresses like info@ or sales@ belong to a team, not a person, so there's no name to extract. They're flagged as role addresses.
Is my list uploaded anywhere?
No. Everything runs in your browser, so your emails are never sent to this website or anyone else. Close the tab and they're gone.