Split Text into Columns in Excel Online — Free, No Upload, 1 Click
Split delimited text into separate columns with your own delimiter. No upload, no sign-up — file stays on device.
Drop one .xlsx, .xlsm, or .xls file here, or click to browse
Supports .xlsx / .xlsm / .xls · processed locally · never uploaded
How to Split Text into Columns Online
- Drop one .xlsx, .xlsm, or .xls workbook — everything runs locally in your browser and the file is never uploaded.
- Confirm the column letter that holds the text to split: A is the first column, B the second, and so on. The same column is processed in every sheet.
- Pick the delimiter: comma, semicolon, pipe, tab, or a custom literal — a multi-character sequence such as “ -> ” is matched as a whole.
- Choose the mode: Insert adds new columns and shifts the columns on the right; Overwrite replaces neighboring cells without changing the sheet width.
- Keep “First row is a header” ticked (the default) so the header row is never split, then click Split text to columns.
- Review the per-sheet report and download the result as your-file-name-split-columns.xlsx.
Insert vs Overwrite: Two Split Modes
Both modes read the same source column but write the result differently. In the first example below, column B contains “red,green,blue” in a three-column sheet and is split on commas.
Insert mode (default): two extra columns are added, and the value that was in column C shifts to the right. The sheet grows from 3 to 5 columns.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| Before | 1 | red,green,blue | x | ||
| After | 1 | red | green | blue | x |
Overwrite mode: the parts replace the source cell and the cells to its right. The sheet keeps its width — here the value in C (“x”) is overwritten while D (“9”) is kept.
| A | B | C | D | |
|---|---|---|---|---|
| Before | 1 | red,green | x | 9 |
| After | 1 | red | green | 9 |
Supported Delimiters
| Preset | Splits on | Typical source |
|---|---|---|
| Comma | The comma character , | CSV-style text and standard .csv exports |
| Semicolon | The semicolon ; | European CSV exports that use semicolons |
| Pipe | The vertical bar | | Log files and pipe-delimited data exports |
| Tab | A tab character | Text copied from spreadsheets and .tsv files |
| Custom | Any literal text you type | Multi-character separators such as “ -> ” or “ | ”, matched as one piece |
Rules and Limits
- Only text cells are split. Numbers, dates, booleans, and blank cells are always treated as a single value and never change.
- A cell is split only when it actually contains the delimiter. Text without the delimiter stays in one piece.
- One cell produces at most 20 parts. If more delimiters remain, the 20th part keeps all the leftover text, delimiters included.
- In overwrite mode, parts that would run past the sheet edge are ignored and counted in the report; in insert mode the sheet simply grows instead.
- Sheets narrower than the chosen column are skipped and remain untouched.
Three rules worth remembering: a cell is split into at most 20 parts and the last part keeps the remaining text; a custom delimiter is matched as a literal whole, so “ -> ” never matches a lone “-”; and numeric, date, and boolean cells are never split — only text cells are. The output is a value-level .xlsx, so styles, column widths, merged cells, and charts are simplified.
When You Need This
- One column packs several values — “Smith, Anna, London” — and you need them in separate columns for sorting or filtering.
- Cleaning CSV-style pastes, log exports, or tab-separated text that landed in a single column.
- Splitting imported data before a mail merge or before loading it into another system.
- You want an Excel-style Text to Columns action without opening Excel or uploading the file anywhere.
Frequently Asked Questions
Is this Text to Columns tool really free?
Yes — 100% free, with no sign-up, no watermark, and no file limit. All processing happens locally in your browser.
Which column will be split?
The column letter you enter: A is the first column, B the second, and AA is column 27. The same column is split in every sheet. Sheets too narrow to contain it are skipped, and a letter beyond every sheet’s width is rejected.
What is the difference between Insert and Overwrite?
Insert places the parts into new columns and shifts everything to the right, so the sheet grows. Overwrite writes parts over the source cell and the cells immediately to its right, keeps the sheet width, and ignores — and reports — parts that would spill past the edge.
Are numbers and dates split too?
No. Only text cells that contain the delimiter are split. Numbers, dates, booleans, blanks, and text without the delimiter remain a single value.
What happens when a cell would produce more than 20 parts?
Splitting stops at 20 parts. The 20th part keeps the entire remaining text, delimiters included, so one very long cell can never explode into thousands of columns.
Can I use a multi-character delimiter?
Yes — choose Custom and type any literal text, for example “ -> ” or “ || ”. It is matched as a whole, character for character; a single “-” or “|” elsewhere in the text is not touched.
Will my formatting be preserved?
The output is rebuilt from cell values, so styles, column widths, merged cells, and charts are simplified. Open the file in the free online editor when formatting must be preserved.
Which formats are supported, and what about encrypted files?
.xlsx, .xlsm, and legacy .xls are accepted; the result always downloads as a modern .xlsx. Password-protected (encrypted) workbooks cannot be read — remove the open password first.
Related Tools
Want the full walkthrough? Read How to Split Full Names into First and Last in Excel — step-by-step instructions, the manual Excel method, and FAQ.
Need the full reference? Read TEXTSPLIT in Excel: Syntax, Examples and Errors — syntax, examples, common errors, and FAQ.
Need the full reference? Read LEFT in Excel: Syntax, Examples and Errors — syntax, examples, common errors, and FAQ.
Need the full reference? Read RIGHT in Excel: Syntax, Examples and Errors — syntax, examples, common errors, and FAQ.
Need the full reference? Read MID in Excel: Syntax, Examples and Errors — syntax, examples, common errors, and FAQ.
Need to preview and fine-tune the columns after splitting, or keep the original formatting?
Open the free online Excel editor