Data & CSV

CSV wide to long

Turn measurement columns into variable/value rows.

CSV wide to long
Esc to restore

Your inputs

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.

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.

Keeps one identifier column and turns every other column into variable/value records in input row and column order. Measurement strings are preserved. Requires distinct, non-empty output headings and at least two input columns. Output is limited to 50,000 rows; blank omission tests exactly empty cells.

See a worked example

Worked example

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

Wide CSV
Person,January,February
Ada,10,12
Sam,8,9
Column separator
Comma
Identifier column
Person
Output variable heading
Variable
Output value heading
Value
Blank measurement cells
Keep blank values

Example result

Example result
PersonVariableValue
AdaJanuary10
AdaFebruary12
SamJanuary8
SamFebruary9

Keep going.

CSV dataset diffCSV rule validatorCSV calculated columnCSV rank and percentile