# pivotkit

> Pivot reports for the web and the command line: people load their own file, drag fields, filter, chart and export to Excel; views are safe JSON files that a CLI renders again from the source data. React, web component, engine, CLI, REST service and MCP server. MIT.

pivotkit is a pivot report builder for the web, with Excel's PivotTable as the reference, MIT licensed.
npm packages: pivotkit-core (the engine, plain JavaScript for the browser and Node), pivotkit-react
(the React 18 and 19 component `<PivotReport>`), pivotkit-element (the web component `<pivot-report>`),
pivotkit-xlsx (a reader plugin for Excel workbooks), pivotkit-report (JSON, CSV, XLSX, SVG and a
printable HTML report without a browser), pivotkit-cli (the command line `pivotkit`), pivotkit-server (a REST service with an OpenAPI document, and a container image with the REST service, the MCP server and the CLI) and pivotkit-mcp (an MCP server for AI clients). A report is a JSON view, checked as untrusted
input; its format and JSON Schema are on the page "View file format". llms-full.txt holds every page
listed here in one file.

## Start

- [Home](<https://pivotkit.eize.dev/index.md>)
- [Comparison](<https://pivotkit.eize.dev/compare/index.md>)
- [Features](<https://pivotkit.eize.dev/features/index.md>)
- [FAQ](<https://pivotkit.eize.dev/faq/index.md>)
- [Security](<https://pivotkit.eize.dev/security/index.md>)
- [Privacy for operators](<https://pivotkit.eize.dev/privacy/index.md>)
- [Browser support](<https://pivotkit.eize.dev/browser-support/index.md>)
- [Live demo](<https://pivotkit.eize.dev/demo/index.md>)

## Use a report (for the people who build reports)

- [Behaviour reference](<https://pivotkit.eize.dev/use/behaviour/index.md>)
- [Charts](<https://pivotkit.eize.dev/use/charts/index.md>)
- [The rows behind a number](<https://pivotkit.eize.dev/use/drill-down/index.md>)
- [Export and copy](<https://pivotkit.eize.dev/use/export/index.md>)
- [Fields, zones and the table](<https://pivotkit.eize.dev/use/fields/index.md>)
- [Filters, top N and sorting](<https://pivotkit.eize.dev/use/filters/index.md>)
- [Overview](<https://pivotkit.eize.dev/use/index.md>)
- [Keyboard and screen readers](<https://pivotkit.eize.dev/use/keyboard/index.md>)
- [Small screens, menus and tips](<https://pivotkit.eize.dev/use/layout/index.md>)
- [Load your own data](<https://pivotkit.eize.dev/use/load-data/index.md>)
- [Quick start](<https://pivotkit.eize.dev/use/quick-start/index.md>)
- [Values and formats](<https://pivotkit.eize.dev/use/values/index.md>)
- [Views, saving and sharing](<https://pivotkit.eize.dev/use/views/index.md>)
- [Learn with real data](<https://pivotkit.eize.dev/learn/index.md>)

## Embed pivotkit (for developers)

- [Overview](<https://pivotkit.eize.dev/embed/index.md>)
- [Recipes](<https://pivotkit.eize.dev/embed/recipes/index.md>)
- [Getting started: command line](<https://pivotkit.eize.dev/getting-started/cli/index.md>)
- [Getting started: engine only](<https://pivotkit.eize.dev/getting-started/engine/index.md>)
- [Getting started: MCP server](<https://pivotkit.eize.dev/getting-started/mcp/index.md>)
- [Getting started: React](<https://pivotkit.eize.dev/getting-started/react/index.md>)
- [Getting started: reports in code](<https://pivotkit.eize.dev/getting-started/report/index.md>)
- [Getting started: REST service](<https://pivotkit.eize.dev/getting-started/rest/index.md>)
- [Upgrading](<https://pivotkit.eize.dev/getting-started/upgrading/index.md>)
- [Getting started: web component](<https://pivotkit.eize.dev/getting-started/web-component/index.md>)

## Concepts

- [Charts](<https://pivotkit.eize.dev/concepts/charts/index.md>)
- [Dates and number ranges](<https://pivotkit.eize.dev/concepts/dates/index.md>)
- [Field descriptions and names](<https://pivotkit.eize.dev/concepts/fields/index.md>)
- [Filters, top N and sorting](<https://pivotkit.eize.dev/concepts/filters/index.md>)
- [Locale, time zones, limits and errors](<https://pivotkit.eize.dev/concepts/limits/index.md>)
- [Sharing and keeping a view](<https://pivotkit.eize.dev/concepts/sharing/index.md>)
- [Templates and shared views](<https://pivotkit.eize.dev/concepts/templates/index.md>)
- [Values: aggregators, show as, formats](<https://pivotkit.eize.dev/concepts/values/index.md>)
- [Views and saved views](<https://pivotkit.eize.dev/concepts/views/index.md>)

## Reference

- [pivotkit-cli](<https://pivotkit.eize.dev/reference/cli/index.md>)
- [Container image](<https://pivotkit.eize.dev/reference/container/index.md>)
- [pivotkit-core](<https://pivotkit.eize.dev/reference/core/index.md>)
- [pivotkit-element](<https://pivotkit.eize.dev/reference/element/index.md>)
- [Loading files](<https://pivotkit.eize.dev/reference/import/index.md>)
- [Localisation](<https://pivotkit.eize.dev/reference/localisation/index.md>)
- [pivotkit-mcp](<https://pivotkit.eize.dev/reference/mcp/index.md>)
- [Plugins](<https://pivotkit.eize.dev/reference/plugins/index.md>)
- [Print template](<https://pivotkit.eize.dev/reference/print-template/index.md>)
- [pivotkit-react props](<https://pivotkit.eize.dev/reference/react/index.md>)
- [pivotkit-report](<https://pivotkit.eize.dev/reference/report/index.md>)
- [pivotkit-server (REST)](<https://pivotkit.eize.dev/reference/rest/index.md>)
- [Theming](<https://pivotkit.eize.dev/reference/theming/index.md>)
- [View file format](<https://pivotkit.eize.dev/reference/view-file/index.md>)
- [Write a plugin](<https://pivotkit.eize.dev/reference/write-a-plugin/index.md>)