CSV pivot table builder
Group records and calculate count, sum and mean aggregates.
CSV pivot table builder എങ്ങനെ ഉപയോഗിക്കാം
The CSV pivot table builder groups rows of a CSV or XLSX file by one or more columns and calculates a sum, count or mean for each group. Enter the group columns separated by commas and the numeric column to aggregate. The summary table has one row per unique combination of group values and downloads as result.csv.
- Choose a source file. If the tool accepts multiple files, arrange them in the order you want.
- Set group columns (comma-separated), numeric column, aggregate.
- Run csv pivot table builder, review the output, then use the available copy or download controls.
ഈ ഉപകരണത്തിന്റെ സവിശേഷതകൾ
Group records and calculate count, sum and mean aggregates.
- Group columns (comma-separated)
- Set this value for your task.
- Numeric column
- Set this value for your task.
- Aggregate
- sum · count · mean
പരിധികളും പ്രോസസ്സിംഗും
CSV/XLSX inputs are capped at 10 MB each, 200 columns and 20,000 rows; joined output is capped at 20,000 rows. JSONPath script/filter evaluation is disabled. Other operations apply their visible controls and text limits.
പതിവ് ചോദ്യങ്ങൾ
How do I sum sales by category from a CSV?
Set Group columns to category, the Numeric column to your amount column, and Aggregate to sum. Each output row shows one category and the total of its amounts.
Can I group by more than one column?
Yes. List several headers separated by commas, such as region,category. Each unique combination of values becomes a row, with one output column per group field followed by the aggregate.
Why does the pivot builder reject my amount column?
For sum and mean, every value in the numeric column must parse as a number, so text like N/A or currency symbols cause an error. Count ignores that column and only counts rows per group.
Where is my input processed?
This operation processes its source in your browser. Copy and download are explicit actions; source input is not saved in an account or history.
What are the input limits?
CSV/XLSX inputs are capped at 10 MB each, 200 columns and 20,000 rows; joined output is capped at 20,000 rows. JSONPath script/filter evaluation is disabled. Other operations apply their visible controls and text limits.