Column Splitter
Split one column into many by delimiter, width or pattern.
Break “John Smith” into first and last name, or a full address into street, city and postcode. Split by a delimiter, at fixed positions, or with a regular expression, and preview the result before committing.
- Rating
- 4.9(1.9K)
- Monthly uses
- 244K
- Price
- Free
or drag it here
.xlsx, .xls, .csv · processed locally, never uploaded
Files stay on your device
What it does well
- Delimiter, fixed-width and regex capture-group modes
- Split from the left or right, with a maximum-parts limit
- Original column optionally kept alongside the new ones
How to use Column Splitter
- 1
Upload your file and choose the column to split.
- 2
Pick the split method: delimiter, fixed width or regular expression.
- 3
Name the resulting columns and check the live preview.
- 4
Apply and download the updated workbook.
Watch a walkthrough
Common problems and fixes
A row produced more parts than expected and overwrote a neighbouring column.
Set a maximum parts limit. Everything beyond it is kept in the final column instead of spilling right.
Leading spaces appear in the new columns.
Enable “Trim parts”, which strips surrounding whitespace from every piece after splitting.
Frequently asked questions
What people say
Exactly what I needed. Column Splitter used to be a twenty-minute job with a macro I did not trust; now it takes one drag and one click.
Handled a file with well over 200,000 rows without complaining. That is more than I can say for the desktop add-in we pay for.
The preview before committing is the part that sold me — I could see exactly what column splitter was going to change before it changed anything.
More clean & format tools
Remove duplicates, trim whitespace, fix inconsistent dates and numbers, split or merge columns, and validate data quality before it reaches your reports.
Browse Clean & Format