TSV Columns to Rows (Unpivot)

Unpivot wide tab-separated TSV tables into normalized, row-oriented records.

How It Works & Processing Standards

Unpivot wide tab-separated TSV tables into normalized, row-oriented records.

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

TSV Columns to Rows (Unpivot) 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 TSV Columns to Rows (Unpivot)

  1. 1
    Paste TSVEnter wide TSV table text.
  2. 2
    Configure UnpivotSelect key columns to retain and measure columns to collapse into rows.
  3. 3
    Copy OutputCopy the normalized TSV dataset.

Examples

Unpivot TSV
Input: dept jan feb Sales 10 15
Result: dept month val Sales jan 10 Sales feb 15

Common Use Cases

  • Normalizing data copied from Excel spreadsheets before database insertion
  • Transforming wide clinical trial tables into longitudinal row records
  • Simplifying command-line scripting pipelines

Frequently Asked Questions (FAQ)

Are tabs preserved in the unpivoted output?

Yes, the resulting unpivoted table uses tab separators between all fields.

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