How it works
Group exact cell strings and sum the selected numeric column with decimal arithmetic. Preserve first-seen group order.
Input definitions
- CSV with headers
- Plain text; maximum 200,000 characters.
- Group column
- Enter the value in the labeled unit.
- Numeric value column
- Enter the value in the labeled unit.
A worked example
- CSV with headers
- team,amount A,10 B,20 A,30
- Group column
- team
- Numeric value column
- amount
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
Are blank or differently capitalized group names combined?
Blank names form their own group. Matching is exact and case sensitive, so A and a are separate groups. Selected numeric cells cannot be blank.
How does CSV pivot by group and sum work?
Group exact cell strings and sum the selected numeric column with decimal arithmetic. Preserve first-seen group order.
What are the limits of CSV pivot by group and sum?
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.