Loona Automation logoLoona Developer Tools
Home › Developer Tools › CSV Pivot / Group-By

CSV Pivot / Group-By - Summaries Without a Spreadsheet

In short: the CSV Pivot groups your rows by any column and aggregates a value column - sum, count, average, min or max - producing a clean summary table and CSV, the group-by half of a pivot table in one step.

Total sales per city, signups per month, average score per class: the questions are always group-by questions. Paste the raw rows, get the summary.

Private by design: everything in this tool happens 100% in your browser with JavaScript. Your input is never uploaded to a server, never stored and never seen by us - close the tab and everything is gone.

How to use the CSV Pivot / Group-By

  1. Paste your CSV with a header row.
  2. Name the column to group by and the numeric value column.
  3. Pick the aggregation: sum, count, average, min or max.
  4. Read the summary table, or download it as CSV.

How it works

Grouping is exact-text: 'Lahore' and 'lahore' are different groups, so clean casing first (our CSV Dedupe & Cleaner trims stray spaces). Non-numeric values in the value column are skipped for sum/average/min/max rather than poisoning the result, and Count always counts rows. Sums and averages are rounded to 2 decimal places to hide floating-point noise like 0.30000000000000004.

Frequently Asked Questions

Is this tool free?

Yes - completely free, no sign-up.

Is this a full pivot table?

It is the group-by core of one: one grouping column and one aggregation. Cross-tab pivots with row and column dimensions belong in a spreadsheet.

What happens to non-numeric values?

They are skipped for numeric aggregations. Count rows still counts them.

Is my data uploaded?

No. Aggregation runs in your browser.

Related Developer Tools

Embed this tool on your website — free

Add this tool to your own website or blog — it is completely free, needs no sign-up, and always shows the latest version. Copy the code below and paste it into your page where you want the tool to appear. Keeping the small “Powered by Loona Automation” credit line under the embed helps keep this tool free — but you are free to style or remove it; the tool works either way.