Text to Columns Alternative • 1-Click Execution
Split Columns in Excel Online
Separate combined text into distinct columns by spaces, commas, hyphens, or custom delimiters. Upload your file below, select your target column, and click "Split Column".
A1
fx
Drop XLSX, CSV, TSV, Markdown (.md), or JSON here
Runs locally inside browser memory. Multi-sheet workbooks open into tabs automatically.
1r × 1c used
Count: 0
Sum: 0
Avg: 0
Zero Uploads
Combine Two or More Columns
Merge 2+ columns cleanly without writing formulas.
Preview
Split Column by Delimiter
Remove Duplicate Rows
Find & Replace
Sort Rows
Filter or Delete Matching Rows
Quick Cleanup:
Fill, Prefix / Suffix & Extract Column
Merge Multiple Files / VLOOKUP Join Sheets
Append rows from multiple files/tabs or join two sheets by a key column.
Option A: Stack / Append All Open Sheet Tabs
Option B: VLOOKUP / Left-Join Two Sheets by Key
Format Preview & Export Converter
Column Profiler & Quick Summary
| Col | Header | Filled | Blank | Unique | Dupes | Min / Max / Avg |
|---|
Paste CSV, TSV, Markdown Table, JSON, or HTML
Confirm Action
How to Split Columns in Desktop Excel (Text to Columns)
If you are working in desktop Microsoft Excel without our web tool:
- Select the column containing the data you want to split (e.g. Column A with "Full Names").
- Make sure there is at least one blank empty column to the right, otherwise Excel will overwrite existing data.
- Go to the Data tab on the Excel ribbon and click Text to Columns.
- Select Delimited and click Next.
- Check the box for your delimiter (e.g. Space for names or Comma for addresses).
- Click Finish. Excel splits the text across adjacent columns.
Modern Formula Method: TEXTSPLIT (Excel 365)
If you have Microsoft 365, you can use the dynamic array function =TEXTSPLIT(A2, " ") to automatically spill results into adjacent cells without opening wizards.
