Pivot Table Builder
Create pivot tables from CSV data with drag-and-drop rows, columns, and values. Processed entirely in your browser for 100% d
Your files never leave your device. Processed locally. 100% private.
Unlocking Tool Engine...
How To Use Pivot Table Builder
Complete your task perfectly in just three straightforward steps.
Upload CSV
Drop your CSV file.
Configure pivot
Drag columns to Row, Column, and Value areas. Choose aggregation: SUM, COUNT, AVG, etc.
Export
Download the pivot table as CSV or Excel.
FAQ
Everything you need to know about the Pivot Table Builder.
What aggregations are supported?
SUM, COUNT, AVG, MIN, MAX, and DISTINCT COUNT.
Can I have multiple value columns?
Yes — add multiple value fields each with independent aggregations.
Is my file uploaded?
No. Everything runs locally in your browser.
File size limit?
Process files up to the browser memory limit.
Can I filter before pivoting?
Yes — apply row filters before the pivot is computed.
What can I download the pivot result as?
The pivot result downloads as a standard CSV file. You can then open it in Excel, import it into Google Sheets, or pass it to other Refinata tools like CSV to Excel or CSV to JSON for further processing.
What types does it treat as numeric for aggregation?
Pivot Engine auto-detects numeric columns by sampling the first 20 values and checking if more than 70% parse as valid numbers (including values with commas as thousands separators, like 1,234.56). Columns that do not meet this threshold are treated as text and are only available as grouping columns, not aggregation targets.
Related Tools
Continue working with our suite of free data utilities.
CSV Sorter
Sort CSV rows by one or more columns in ascending or descending order. Fast, private, and secure browser-based tool with no s
Column Selector
Choose which columns to keep. Drag to reorder the output. Securely process files in your browser memory with zero data transf
CSV Splitter
Split a large CSV into smaller files by row count, column value, or file size. The safest way to process sensitive data with
CSV Merger
Merge multiple CSV files with the same structure into a single file vertically. Processed entirely in your browser for 100% d
CSV Joiner
Perform SQL-style JOINs on two CSV files using a common key column. Fast, private, and secure browser-based tool with no sign
Column Splitter
Split one CSV column into multiple columns by delimiter, position, or regex. Securely process files in your browser memory wi