Natural Language Pivot
Type "show revenue by region as a bar chart" and the AI configures rows, columns, values, and chart type instantly.
WebPivotTable — AI Meets Pivot Analytics
A full-featured web component delivering pivot tables and pivot charts with an Excel-like analysis experience, now supercharged with built-in AI that understands your data.
Ask questions in plain English — the built-in AI assistant configures pivots, generates charts, explains cells, and detects anomalies automatically.
Built-in AI Analytics
The first pivot table component with native AI integration. Ask questions, get answers — no plugins, no add-ons.
“Show me revenue by region as a bar chart”
Done! I've configured the pivot with Region on rows, Revenue as the value, and switched to a bar chart.
“Which values look unusual?”
I found 3 anomalies: APAC Q3 revenue is 2.4σ above the mean, likely driven by the product launch...
What the AI Can Do
- Configure pivots — set rows, columns, values, and filters from a chat message
- Generate charts — line, bar, column, pie, area, scatter, and more
- Explain cells — right-click any value for a plain-language breakdown
- Detect anomalies — automatic statistical outlier detection with explanations
- Multiple providers — OpenAI, Anthropic, Google Gemini, or custom endpoints
- Your language — AI responds in the same language as your locale (19 supported)
AI Capabilities
Every major AI feature, purpose-built for pivot table analytics.
Cell Explanation
Right-click any cell and ask AI to explain how the value was calculated, with full context from neighboring rows and columns.
Anomaly Detection
AI automatically scans your pivot data, flags statistical outliers, and explains why each data point is unusual.
Chart Recommendations
Describe your analysis goal in words — trend, comparison, distribution — and AI selects the optimal chart type and configuration.
Multi-Provider Support
Works with OpenAI, Anthropic Claude, Google Gemini, or any custom AI endpoint. Switch providers with zero code changes.
Multilingual AI
AI responds in the same language as your locale setting — 19 languages supported, from English to Japanese to Arabic.
Try It Online
Load sample datasets, open the AI chat panel, switch languages, and control the pivot table from outside — all running live in your browser.
What Is a Web Component?
A Web Component is a standards-based custom HTML element built into modern browsers.
Native Browser Standard
Web Components are native browser technology, not tied to any single JavaScript framework.
Use Anywhere
The same <web-pivot-table> element works in React, Vue, Angular, Svelte, and plain HTML.
No Framework Required
You can embed and run WPT directly with script tags and HTML, with no framework dependency.
Business Value
What teams gain from a full-function pivot table and pivot chart component.
AI-Powered Analytics
Chat with your data in plain language. The built-in AI assistant configures pivots, generates charts, explains cell values, and surfaces anomalies — no manual setup needed.
Web Component by Design
Use one standards-based custom element in any framework or in plain HTML with no framework lock-in.
Full Pivot Table + Pivot Charts
Deliver a complete pivot analysis experience with interactive pivot tables and pivot charts.
Excel-Like Experience
All core capabilities are available at no cost for personal, educational, and commercial use.
Production Ready
Supports production delivery with export, localization, and enterprise-friendly configuration.
Documentation
Fast access to implementation and operational references used most in delivery cycles.
Introduction
Open →WebPivotTable — a powerful pivot table component for the web
AI Integration
Open →AI Integration WebPivotTable includes a built in AI assistant that lets users interact with pivot data through natural language. Users can configure pivots, gen…
Why WebPivotTable?
Open →Why choose WebPivotTable for your data analysis needs?
Use Cases
Representative analytics workflows aligned to business and reporting needs.
AI Chat Analytics
Ask the AI to build pivot views, switch chart types, explain cell values, and detect anomalies — all through natural language conversation.
Sales Performance Demo
Analyze revenue performance by country, segment, and quarter with drill-down exploration.
Operational KPI Demo
Monitor lead time, cycle time, and throughput by team and product area.
Financial Reporting Demo
Review monthly P&L-style reporting with custom formatting and export workflows.
Adoption Model
Clear expectations for usage rights, source-available terms, and support coverage.
Free Usage Rights
Use WPT at no cost across personal, educational, internal, and commercial deployments.
Source-Available Terms
Integrate with confidence under the published source-available policy and usage terms.
Support Coverage
Support is provided on a best-effort basis through documentation and issue triage.