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.





