happytails.ai

CSV unpivot

Convert a wide CSV into tidy long-form records. Turn measure columns into a variable and value while keeping identifiers.

List the measure columns to unpivot, such as Jan,Feb. Each selected cell becomes a record containing the original identifier fields, the measure's column name and its value. Every unselected column remains an identifier. Results follow source-record order and then your selected measure-column order. Empty values are retained by default. Omit empty measure cells if you do not need those records; zero and spaces are still preserved. You can name the new variable and value columns. Their names must be distinct and must not overwrite a retained column. Quote a measure-column name containing a comma. Review the table, then download the complete CSV and JSON processing report. Values remain strings rather than being converted to numbers or dates. The default export prefixes formula-like cells with an apostrophe. Use original-string export for trusted machine processing and import CSV columns as text when exact identifiers matter. Include a header row. Quote cells that contain commas or new lines. Results update as you type. Up to 1,000,000 characters.

Your result

Report a problem or share an idea.

How to use CSV unpivot
  1. Paste the wide CSV and choose its input separator.
  2. List the exact measure-column names and choose the two new column names.
  3. Review the long-form records and download the CSV.

Useful next steps

CSV pivotCSV row filterCSV cell expansionDataset value mapper

What to expect

Convert a wide CSV into tidy long-form records. Turn measure columns into a variable and value while keeping identifiers. List the measure columns to unpivot, such as Jan,Feb. Each selected cell becomes a record containing the original identifier fields, the measure's column name and its value. Every unselected column remains an identifier. Results follow source-record order and then your selected measure-column order. Empty values are retained by default. Omit empty measure cells if you do not need those records; zero and spaces are still preserved. You can name the new variable and value columns. Their names must be distinct and must not overwrite a retained column. Quote a measure-column name containing a comma. Review the table, then download the complete CSV and JSON processing report. Values remain strings rather than being converted to numbers or dates. The default export prefixes formula-like cells with an apostrophe. Use original-string export for trusted machine processing and import CSV columns as text when exact identifiers matter.

Try a small example

id,Jan,Feb
001,2,3
002,0,