Split name in a cell into multiple cells and auto-detect its parts.
Listing updated:July 5, 2024
Works with:
1M+
Overview
If you ever need to split first and last names to different columns, this add-on will become a great assistant. It distincts first, last, middle names and recognizes over 80 titles and 40 post-nominals. It doesn't matter how these parts are arranged – Split Names pulls correct units from any name combinations.

With names like "Dumbledore, Albus Percival, Prof." the standard "Split text to columns" Google feature won’t help much since it pulls out name units one by one by a delimiter. Our tool detects all parts at once and separates names to corresponding cells in a click. 

The benefits of the tool are enjoyable:
  • Splits full names in Google Sheets
  • Tells the difference between first, last and middle names
  • Recognizes over 80 titles and 40 post-nominals (Mr and Mrs, MD, Prince, etc.)

The utility will insert columns with name units next to the original one. You can keep your table structure by considering or ignoring headers.

Run this tool to divide multi-part names into separate columns they belong to: first, middle, and last names, titles and post-nominal letters. Splitting names in Google Sheets is that easy!

30 DAYS OF FREE USE
Fully functional 30-day trial period. All payments are secure and include an unconditional 30-day money-back guarantee.

If you have any questions about the add-on, please post them here:
https://www.ablebits.com/docs/google-sheets-split-names/
We'll be happy to assist!

Split Names is a proud member of the Ablebits product family. We build add-ons that help you make the most of Google Workspace. Visit our official website to learn more:
https://www.ablebits.com/google-sheets-addons.php
–––––––––––––––––––––––––––––––––––––
WHAT'S NEW:
***** V1.12 (20 Sep 2023) *****
Fixed:
- Didn't recognize 'De' as part of the last name unless written in lowercase.
- Didn't recognize 'Daisy' as a first name.
- Minor UX and UI fixes.

***** V1.11 (21 Jul 2022) *****
Improved:
- The limit for total cells in a spreadsheet is expanded to 10 million cells.
- Minor UX and UI improvements.

Fixed:
- Couldn't split some names if last names were written in all caps.
- Didn't always recognize Jr. as a name suffix.

***** V1.10 (5 May 2021) *****
Fixed:
- If the names to split were located in the AA column or further, the split parts were inserted into A-Z columns.
- Didn't work with small ranges without headers that started from the A1 cell.
- Errored if your 'Data validation' rules prevented the tool from returning the split name units.
- Didn't work if you run the add-on from a sheet with its own separate chart.

***** V1.9 *****
Improved:
- Imperial, royal, noble, gentry and chivalric ranks are now supported and treated as titles.

Fixed:
- Didn't know the difference between roman numerals and the first letters of middle names.

***** V1.8 *****
Improved:
 - Titles and suffixes detection. In many cases, they can be recognized even if their position is uncommon.
 - Added new medical suffixes.

Fixed:
 - Some issues with suffixes.

***** V1.7 *****
Improved: 
 - UX

Fixed:
 - The add-on didn't recognize names in UPPERCASE
 - Processing the whole column
 - Minor bugs

Added:
 - We introduced yearly subscriptions, you can still enjoy a fully functional trial version of the add-on for 30 days.
Additional information
PricingFree of charge trial
Developer
Privacy policy
Terms of service
Split Names will ask for the permissions shown below. Learn more
Split Names will need access to your Google account
This will allow Split Names to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Alison Leck
April 29, 2023
Really easy to use ..... brilliant when doing certificates .... and the schools supply names as last name, first name ! Saves me thousands of hours !
Is this review helpful?
Yes
No
Profile Picture
Danny Wright
September 27, 2022
BEWARE! Ablebits double charged our small nonprofit for years and when we brought this to their attention they declined to reimburse us for the double charges, even though they admitted that they did charge us for two annual subscriptions for the same product. Also - You can split cells and merge them for free through a simple command on Google Sheets. Do a quick google search to find out how!
Is this review helpful?
Yes
No
Profile Picture
Felix Jacomino
November 4, 2021
What a great tool! In the past, I'd have to Google ways to do a fraction of what Split Names could do. It was cumbersome, tedious, and wouldn't always do what I needed. With Split Names, I can now take care of getting my data exactly as I need it for a super affordable price! Great tool at a great price. :)
Is this review helpful?
Yes
No
Profile Picture
Jordan Smith
September 18, 2023
Worth paying for. This saves me a ton of time every week importing leads from Facebook ads. Does its job and does it well.
Is this review helpful?
Yes
No
Profile Picture
Amy Koger
July 23, 2021
This add-on is a gamechanger. I have been needing this for years for my classroom rosters. If you have a Google Sheet that has information in one column that you need separated, give this add-on a try. Easy and quick to use.
Is this review helpful?
Yes
No
Profile Picture
Brian Shackelford
September 11, 2022
Great app, saves tons of time
Is this review helpful?
Yes
No
Profile Picture
PHSC Results
December 23, 2021
Easy to use, and very quick! Would highly recommend.
Is this review helpful?
Yes
No
Profile Picture
Neal Freed
March 4, 2022
Program works great, much smarter than split text to columns. Money well spent.
Is this review helpful?
Yes
No
Profile Picture
Jacquie Madison
May 23, 2021
I've installed this twice now and it doesn't appear on my sheet as an option.
Is this review helpful?
Yes
No
Profile Picture
Kevin Harmsworth
September 21, 2020
I had a problem signing on after payment had been made. The support staff were very helpful making life a little easier at this end to get everything working. I would highly recommend them.
Is this review helpful?
Yes
No
1-10 of 40
Search
Clear search
Close search
Google apps
Main menu