App Icon
Split name in a cell into multiple cells and auto-detect its parts.
Works with:
2,229,226
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.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
PricingNot available
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:
Profile Picture
A User of Split Names
July 19, 2017
It's free, saves you a bunch of time, and does exactly what it says. 5 stars well deserved
Is this review helpful?
Yes
No
Profile Picture
A User of Split Names
October 5, 2016
Was doing a 160 guest wedding list and had to separate by the various categories. This saved me an hour of work easily. A+
Is this review helpful?
Yes
No
Profile Picture
A User of Split Names
July 27, 2015
TOP 5 EXTENSIONS/ADDONS FOR GOOGLE SHEETS. MAYBE NUMBER 1. This addon is one of the best, most helpful, direct utilities I've ever seen. The code behind this must be elegant, because the ease of use is excellent. Very highly recommended to those who use Sheets with regularity.
Is this review helpful?
Yes
No
Profile Picture
A User of Split Names
January 23, 2018
Tool is now non-functional and stuck behind a paywall. Better off leaning how to write this code on my own and doing it myself.
Is this review helpful?
Yes
No
Profile Picture
A User of Split Names
March 13, 2018
Great add on. however, you must now pay for it forever.
Is this review helpful?
Yes
No
Profile Picture
A User of Split Names
March 8, 2016
This is the best thing that has ever happened to me. Thanks for making this, it saved my sanity.
Is this review helpful?
Yes
No
Profile Picture
Joy Kidd
August 12, 2017
Saved me tons of work at the beginning of the school year when I copied/pasted student names from the online gradebook to my own spreadsheet.
Is this review helpful?
Yes
No
Profile Picture
A User of Split Names
December 9, 2014
Wish this had existed YEARS ago... no more Find & Replace in csv torture! THANK YOU!!! Now I'm about to find out how well it works on address columns.
Is this review helpful?
Yes
No
Profile Picture
A User of Split Names
March 31, 2017
Thank you for this great time saver that worked perfectly, even automatically removed the comma separating surname from first name.
Is this review helpful?
Yes
No
Profile Picture
Rodney Steele
July 2, 2019
Saves a ton of time, and works perfect.
Is this review helpful?
Yes
No
1-10 of 36
Search
Clear search
Close search
Google apps
Main menu