Text to Columns Online

Split full names, pasted lists, locations, codes, and other delimited Excel cell values into clean separate columns.

Drop your file here or click to upload

Supports .xlsx, .xls, .xlsm, .xlsb · up to 50MB · or paste a file from your clipboard

Split Text into Columns Online

When data arrives in a single column - full names, addresses, or comma-separated values pasted from another app - you need to separate text in Excel into usable columns. This tool does an online Text to Columns split by any delimiter, entirely in your browser.

How to Separate Text in Excel

  1. Upload your workbook - drag in an .xlsx, .xls, .xlsm, or .xlsb file.
  2. Pick the column and delimiter - comma, space, tab, semicolon, or a custom character.
  3. Split - the values are separated into new columns.
  4. Preview and download - review the result and download a new workbook.

In desktop Excel, Data > Text to Columns offers Delimited and Fixed Width modes; choose an empty destination range so the result does not overwrite neighboring data. Flash Fill can infer simple name patterns, while Excel 365's TEXTSPLIT keeps a delimiter-based split formula-driven. The tool above is useful when you want a preview and a separate downloaded copy.

Frequently Asked Questions

Related Tools