Pivot Table Builder

A pivot table builder that turns a long, row-by-row CSV into a clear summary — without opening a spreadsheet. Paste or upload your data, drag the columns you care about into Rows, Columns, Values and Filters, and the tool instantly cross-tabulates the result: total sales per region per channel, average response time per team per month, headcount per department per location, and so on. It is built for analysts, finance teams, operations managers and anyone who has a CSV export and needs an answer faster than wrangling a spreadsheet formula.

Unlike a spreadsheet, there is nothing to install and no account to create. The whole tool runs as client-side JavaScript in your browser, so even sensitive sales, payroll or customer data never leaves your machine. Your chosen layout and the last dataset you loaded are remembered in your own browser between visits, so you can refine the same report over several sessions. When the summary looks right, export it back to CSV or copy it straight into Excel, Google Sheets or Numbers with the row and column structure preserved.

How it works

You start by loading data — paste CSV text, upload a .csv file, or click Try sample data to explore with a small sales dataset. The first row becomes the column headers, and each column is automatically classified as numeric or text so the tool can suggest a sensible default aggregation. Numeric columns are flagged with a small hash marker.

Next you arrange the report by dragging field chips into the four zones. Rows create one group per distinct value down the left edge; Columns spread values across the top to form a cross-tab; Values are the numbers being aggregated; and Filters restrict which underlying rows are counted. For every value field you choose an aggregation — Sum, Average, Min, Max, Count or Count unique — and you can drop the same column into Values twice to compare two aggregations side by side. The table recomputes immediately, complete with per-row totals, per-column totals and a grand total. Everything is computed locally with a single pass over your data.

Example

Imagine a sales.csv with columns Region, Country, Channel, Rep, Units, Revenue and a few hundred order rows. Drag Region into Rows, Channel into Columns, and Revenue into Values as a Sum. In one step you get total revenue for every region split by Online vs Retail, with a Total column showing each region’s overall revenue and a Grand total row at the bottom.

Add Units to Values as a second aggregation, or drop Country into Filters to focus on a single market — the table updates instantly. When it is ready, hit Export CSV or Copy for Sheets. Every figure is calculated in your browser; no data is uploaded or stored on any server.