CSV Unpivot Tool
Convert a wide CSV table into long-form records while preserving selected identifier columns and original cell text.
Start with your input
Edit the example or replace it with your own text.
Choose your options
These settings are optional. Keep the defaults to get started.
How to use CSV Unpivot Tool
- Load the example or enter your own values.
- Choose the relevant options and run the tool.
- Review the result, then copy it or download a local file.
When this tool is useful
Turn spreadsheet columns such as months or survey questions into rows before charting or importing data. Choose the identifier columns to retain in each output record. Every remaining source column becomes a variable name, and its cell becomes the corresponding value. The result is a long-form CSV table that is easier to group, filter or feed into another analysis tool.
Reading the result and limitations
Identifier selection is a JSON array of exact header names, and at least one source column must remain to unpivot. Output names must be distinct and cannot collide with retained identifiers. All cell values, including empty cells and leading zeroes, remain strings without aggregation or type inference. Records are emitted in source-row order and then source-column order. The output is limited to one hundred thousand cells.
Example input
team,Jan,Feb Design,4,6 Engineering,8,10
What are the main limits of CSV Unpivot Tool?
Identifier selection is a JSON array of exact header names, and at least one source column must remain to unpivot. Output names must be distinct and cannot collide with retained identifiers. All cell values, including empty cells and leading zeroes, remain strings without aggregation or type inference. Records are emitted in source-row order and then source-column order. The output is limited to one hundred thousand cells.
Is input uploaded?
Processing takes place in your browser. This tool does not send your input or selected files to a conversion API.