Text to columns

Loading…

All tools › Editing lines

Text to columns

Split each line into columns and read it as a table.

It runs entirely in this browser tab: the text you paste is never uploaded, and the tool makes no network request while it works. Open your browser's network panel and try it — nothing leaves the page. There is no sign-up and no limit beyond what your own browser can hold.

Settings

Columns split by
Choices: A delimiter, Any spaces, A fixed width.
Delimiter
The text between the pieces, which is not kept.
Width
A number from 1 to 500.
First line names the columns
Otherwise the columns are simply numbered.
Trim spaces
On or off. Starts on.

How to use it

  1. Paste your text into the box above, or open a file.
  2. Adjust the settings beside it until the result is what you wanted.
  3. Copy the result, or save it as a file. The result updates as you type.

Questions

Is my text uploaded anywhere?
No. This page carries the whole tool as WebAssembly and runs it on your own device. Nothing you paste is sent anywhere.
Is there a size limit?
No fixed limit. Very large text is processed in full but is not laid out in the editing box, because drawing several megabytes of text sixty times a second would make typing unusable; the tool says so when that happens.
Can I get this result again later?
The settings travel in the page's address, after the #, so a link reproduces them exactly — and the fragment of an address is never sent to a server. Your last settings are also remembered on this device.
Is there a version that is not a web page?
Yes. The same tools are built as a desktop application from the same code, with a save dialog instead of a download and no network code at all.

Other tools for editing lines

Find and replace
Apply several find-and-replace rules at once, literally or by pattern.

Add line numbers
Put a number in front of every line, aligned and in the format you want.

Quote lines
Put quotation marks round each line and join them — ready for SQL or CSV.

Indent text
Add or remove indentation, and swap tabs for spaces either way.

Wrap lines
Break paragraphs at a fixed width without splitting words.

Join lines
Make many lines into one, with the separator and quoting you need.

Split text
Cut a long text into pieces that fit a message box or an input limit.

Truncate lines
Cut every line to a length, on a word boundary and with an ellipsis.

Text to list
Turn lines into an HTML, Markdown or BBCode list.

All forty-nine tools