# 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.

**URL:** https://convertto.tech/t/columns-to-lines
**Category:** Text Tools (https://convertto.tech/c/text-tools)
**Privacy:** Runs entirely in the browser; no upload
**Cost:** Free, no sign-up
**Last updated:** 2026-08-01

## Key facts

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

## How to use

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

## FAQ

### 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.

## Related tools

- [ASCII Table Formatter](https://convertto.tech/t/ascii-table-formatter): Turn CSV or tab-separated text into an aligned plain-text, Markdown or box-drawing table.
- [Add Line Numbers](https://convertto.tech/t/add-line-numbers): Prefix every line with a sequential number, with a custom start, separator and zero padding.
- [Case Converter](https://convertto.tech/t/case-converter): Convert text to UPPERCASE, lowercase, Title Case, camelCase, snake_case, kebab-case and more.
- [Line Sorter](https://convertto.tech/t/line-sorter): Sort lines alphabetically, numerically, by length or in reverse — with natural-order support.
- [List Randomizer & Shuffler](https://convertto.tech/t/list-randomizer): Shuffle a list into random order — for draws, pairings, running orders and sampling.
- [Remove Duplicate Lines](https://convertto.tech/t/remove-duplicate-lines): Delete repeated lines from a list, keeping the first occurrence of each unique line.
- [Text Wrap & Truncate](https://convertto.tech/t/text-wrapper): Hard-wrap text at a line width, or truncate it to a maximum length.
- [Whitespace Remover](https://convertto.tech/t/whitespace-remover): Strip extra spaces, tabs, blank lines and trailing whitespace from any text.
- [Tabs to Spaces Converter](https://convertto.tech/t/tabs-spaces-converter): Convert indentation between tabs and spaces without disturbing alignment inside lines.
- [Text Reverser](https://convertto.tech/t/text-reverser): Reverse text by character, word or line — useful for puzzles, testing and mirrored strings.