# handsontable/hyperformula

HyperFormula is an open-source headless spreadsheet for business web apps. It comes with over 400 formulas, CRUD operations, undo-redo, clipboard support, and sorting.

Repository: https://github.com/handsontable/hyperformula
Canonical: https://ross.abutalabs.com/products/hyperformula
Homepage: https://hyperformula.handsontable.com/
Language: TypeScript
License: NOASSERTION
License Family: other
Topics: calculation-engine, formula, typescript, evaluator, spreadsheet, excel, xlsx, headless-spreadsheet, forms, sheets, xls
Last push: 2026-08-26T03:34:35+00:00

## Health v2 (maintenance only)
Score: 94/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 99, release rhythm 85, longevity 100
- inputs: {"age_days": 2549, "days_push": 7, "days_rel": 23, "gap_med": 73.5, "n_releases_24m": 7}
- flags: no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 2771, forks 169 (observed 2026-08-28T04:07:18.912334+00:00)

## What it is
HyperFormula is an open-source headless spreadsheet engine written in TypeScript that parses and evaluates Excel-compatible spreadsheet formulas. It provides ~400 built-in functions, CRUD operations, undo-redo, clipboard support, and sorting, and runs in the browser or on Node.js backends.

## Use cases
- evaluate Excel formulas in a web app
- add calculated fields to a CRM or ERP
- build a custom spreadsheet-like application
- implement a form builder with formula support
- create an online calculator
- use a deterministic compute layer for AI and LLM workflows
- run spreadsheet calculations on a Node.js backend

## When to choose
- you need Excel/Google Sheets-compatible formula evaluation with deterministic results
- you want spreadsheet calculation logic without any bundled UI
- you need high-speed recalculation with a dependency graph and undo-redo
- you want to embed formula-driven business logic in frontend frameworks or backend services

## When to avoid
- you need a full spreadsheet UI component rather than a headless engine
- your project is incompatible with GPLv3 and you cannot purchase a proprietary license
- you need to parse complex .xlsx files with charts and formatting rather than compute formulas
- you need non-deterministic or volatile external data recalculation beyond the engine's scope

## Facets
- artifact type: library
- maturity: active
- function: parser, interpreter, sdk
- domain: web-development, developer-tools, spreadsheets, apis
- platform: browser, cross-platform
- tags: spreadsheet-engine, excel-formulas, headless, calculation-engine, typescript, formula-evaluator, openformula, crud, undo-redo, nodejs, web-server

## Member repositories
- handsontable/hyperformula (main) score 94

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:07:18.912334+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T08:16:39.387148+00:00, confidence not recorded.
  - readme: https://github.com/handsontable/hyperformula (fetched 2026-08-28T04:07:18.912334+00:00, sha 37c71bf1dfc8)
  - homepage: https://hyperformula.handsontable.com/ (fetched 2026-08-29T09:56:20.412959+00:00, sha f7c0037611ef)
  - site_page: https://hyperformula.handsontable.com/docs (fetched 2026-08-29T09:56:20.422180+00:00, sha f1ef703e45c1)
  - site_page: https://hyperformula.handsontable.com/docs/guide/license-key.html (fetched 2026-08-29T09:56:20.424064+00:00, sha 5f82596fe70f)
  - site_page: https://hyperformula.handsontable.com/docs/guide/demo.html (fetched 2026-08-29T09:56:20.425705+00:00, sha b95aa6405994)
  - registry_npm: https://registry.npmjs.org/hyperformula (fetched 2026-08-29T09:56:20.427570+00:00, sha eb0acdc1bfe9)
- Data as of 2026-08-30T08:39:29.467469+00:00.
