Data & CSV

Transpose CSV

Swap a small CSV’s rows and columns.

Transpose CSV
Esc to restore

Your inputs

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.

Treats the header as the first row and transposes the entire rectangular grid. Maximum 200 rows including header and 200 columns. The first input column becomes output headings, so those values must be non-empty and unique. CSV exports protect spreadsheet formula prefixes.

See a worked example

Worked example

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

CSV data
Name,Group,Score
Alex,A,72
Sam,B,85
Jo,A,91

Example result

Example result
NameAlexSamJo
GroupABA
Score728591

Keep going.

CSV dataset diffCSV rule validatorCSV calculated columnCSV rank and percentile