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.
- Price
- Free
- Your files
- Never uploaded
- Runs
- In your browser
or drag it here
.xlsx, .xls, .csv · up to 50 MB · processed locally, never uploaded
Excel and spreadsheet files only. Export from Google Sheets as .xlsx or .csv.
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
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