Everything includedEvery feature you need to
Every feature you need to
analyze your data
11 feature categories. 132+ individual features. All available in both the Community and commercial license tiers.
⊞Pivot Table
Powerful pivot in any app
Drag-and-drop pivot configuration with multi-level hierarchies, subtotals, and calculated fields — works exactly like Excel but in the browser.
Read the docs →✓
Drag & drop fields
Drag fields from the list into Rows, Columns, Filters, or Values zones. Reorder by dragging within a zone.
✓
Multi-level headers
Stack multiple fields in rows or columns to create hierarchical headers up to any depth.
✓
Expand / collapse
Expand or collapse individual branches of row/column headers to focus on relevant data.
✓
Grand totals
Configurable grand total row and column with position control (top/bottom, left/right).
✓
Subtotals
Subtotal rows/columns at each level of a hierarchy. Show or hide per field.
✓
Calculated fields
Define custom formula fields with arithmetic expressions over any numeric source fields.
✓
Swap axes
Instantly transpose rows and columns with a single click.
✓
Non-empty rows/columns
Automatically hide rows or columns where all values are empty or zero (OLAP mode).
✓
Undo / Redo
Full pivot state undo/redo history via Ctrl+Z / Ctrl+Y.
✓
Deferred update
Batch multiple field changes and apply them all at once with a Refresh click — essential for large datasets.
✓
Save & restore
Serialize the entire pivot state (including data) to a .wpt JSON file and restore it exactly later.
✓
Multiple instances
Any number of isolated <web-pivot-table> elements on the same page with zero cross-contamination.
🗄Data Sources
Connect any data source
Three processing modes cover everything from a small CSV to a billion-row OLAP cube. One consistent API regardless of where your data lives.
Read the docs →✓
Memory mode (CSV)
Load CSV or TSV files directly in the browser. No server required. Parses up to ~100 MB with full field detection.
✓
Memory mode (Excel)
Import .xls and .xlsx workbooks. Multi-sheet support with automatic field typing.
✓
Memory mode (JSON)
Load flat JSON arrays or structured { fields, data } objects from REST APIs.
✓
Google Sheets
Load from any public Google Sheet published as CSV — no API key required.
✓
Server mode (DuckDB)
Large file support with server-side DuckDB aggregation. Only pivot results reach the browser — raw data stays on your server.
✓
OLAP mode (XMLA)
Connect to SSAS, SAP BW, Kylin, Mondrian, or any XMLA-compliant cube server via MDX queries.
✓
Load from URL
Fetch CSV, Excel, or JSON directly from any URL. Cross-origin files route through your optional file proxy.
✓
Drag & drop files
Drag local files directly onto the component to load them without a file picker.
✓
JavaScript arrays
Supply data programmatically via setWptFromDataArray() — ideal for dynamic data pipelines.
✓
File proxy support
Route cross-origin file fetches through your server-side proxy to handle CORS and authentication.
✓
XMLA proxy support
Route MDX queries through your server to hide OLAP credentials and bypass CORS restrictions.
✓
HTTP Basic Auth
Configure username/password authentication for proxy-protected data sources.
∑Aggregation
Every aggregation you need
10 aggregation functions, 8 Show Values As modes, running totals, date grouping, and sparkline display — all per-field and fully configurable.
Read the docs →✓
Sum
Sum all non-null values in the group. Default aggregation for numeric fields.
✓
Count / Distinct Count
Count all non-null rows, or count only unique values within each cell.
✓
Average
Arithmetic mean of all values in the group.
✓
Min / Max
Minimum and maximum value within each pivot cell.
✓
Median / Mode
Statistical median (middle value) and mode (most frequent value).
✓
Standard Deviation / Variance
Population standard deviation and variance for statistical analysis.
✓
Percentile (Inc / Exc)
Configurable Nth percentile with inclusive or exclusive interpolation.
✓
% of Grand/Column/Row Total
Show each cell as a percentage of the overall total, or of its column or row total.
✓
% of Parent Total
Show each cell relative to its parent row or column subtotal — great for hierarchy breakdown.
✓
Running Total
Cumulative sum along rows (time-series) or columns (category accumulation).
✓
Date grouping
Automatically group date or timestamp fields by Year, Quarter, Month, Week, or Day.
✓
Sparkline display
Render value fields as inline mini-charts inside the grid cells instead of numbers.
⧩Filtering & Sorting
Precision control over what you see
Label filters, value filters, Top-N, formula-based filtering, and multi-criteria sort — giving users full control over the slice of data they analyze.
Read the docs →✓
Manual label include
Check individual values to include only those labels in the pivot.
✓
Manual label exclude
Check individual values to exclude them from the pivot output.
✓
Formula label filter
17 formula operators: equals, contains, begins with, between, not-between, and more.
✓
Value filter
Filter rows/columns where an aggregated value field meets a comparison condition.
✓
Top N / Bottom N
Show only the top or bottom N items ranked by a chosen value field.
✓
Sort by label
Sort row/column labels alphabetically ascending or descending.
✓
Sort by value
Sort rows/columns by an aggregated value field — find your best/worst performers instantly.
✓
Multi-field simultaneous filters
Apply independent filters to multiple row/column fields at the same time.
✓
Filter zone
Place fields in the Filters zone to show a dropdown filter picker without adding them to rows/columns.
✓
Clear all filters
One-click to remove all active filters while preserving the field layout.
✓
Custom field names
Rename any dimension field or value field in the pivot without changing source data.
✓
Hide subtotals per field
Suppress subtotal rows/columns for specific fields independently of others.
📈Charts
20+ chart types, powered by Highcharts
From simple bar charts to 3D bubbles and treemaps — every chart type responds to your pivot data automatically with full export support.
Read the docs →✓
Column & Bar
Vertical and horizontal bar charts. Stacked and grouped variants.
✓
Line & Spline
Line chart and smooth spline variant. Ideal for time-series trends.
✓
Area & Area-Spline
Area charts with fill. Stacked area for part-to-whole visualization.
✓
Pie & Donut
Classic pie and donut charts for proportional distribution.
✓
Scatter & Bubble
Scatter plot and bubble chart for correlation analysis.
✓
Heatmap
Color-intensity matrix for comparing values across two dimensions.
✓
Treemap
Hierarchical area-proportional visualization.
✓
Waterfall
Running total visualization for variance analysis.
✓
Funnel & Pyramid
Funnel and pyramid charts for pipeline and hierarchy visualization.
✓
Gauge
Speedometer-style gauge for single KPI display.
✓
Box Plot
Statistical distribution visualization with quartiles and outliers.
✓
3D chart variants
Column, bar, pie, and scatter in full 3D rendering.
⊞Grid Display
A grid built for analysis
Freeze, resize, drill, and format. The pivot grid handles millions of cells with smooth scrolling and precise visual control.
Read the docs →✓
Freeze rows
Sticky column header row that stays visible while scrolling vertically.
✓
Freeze columns
Sticky row header columns that stay visible while scrolling horizontally.
✓
Column resize
Drag column borders to resize. Double-click a border to auto-fit to content.
✓
Conditional formatting
Apply color scale, data bar, or icon set rules to value cells based on their numeric magnitude.
✓
Drill-through
Double-click any data cell to open a modal showing the underlying raw source rows.
✓
OLAP drill-through
Execute DRILLTHROUGH MDX queries for OLAP cubes with configurable max rows.
✓
Number format per field
Independent number formatting per value field: General, Number, Currency, Percentage.
✓
Negative number styles
Choose from 7 display options: minus sign, parentheses, red text, or combinations.
✓
Row style callbacks
Programmatically style entire rows based on their underlying data values.
✓
Cell style callbacks
Programmatically style individual cells based on column and row context.
✓
AI cell explain
Hover any cell to see an AI-powered explanation of the value in context.
✓
Expand / collapse hierarchy
Multi-level row/column headers can be expanded or collapsed independently.
🤖AI Integration
Your data, understood by AI
Connect any LLM to get natural-language pivot configuration, narrative insights, anomaly detection, and cell explanations — all in one chat panel.
Read the docs →✓
Natural language queries
Type "show revenue by region as a bar chart" and WPT configures the pivot automatically.
✓
OpenAI GPT-4o support
Connect GPT-4o-mini or GPT-4o with your API key. Best-in-class natural language pivot understanding.
✓
Anthropic Claude support
Use Claude 3.5 Sonnet or any Claude model via the Anthropic API.
✓
Google Gemini support
Connect Gemini 1.5 Flash or Pro via the Google Generative Language API.
✓
Custom OpenAI-compatible endpoints
Point WPT at any OpenAI-compatible API — local models, Azure OpenAI, DeepSeek, etc.
✓
Backend proxy support
Route all LLM calls through your own server to keep API keys off the client.
✓
Custom system prompt
Prepend a custom system prompt to every LLM request for domain-specific guidance.
✓
AI Insights
Generate a narrative summary of the currently displayed pivot data with one click.
✓
Cell value explanation
Click any cell to ask AI why that value is what it is, given the surrounding context.
✓
Anomaly detection
Client-side z-score outlier detection. No LLM required — free and private.
✓
Field catalog context
WPT automatically includes field names, types, and sample values as LLM context for better answers.
✓
Chat history
Full conversation history within the AI tab. Clear history with one API call.
</>Developer API
A developer-first component
Standard Web Component with a rich JavaScript API, TypeScript declarations, isolated event buses, and integration guides for every major framework.
Read the docs →✓
Standard Web Component
Built on the customElements standard — no proprietary wrapper required. Works anywhere HTML runs.
✓
React integration
Use as a JSX element with a ref. Full TypeScript types for all methods and events.
✓
Vue 3 integration
Use directly in <template> with ref. Lifecycle hooks map naturally to WPT events.
✓
Angular integration
Register with CUSTOM_ELEMENTS_SCHEMA. Access via @ViewChild and nativeElement.
✓
Svelte integration
Use with bind:this for imperative access. Reactive data sync via onMount.
✓
TypeScript declarations
Full .d.ts types exported: WptOptions, WebPivotTableElement, all method signatures.
✓
Isolated event bus
Per-instance event bus — multiple WPT elements never cross-fire events.
✓
DOM CustomEvents
All events also dispatch as standard DOM CustomEvents for addEventListener() compatibility.
✓
Pivot state API
getPivotState() / configurePivot() for programmatic pivot read/write.
✓
Field catalog API
getFieldCatalog() returns structured field metadata ready for LLM context injection.
✓
CDN or npm
Load from https://cdn.webpivottable.com or install via npm. Single-file bundle, no dependencies to manage.
✓
WPT file API
generateWptString() / setWpt() for save/restore cycles with any storage backend.
🌐i18n
20 languages, zero config
Full internationalization with lazy-loaded locale files, runtime language switching, and self-hosting support.
Read the docs →✓
English
Built-in default. No external file required.
✓
Chinese (Simplified)
Built-in. No external file required.
✓
German, French, Spanish
Loaded lazily from CDN on first use.
✓
Portuguese, Italian, Turkish
Loaded lazily from CDN on first use.
✓
Japanese, Korean
Loaded lazily from CDN on first use.
✓
Russian, Polish, Dutch, Swedish
Loaded lazily from CDN on first use.
✓
Arabic, Czech, Hungarian
Loaded lazily from CDN on first use.
✓
Romanian, Danish, Finnish
Loaded lazily from CDN on first use.
✓
Runtime locale switching
Switch language at any time with setLocale("fr") — no page reload needed.
✓
Self-hosted locale files
Set localeBaseUrl to serve locale JSON from your own CDN or server.
✓
Per-instance locale
Multiple WPT instances on the same page can each show a different language.
✓
Locale caching
Locale files are cached in memory — language switches are instantaneous after the first load.
🎨Theming
Beautiful in every color scheme
4 built-in presets plus complete CSS custom-property control — no global style pollution, no Shadow DOM limitations.
Read the docs →✓
Default theme
Clean light theme with blue accents. Professional and neutral.
✓
Dark theme
Full dark mode with carefully balanced contrast ratios.
✓
Ocean theme
Teal and navy color palette for a modern, calm aesthetic.
✓
Forest theme
Green-toned palette for data-dense dashboards.
✓
Custom primary color
Override the accent/brand color to match your product.
✓
Custom background & panel colors
Set background, panel, secondary, and tertiary surface colors independently.
✓
Custom border & text colors
Fine-grained control over border and text colors at every level.
✓
Custom grid header colors
Set the pivot grid header row/column background and text colors separately from the UI chrome.
✓
Custom typography
Override font size and line height. Inherits font-family from the host page.
✓
Custom border radius
Control the roundness of buttons, inputs, and cards.
✓
Per-instance theming
Apply a different theme to each WPT instance on the same page.
✓
No CSS leakage
All styles are scoped inline — WPT never pollutes the global stylesheet.
↗Export
Share your analysis everywhere
Export the pivot grid, chart, or raw source data to Excel, PDF, HTML, CSV, or PNG — all from the browser with no server round-trips.
Read the docs →✓
Export grid to Excel (.xlsx)
Download the full pivot table as a formatted .xlsx Excel workbook.
✓
Export grid to PDF
Download the pivot table as a paginated PDF document.
✓
Export grid to HTML
Save the pivot table as a standalone self-contained HTML file.
✓
Print grid
Send the pivot table directly to the browser print dialog with proper pagination.
✓
Export chart as PNG
Download the current chart as a high-resolution PNG image.
✓
Export chart as PDF
Download the current chart as a PDF at its full rendered dimensions.
✓
Print chart
Print the chart in isolation (no surrounding UI chrome) via an iframe.
✓
Export source data to Excel
Download the raw unprocessed source data as a .xlsx file.
✓
Export source data to CSV
Download the raw source data as a .csv file.
✓
Print source data
Print the raw source data as a formatted HTML table.
✓
Export drill-through data
Export the drill-through result set (CSV or Excel) from the drill-through modal.
✓
WPT file save
Save the complete pivot state (layout + optional data) as a .wpt JSON file.
All features are available on every plan
No feature gating. The Community license includes 100% of WPT's functionality.
Paid licenses only add commercial rights and watermark removal.
11
Feature categories
130+
Individual features
20+
Chart types
20
UI languages
10
Aggregation functions
3
Data source modes