WebPivotTable is a JavaScript pivot table component built with React that
runs entirely in the browser. It delivers the full power of Excel-style pivot
tables — sorting, filtering, grouping, totals, subtotals, drill-through, and
charting — as a single <web-pivot-table> custom element that drops into any
web page or application.
Live Demo · Quick Start · Why WebPivotTable
What is a Pivot Table?
A pivot table is a data summarisation tool commonly found in spreadsheet and business intelligence software. It automatically sorts, counts, totals, or averages the data in a table and displays the results in a second, summarised view. Users build and reshape the summary by dragging and dropping fields — this "rotation" of the table is what gives the concept its name.
Pivot tables shine when you have large amounts of data. Imagine a retailer with thousands of rows of daily sales figures. Rather than scrolling through page after page, a pivot table lets the retailer instantly group the data by product, region, or quarter and see the totals that matter — in seconds.
Learn More About Pivot Tables
Try the same concepts in your browser on the WebPivotTable Demo Page.
A Brief History
The pivot table concept originated at Lotus Development Corporation with a program called Lotus Improv in 1987. Steve Jobs saw the software in 1988 and pushed for a NeXT version, which shipped in 1991; a Windows port followed in 1993.
Microsoft adopted the idea in Excel 5 (1994) and steadily expanded it — adding calculated fields in Excel 97 and pivot charts in Excel 2000. Today, pivot functionality appears across many platforms: Apache OpenOffice Calc, LibreOffice, Google Sheets (native support since 2011), and numerous BI tools from IBM, Oracle, SAP, SAS, MicroStrategy, and others.
Most of these tools can also query OLAP (Online Analytical Processing) servers directly, treating the pivot table as a lightweight client for multi-dimensional data analysis.
WebPivotTable brings this same capability to the modern web. Built on React and delivered as a standard Web Component, it provides rich pivot functionality for both in-memory data (CSV, Excel, Google Sheets) and OLAP server connections — all inside the browser.