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.

1

Upload CSV

Drop your CSV file.

2

Configure pivot

Drag columns to Row, Column, and Value areas. Choose aggregation: SUM, COUNT, AVG, etc.

3

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.