Convert Text to a Table

Paste text that has a pattern in it and get a table out. You choose where the columns are, because a block of text does not say, and no heuristic gets it right for every file.

Text
Read on this page. Nothing is uploaded.
Edit
Paste or upload something above and it will appear here.
CSV

The table appears here as CSV once there is text to split.

For the other 36 formats, use the converter on any conversion page.

Five ways to split

Aligned columns is the default and the right answer for anything a program printed. If the same character positions are blank on every line, those gutters are the column boundaries, which keeps a value like New York in one cell instead of two.

Any whitespace splits on every run of spaces or tabs. Correct for command line output, wrong for any value containing a space, which is most names.

A character splits on whatever you type: a comma, a semicolon, a pipe, a colon. Use this for text that was almost a CSV.

One item per line gives a single column, which is the starting point for a list copied out of a document.

Wrap into columns takes a flat list and folds it into a fixed number of columns. That is what a list copied out of a multi-column page needs, where the items came out one per line but belong in a grid.

Why this is not the CSV converter

A CSV states its own structure. The delimiter is in the file, and quoting says which delimiters are data. Plain text states nothing, so the split is a decision rather than a reading, and the tool that makes it should ask rather than guess quietly.

That is also why the grid is here. Whichever mode you pick will be wrong for some rows, and fixing four cells by hand takes less time than finding a tool that guesses differently.

Questions

My columns split in the wrong place. What now?

Try a different split mode first, since aligned columns and any whitespace fail on opposite kinds of input. If neither is right, edit the grid directly.

Can I turn a numbered or bulleted list into a table?

Yes. Split one item per line, then use find and replace with a regular expression to strip the bullets or numbers. A pattern like ^\d+\.\s* removes a leading number and its full stop across every cell at once.

How do I split one column into several?

Use the character mode with whatever separates the parts. If a column holds Surname, Forename, splitting on a comma gives you two columns.

Other tools