How it works
Keep the selected identifier; turn every other cell into a separate row with the source column name and cell value.
Input definitions
- Wide CSV
- Plain text; maximum 200,000 characters.
- Identifier column to retain
- Enter the value in the labeled unit.
A worked example
- Wide CSV
- person,Jan,Feb Ada,10,20 Lin,30,40
- Identifier column to retain
- person
Assumptions & limits
Browser-local processing. CSV uses one unique header row, at most 1,000 total input rows and 50 columns. Downloads escape spreadsheet formula prefixes.
Sources & review
Maintained by AnsRio. Methods and examples use automated checks; this does not imply independent professional certification.
Method updated 2026-10-17. Content checked against the stated method and examples. Our verification approach.
Common questions
Does unpivot aggregate values?
No. It preserves each source cell as its own row, including empty cells. It changes the table shape rather than calculating totals.
How does Unpivot wide CSV columns work?
Keep the selected identifier; turn every other cell into a separate row with the source column name and cell value.
What are the limits of Unpivot wide CSV columns?
Browser-local processing. CSV uses one unique header row, at most 1,000 total input rows and 50 columns. Downloads escape spreadsheet formula prefixes.
How do I keep the full worksheet?
Run the tool and choose Download file. The on-page table is a preview and may show only the first 20 rows; the downloaded file contains the full result. CSV downloads escape spreadsheet formula prefixes. Inputs and files are processed on your device.