Skip to content
Convertto

Columns to Lines Converter

Switch between a delimited single line and one item per line, in either direction.

To convert between columns and lines, paste your data above and choose a direction. Delimited text is split on your chosen separator into one item per line, or a list of lines is joined back into a single delimited row, with surrounding whitespace trimmed either way.

Runs in your browser
Privacy
Runs entirely in your browser — nothing is uploaded
Cost
Free, unlimited, no sign-up

Frequently asked questions

What is this for?

Turning a spreadsheet column into a list you can paste elsewhere — into a SQL IN clause, a config array, or a search box that takes one term per line. It is the step between copying a column and using it.

Why does pasting from a spreadsheet produce tabs?

Because spreadsheets copy as tab-separated values. Each cell is separated by a tab and each row by a newline, which is why splitting on tabs reconstructs the original columns.

How to use the columns to lines converter

  1. 1Enter or paste your input.
  2. 2Choose the direction.
  3. 3Choose the delimiter.
  4. 4The result appears immediately — copy or download it.

Embed this tool

Put the working columns to lines converter on your own site. It runs in your visitors' browsers exactly as it does here — free, no account, nothing uploaded.

Share this tool

Related tools

ASCII Table FormatterTurn CSV or tab-separated text into an aligned plain-text, Markdown or box-drawing table.Add Line NumbersPrefix every line with a sequential number, with a custom start, separator and zero padding.Case ConverterConvert text to UPPERCASE, lowercase, Title Case, camelCase, snake_case, kebab-case and more.Line SorterSort lines alphabetically, numerically, by length or in reverse — with natural-order support.List Randomizer & ShufflerShuffle a list into random order — for draws, pairings, running orders and sampling.Remove Duplicate LinesDelete repeated lines from a list, keeping the first occurrence of each unique line.

Last updated

More text tools