CSV Unpivot Tool

Convert non-identifier CSV columns into long-form column and value records.

CSV stays in this browser. Input is not uploaded.

Comma-separated CSV with 1-200 unique nonempty headers, up to 10,000 data rows and 200,000 characters. Every record must have the same cell count as the header.

Convert a wide table into long-form records

Paste CSV, choose the one-based Row / identifier column, and select Unpivot columns. Every other column becomes a pair of column name and cell value. The output has three columns: the identifier prefixed with ID:, Column and Value.

Example: two months become four records

The sample has Ada with Jan 2 and Feb 3, and Lin with Jan 4 and Feb 5. With identifier column 1, output records are Ada/Jan/2, Ada/Feb/3, Lin/Jan/4 and Lin/Feb/5. Source row order is retained; within each row, value columns follow the original header order.

What remains unchanged

All values remain strings. Blank cells still produce records, leading zeros remain present, and no dates or amounts are inferred. Only one identifier column is supported. If your dataset needs several identifier fields, prepare a suitable explicit identifier first rather than assuming this tool combines them.

The input must have at least two columns. Expanding a table multiplies records by the number of non-identifier columns, so output is capped at 10,000 records before allocation. For example, 1,000 rows with 20 measures would exceed that limit. Select fewer columns with CSV Column Selector or filter rows before unpivoting.

Compare with pivoting

Unpivoting changes shape without aggregation. CSV Pivot Table aggregates records by keys and can combine multiple source rows, so pivoting and unpivoting are not universally reversible. Preserve the source when duplicate identifiers or repeated measures have meaning.

CSV input limits

Use at most 200,000 characters, 200 unique nonempty headers and 10,000 data records. Quoted commas, quotes and multiline cells follow the shared CSV parser. Output is capped at two million characters. Editing input or options clears old results and download links; no source file is modified.

Preserve cell strings exports generated cell strings without protection prefixes. Add spreadsheet-protection prefixes adds an apostrophe to formula-like cells, including negative numbers, changing their values. Review that choice for the receiving application. CSV downloads quote every field and use CRLF record separators.