CSV Transpose & Reshape

CSV Transpose & Reshape

Local Processing

Transpose CSV or TSV, unpivot columns into rows, or pivot rows into columns.

How It Works & Processing Standards

Transpose CSV or TSV, unpivot columns into rows, or pivot rows into columns.

Tool processing runs in your browser. If you create a calculator or conversion share link, its values are included in the URL. See the privacy policy for account, analytics and advertising data.

Current Limits

  • Desktop max file size: 50MB
  • Mobile max file size: 20MB

Choose transpose, columns → rows or rows → columns under "Task". Turn a wide table sideways or reshape into the long or wide format analysis tools expect.

What You Can Do

Transpose
Rotates the table so the first row becomes the first column (CSV, TSV, any delimiter).
Columns → rows
Keeps an ID column and spreads the rest into name/value rows.
Rows → columns
Gathers name/value columns back into many columns.

How to Use CSV Transpose & Reshape

  1. 1
    Choose a taskPick the reshape.
  2. 2
    Enter data and columnsPaste CSV/TSV and name the columns needed.
  3. 3
    Get the resultCopy it or download Excel.

Examples

Transpose
Input: 이름,국어,수학 민수,90,80 지영,85,95
Result: 이름,민수,지영 국어,90,85 수학,80,95
Columns → rows (keep 이름)
Input: 이름,국어,수학 민수,90,80
Result: 이름,name,value 민수,국어,90 민수,수학,80

Common Use Cases

  • Turning a wide monthly table on its side
  • Making long-format data for charts or statistics tools

Frequently Asked Questions (FAQ)

What happens to the header when transposing?

The header row becomes the first column, which is why 국어 and 수학 appear in the first column above.

Have feedback or ideas for this tool? Suggest & Inquire →