DATA / TOOL 13
CSV group summary
Group rows and calculate sums, averages or counts.
Browser-local · No upload · Free
Your workspace
Your result
LOCAL ONLYReady when you are.
A small step from input to done.
Your result will appear here.A QUICK WALKTHROUGH
How to use it
- Paste CSV
- specify the group column and numeric column
- choose a calculation and run.
TRY THIS EXAMPLE
A result you can check.
Group the sample by Team and sum Hours. Design totals 8 and Build totals 4. Average gives Design 4 and Build 4.
Select Load example, then Run tool. Sample files are generated locally.
What to know
Count ignores the numeric-column field. Sums and averages require finite numeric cells and finite totals. Generated column names gain a result_ prefix if needed to keep headers unique. Floating-point rounding can affect very large or highly precise values.
Keep an original copy. Review the output before sharing or relying on it. Reset clears this workspace; inputs are not saved by Handyfold.