CSV Columns to Rows (Unpivot / Melt)

Unpivot wide CSV tables into tall row-oriented records (columns to rows transformation).

How It Works & Processing Standards

Unpivot wide CSV tables into tall row-oriented records (columns to rows transformation).

Your input data is never sent to any server and is securely processed on your device.

Current Limits

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

CSV Columns to Rows (Unpivot / Melt) is a 100% free, browser-based online utility. All calculations and file conversions run locally inside your browser (Local-First) without sending data to remote servers, keeping your documents and inputs strictly private.

How to Use CSV Columns to Rows (Unpivot / Melt)

  1. 1
    Paste CSVEnter wide CSV table.
  2. 2
    Configure UnpivotSelect identifier columns to keep and columns to unpivot into rows.
  3. 3
    Export Long TableCopy or download the tall, normalized dataset.

Examples

Unpivot Quarterly Revenue
Input: company,q1,q2 Acme,100,120
Result: company,quarter,revenue Acme,q1,100 Acme,q2,120

Common Use Cases

  • Normalizing wide spreadsheet reports into long format for BI tools (Tableau, Power BI)
  • Preparing multi-column data for SQL relational table ingestion
  • Tidying survey datasets with multiple question columns into standardized key-value pairs

Frequently Asked Questions (FAQ)

What names are given to the new variable and value columns?

You can customize the header names for both the variable column (e.g. "quarter") and the value column (e.g. "revenue").

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