Text to columns

Split delimited text into columns and download quoted CSV. Choose comma, tab, semicolon or pipe; quoted fields can contain delimiters and line breaks.

On your device · No account

Privacy details

Text to columns processes your input in this browser. Inputs and results are excluded from analytics. Recent tools save tool names, visit counts and last-visit times. Saved tools store only their names. Draft saving is optional and stays on this device; delete saved text with the draft controls. Loading text from a URL is optional and contacts that server; its URL and your IP address are visible to the server. An optional “Use in” action keeps a handoff in this tab. The next tool removes it on arrival and ignores it if more than a minute has passed.

Copy link includes the inputs you choose to share in the address. Anyone with that link can reopen them. Files and generated results are excluded. Password and key tools share settings only.

Your text

Options

Input delimiter

Spreadsheet formula protection

Your result

Reset reloads the tool with its starting values and releases open files and device controls. Saved drafts stay on this device until you delete them.

Links include your inputs and settings. Anyone with the link can see them, so leave out private text. Files and generated results are left out; random draws run again.

Keyboard shortcuts

Updated 2026-09-19

Using Text to columns

Split delimited text into columns and download quoted CSV. Choose comma, tab, semicolon or pipe; quoted fields can contain delimiters and line breaks.

Next: Duplicate line remover

A worked example

The text to columns changes "a|b\nc|d" becomes "\"a\",\"b\"\r\n\"c\",\"d\"".

Next: Sort words alphabetically

Before you use the result

This processes text locally, not an Excel workbook. Every row must have the same number of columns. Spreadsheet formula-like cells are prefixed with an apostrophe by default.

Next: Add line numbers

Cite this page

Citation style

ToolOctopus. “Text to columns.” Updated 2026-09-19. https://tooloctopus.com/text-to-columns.

Add an access date if your instructions require one.

Citation formatting uses citeproc-js by Frank Bennett and Citation Style Language styles. Licence and source code.