Among all pivot table implementations, Microsoft Excel is the most well-known. Millions of people rely on it every day. So why consider WebPivotTable?
Web Based
Traditional pivot table tools like Excel are desktop software — you need to install them on every machine and manage licences for each seat. Upgrades mean another round of installations.
WebPivotTable runs entirely in the browser. Deploy it once and everyone in your organisation can access it from any device — desktop, tablet, or phone — over any network. Updates happen on the server side; end users do nothing.
Easy to Use
WebPivotTable is purpose-built for pivot analysis, so its interface stays focused and intuitive. There are no menus full of unrelated spreadsheet features — everything you need is visible at a glance. Drag a few fields, and analytic results appear as grids and charts instantly.
The learning curve is minimal, which makes WebPivotTable a great way to bring self-service analytics to everyone in the organisation, not just specialist data analysts.
Powerful
Easy to use does not mean limited. WebPivotTable covers the full range of enterprise data analysis needs.
Wide data source support
Load and analyse data from CSV files, Excel files, and Google Sheets — whether they are on a local drive, a cloud service, or any URL on the web.
Connect directly to OLAP cubes via the XMLA protocol, the industry standard supported by Microsoft Analysis Services, Mondrian, Oracle Essbase, IBM DB2 OLAP, SAS, SAP, and others.
Use the provided APIs to feed data from any back-end system, including SQL databases and big-data stores.
Full-featured pivot analysis
WebPivotTable implements virtually every feature found in Excel Pivot Tables, with a more intuitive interface. Create multiple pivot tables and charts at the same time, each based on different data sources. Switch between grid and chart views seamlessly — changes in one view are reflected in the other automatically.
Customise summarisation functions, sorting, filtering, and number formats with ease. Add calculated fields using any valid JavaScript expression built from existing fields, constants, math functions, and conditional logic.
Fine-tune the appearance of tables and charts: size, theme, layout, totals, subtotals, chart types, legends, tooltips, and more — all in real time.
Flexible reporting
Build reports from any combination of pivot tables and charts. Export to PDF, HTML, PNG, JPEG, or GIF. Each table or chart can also be exported individually.
Integration
WebPivotTable is delivered as a standard Web Component (<web-pivot-table>).
Drop it into any web page or application — React, Vue, Angular, or plain HTML.
Import one JavaScript file, add the tag, and you are up and running. A rich set
of Options and APIs let developers customise every
aspect of the component.
Beyond web applications, WebPivotTable can be embedded in BI products and SaaS solutions.
Save & Share
Save your data and analysis to a compact WPT file at any time — to your local drive or to a back-end server. Re-open the file later and everything is restored exactly as you left it.
Free & Open
WebPivotTable is completely free — for individuals, teams, and companies alike. There are no licence fees, no usage limits, and no paywalls for advanced features. Everyone gets the full power of WebPivotTable at zero cost.