The pivot table
web component.
One custom HTML element. Works in React, Vue, Angular, Svelte, or plain HTML. Full pivot tables, pivot charts, three data source modes, and native AI — no plugins.
Works with every major stack
Everything a pivot table should do
WPT ships feature-complete. No enterprise add-ons, no paid upgrades to unlock core functionality — it all works out of the box.
Full Pivot Table
Drag-and-drop fields, multi-level row/column headers, custom aggregations, grand totals, subtotals, conditional formatting, and freeze panes.
20+ Chart Types
Line, bar, column, area, pie, donut, scatter, bubble, heatmap, waterfall — all synchronized with the pivot view and exportable.
Three Data Source Modes
Memory mode (browser, CSV/Excel/JSON), Server mode (DuckDB, large files), OLAP mode (MDX, Cube.js, ClickHouse, Snowflake).
Built-in AI Analytics
Natural language pivot config, chart recommendations, cell explanation, anomaly detection. Works with OpenAI, Claude, Gemini, or any endpoint.
20 Languages
Full i18n support. English, Chinese, Spanish, French, German, Japanese, Korean, Arabic, and 12 more — switchable at runtime.
Web Component Standard
A single <web-pivot-table> element. No Shadow DOM leaks, zero global CSS, multiple isolated instances on one page.
Production-Grade Security
Inline style architecture, no CDN CSS injection, CSP-friendly. Server mode returns only aggregated results — raw data stays on your server.
Export & Integration
Export pivot data to CSV/Excel, charts to PNG/SVG. Full API for save/restore, programmatic control, and deep framework integration.
Fully Configurable
Options object controls every visual and behavioral aspect: themes, toolbar visibility, field order, number formats, and 100+ more settings.
Drop one element.
Get a full analytics app.
Load WPT from CDN or install via npm. Bind your data. Every feature — pivot table, charts, filters, AI chat — is included automatically. No configuration required to get started.
<!-- 1. Load from CDN -->
<script src="https://cdn.webpivottable.com/wpt/latest/wpt.js"></script>
<!-- 2. Place the element -->
<web-pivot-table
id="wpt"
style="width:100%;height:600px"
></web-pivot-table>
<!-- 3. Load your data -->
<script>
const wpt = document.getElementById('wpt')
wpt.setOptions({ locale: 'en' })
wpt.setWptFromCsvUrl('https://cdn.webpivottable.com/samples/sales.csv')
</script>Any data, any scale
Three purpose-built modes cover every deployment scenario, from a quick prototype with a CSV to enterprise OLAP cubes with billions of rows.
Browser-side computation
Load CSV, Excel, or JSON directly in the browser. Zero server cost. Works offline. Perfect for prototypes, internal tools, and dashboards where data fits in memory.
- ✓ CSV / Excel / JSON / WPT files
- ✓ Runs entirely in the browser
- ✓ Zero infrastructure required
- ✓ Free on all plans
DuckDB server-side analytics
For large files or sensitive data. The browser sends a query; the server runs DuckDB and returns only aggregated results. Raw data never leaves your server.
- ✓ Files of any size (GBs)
- ✓ Raw data stays on your server
- ✓ Powered by DuckDB
- ✓ Shared links with secure compute
Enterprise cube connections
Connect directly to OLAP cubes via MDX. Supports Cube.js, Microsoft Analysis Services, ClickHouse, Snowflake, BigQuery, and any XMLA-compatible source.
- ✓ MDX / XMLA protocol
- ✓ Cube.js, SSAS, ClickHouse
- ✓ Snowflake, BigQuery
- ✓ Enterprise & custom plans
How WPT compares
A straightforward feature comparison with the most commonly evaluated alternatives.
| Feature | WebPivotTable | Flexmonster | AG Grid Pivot | Handsontable |
|---|---|---|---|---|
| Web Component (any framework) | ✓ | — | — | — |
| Memory / CSV / Excel mode | ✓ | ✓ | ✓ | ✓ |
| Server-side DuckDB mode | ✓ | — | — | — |
| OLAP / MDX / XMLA mode | ✓ | ✓ | — | — |
| Built-in AI analytics | ✓ | — | — | — |
| 20+ chart types (Highcharts) | ✓ | ✓ | — | — |
| Free for non-commercial | ✓ | 30-day trial | Community | — |
| Developer license (one-time) | $299 | $800+/yr | N/A | $790/yr |
| Zero global CSS | ✓ | — | — | — |
| Multi-instance on one page | ✓ | partial | ✓ | ✓ |
| 20 UI languages | ✓ | — | — | — |
Simple, honest pricing
Free for non-commercial use, forever. Commercial licenses are one-time or annual — no per-seat tricks, no feature gating after purchase.