CSV Pivot
CSV Pivot. Use CSV Pivot on your input. Configure Table data, Column names / key columns (comma-separated), Group-by column and inspect the result before copying it.
Text and transformation
Runs in this browserResult
Set the inputs and run the tool to view the result.
How to use CSV Pivot
- Review the populated example and the input units, then replace it with your data.
- Use CSV Pivot on your input. Configure Table data, Column names / key columns (comma-separated), Group-by column and inspect the result before copying it.
- Run the tool, inspect the result, then copy or download what you need.
Method and scope
Use CSV Pivot on your input. Configure Table data, Column names / key columns (comma-separated), Group-by column and inspect the result before copying it.
Preserves data, not Excel macros, formula evaluation or styling. The first row is a header; names must be nonempty and unique. CSV export guards text beginning with = + - @ against formula injection. Prefer files below 20 MB.
Input example
Table data: SKU,Name,Quantity,Price A01,Glass cup,100,12.5 A02,"Cup,Blue",80,15 A01,Glass cup,100,12.5 Column names / key columns (comma-separated): Quantity Group-by column: SKU
Questions and result checks
How does CSV Pivot determine the result?
Use CSV Pivot on your input. Configure Table data, Column names / key columns (comma-separated), Group-by column and inspect the result before copying it.
What should I check before processing?
Preserves data, not Excel macros, formula evaluation or styling. The first row is a header; names must be nonempty and unique. CSV export guards text beginning with = + - @ against formula injection. Prefer files below 20 MB.
How can I verify the output?
Use the supplied example as a check, then compare important results with the original source or business document.
Table data: SKU,Name,Quantity,Price A01,Glass cup,100,12.5 A02,"Cup,Blue",80,15 A01,Glass cup,100,12.5 Column names / key columns (comma-separated): Quantity Group-by column: SKU
Related tools
CSV · View
Use CSV · View on your input. Configure Table data and inspect the result before copying it.
Excel & TablesCSV · Edit
Use CSV · Edit on your input. Configure Table data and inspect the result before copying it.
Excel & TablesCSV · Select columns
Use CSV · Select columns on your input. Configure Table data, Column names / key columns (comma-separated) and inspect the result before copying it.
Excel & TablesCSV · Reorder
Use CSV · Reorder on your input. Configure Table data, Column names / key columns (comma-separated) and inspect the result before copying it.
Excel & TablesCSV · Rename
Use CSV · Rename on your input. Configure Table data, Header mapping JSON and inspect the result before copying it.
Excel & TablesCSV · Sort
Use CSV · Sort on your input. Configure Table data, Column names / key columns (comma-separated) and inspect the result before copying it.