Pivot CSV rows into summary tables — group, count, and sum without spreadsheets. Summarize 10k sales rows by region instantly — local pivoting, free, no signup.
Content reviewed October 2026 · About Toolzum
Merge two CSV files on a shared key column — join related exports into one sheet. Combine two tables without spreadsheets — local merging, free, no signup.
Flip CSV rows and columns — wide tables to long form for analysis. Pivot stubborn exports without Excel gymnastics — local transposing, free, no signup.
Sort CSV rows by any column ascending or descending — numbers by value, text alphabetically. Order sales rows in seconds — local parsing, free, no signup.
Parse SQL INSERT statements back into CSV rows — quoted strings unescaped, NULLs emptied, multi-statement appends. Round-trip database dumps back to spreadsheets — local parsing, free, no signup.
Convert pasted tables, lists, and structured text into clean CSV rows. Turn copied web tables into spreadsheet data — local parsing, free, no signup.
Group by region, sum revenue, count orders: 10,000 rows collapse to a 12-row summary table. Aggregation choice changes answers — sum vs average deliberately.
One group column per run — output is group, count, sum, avg. For two levels, pivot once, then pivot the result again.
Missing keys bucket as (blank) — decide: exclude, impute, or investigate. Silent nulls skew summaries.
No — pivoting runs locally in your browser. Data never leaves your device.
Grouped by role: Admin gives count 2, sum 157000.00, avg 78500.00 (75000+82000); Editor gives 1, 62000.00, 62000.00. Output headers are always group,count,sum,avg with 2-decimal sums; non-numeric values count as 0.
CSV Row Filter
Filter CSV rows by column value with case-insensitive contains matching. Keep only the rows you need — local, free, no signup.
CSV Output Tools
Format and validate CSV files — consistent delimiters, quoting, and line endings. Fix files Excel mangles on export — local processing, free, no signup.
Data Format Converter
Convert data between JSON, CSV, XML, YAML, and TSV with structure preserved. Migrate configs across stacks without rewriting — local PapaParse/xml2js/yaml parsing, free, no signup.