Data & CSV

CSV long to wide

Turn identifier/variable/value records into a wider table.

Your inputs

Long CSV

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

Identifier column

Variable-name column

Value column

Repeated identifier/variable pairs

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.

Creates one row per exact identifier and one column per non-empty variable name, both in first-seen order. Missing combinations are blank. Repeated pairs follow your selected reject/first/last/sum rule; sum ignores blank values and rejects non-numeric text. Requires three distinct source columns, unique generated headings and at most 200 output columns.

See a worked example

Worked example

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

Long CSV

Person,Month,Amount
Ada,January,10
Ada,February,12
Sam,January,8
Sam,February,9

Column separator

Comma

Identifier column

Person

Variable-name column

Month

Value column

Amount

Repeated identifier/variable pairs

Reject repeated pairs

Example result

Example result
Person	January	February
Ada	10	12
Sam	8	9