Data & CSV

Combine CSV columns

Join selected cells into a new column with your chosen separator.

Your inputs

Your CSV data

UTF-8 CSV/TSV stays on this device. First row contains unique headings; maximum 25 MB, 50,000 rows and 200 columns. Fully empty rows are ignored.

Up to 25 MB per file, 50,000 data rows, 200 columns and 2 million data cells. Fully blank rows and columns are ignored before row, column and cell limits are checked. Individual tools may have smaller result or chart limits.

Or choose a CSV file

Column separator

Column headings to combine, one per line

Text between values

New combined heading

Empty cells

Results update as you type. Larger files run when you press Update result.

Processed on your device

Your result

LOCAL & PRIVATE

Your result will appear here.

Your inputs stay in this browser. Nothing is uploaded or saved.

A clear answer. Here’s how.

Reads a distinct list of exact column headings in your chosen order. Joins corresponding cell strings into a new final column, optionally omitting exactly empty values. Original columns remain unchanged. The new heading must be unique and non-empty; exports quote embedded commas and line breaks.

See a worked example

Worked example

A fixed demonstration, separate from the values you enter above.

Your CSV data

ID,Name,Department,Amount,Date
001,Ada,Design,120,2026-01-05
002,Sam,Writing,80,2026-01-06
003,Jo,Design,150,2026-01-07
004,Lee,Writing,,2026-01-08
005,Alex,Design,60,2026-01-09

Column separator

Comma

Column headings to combine, one per line

Name
Department

Text between values

—

New combined heading

Combined

Empty cells

Keep their separator positions

Example result

Example result
ID	Name	Department	Amount	Date	Combined
001	Ada	Design	120	2026-01-05	Ada — Design
002	Sam	Writing	80	2026-01-06	Sam — Writing
003	Jo	Design	150	2026-01-07	Jo — Design
004	Lee	Writing		2026-01-08	Lee — Writing
005	Alex	Design	60	2026-01-09	Alex — Design