Newest
v3.5.0
2026-10-09
- New license key format: a key can grant a subset of the library
- MOD follows the sign of the divisor, as in Excel and Google Sheets
- VAR, STDEV, SLOPE and STEYX keep precision on narrow-spread data
The engine before the grid
The open-source spreadsheet engine behind Handsontable DataGrid’s formulas. It parses Excel-compatible formulas, resolves dependencies, and recomputes — headless, in Node, in a worker, or in your ETL pipeline.
| Line | Q1 | Q2 | Q3 | Q4 | Total |
|---|---|---|---|---|---|
| Units | 660 | ||||
| Price | $42 | ||||
| Revenue | $4,800 | $6,000 | $7,560 | $9,240 | $27,600 |
| Cost | $2,160 | $2,700 | $3,240 | $3,780 | $11,880 |
| Profit | $2,640 | $3,300 | $4,320 | $5,460 | $15,720 |
| Margin | 55.0% | 55.0% | 57.1% | 59.1% | 57.0% |
Units and price are inputs — every other cell is a formula.
Trusted by
Spreadsheets run critical calculations. Bring them into your software.
Financial models, pricing rules, forecasts, and operational logic often live in spreadsheet formulas. But Excel wasn't designed to run inside modern applications.
HyperFormula bridges this gap with a deterministic spreadsheet engine. Built as a TypeScript library, it executes Excel-compatible formulas with exact and repeatable results, making spreadsheet calculations a native part of your system.
Run calculations. Recompute results. Power spreadsheet logic directly in your software.
Custom calculated fields in business software.
The power of formulas extends beyond spreadsheets. Applications like CRMs, ERP systems, and reporting tools rely on flexible, user-defined computations, often as calculated fields. HyperFormula brings formula-based logic directly into your product. Let users define calculated fields, dynamic rules, and custom logic using familiar Excel-inspired syntax.
- Excel-style formulas without a whole spreadsheet around them
- Only the functions your application needs, enabled
- Data referenced through named expressions or plain inputs
- From one-line formulas to full calculation models
Your UI. Our calculation engine.
HyperFormula separates calculation logic from presentation, giving you full control over how spreadsheet functionality is integrated into your application.
Use it inside custom interfaces, any frontend framework or backend systems while HyperFormula handles formula parsing, evaluation, and recalculation.
Build your own experience, integrate with existing tools, or plug it into your backend without being tied to any framework or UI layer.
Ready for production. Reliable, fast, and flexible.
In public release since June 2020, and running inside every Handsontable DataGrid instance that uses the Formulas plugin.
- Deterministic results
- The same formula over the same data returns the same result, every time it runs.
- Familiar formula language
- Use Excel syntax as a universal way to define calculations; easy for both developers and end users.
- High performance
- A dependency graph recalculates only the cells a change reaches, with no spreadsheet application to start first.
- Flexible integration
- Open-source, headless, and compatible with both browser and server environments.
In the words of
the teams who built on it
“Mark Books is made by formulas so we needed to support this throughout – and Handsontable does this seamlessly.”
Alistair PriceManaging Director, iSAMS“Whenever we had a question, we always got an answer. It was brilliant.”
Dave StewartLead Front-End Developer, Asterisk NetworksIndependently security-audited
Penetration-tested and code-reviewed by TestArmy against OWASP ASVS and the OWASP Top 10, dependencies included. The certificate covers HyperFormula 3.3.0.
View the certificatePredictable by design.
A minor release about once a quarter, patches between them, and semantic versioning throughout. Every change is listed in the changelog.
v3.4.0
2026-08-10
- Function metadata: getAvailableFunctions() and getFunctionDetails()
- New functions: VSTACK, HSTACK, XIRR, UNIQUE and SORT
- Indonesian language pack
v3.3.0
2026-05-20
- Twelve database functions, DSUM to DVARP
- PERCENTILE and QUARTILE, with their .INC and .EXC forms
- Memory leaks fixed in lazy transformations and undo/redo
v3.2.0
2026-02-19
- New functions: IRR, N and VALUE
- Big spreadsheets load without an error map overflow
v3.1.1
2025-12-18
- Cells recalculate after sheets are added, removed or renamed
- Overwriting a non-computed cell no longer throws
Built by people who ship data tools daily
Formulas use the syntax of Microsoft Excel and Google Sheets. Every figure here is counted at build time, from the engine this page ships with and from Microsoft’s own list of Excel functions.
Meet the team- formula functions
- 408
- of Excel’s functions
- 74%
- locales
- 18
- releases since 2020
- 37
Compatibility
37/41PERCENTILE()STDEV()NORMDIST()
Database
12/12DSUM()DCOUNT()DAVERAGE()
Date and time
25/25NOW()DATEDIF()WORKDAY()
Engineering
50/54HEX2DEC()BIN2DEC()COMPLEX()
Financial
29/55NPV()IRR()PMT()
Information
16/22ISBLANK()ISNUMBER()ISERROR()
Logical
11/19IF()IFS()AND()
Lookup and reference
20/40XLOOKUP()VLOOKUP()INDEX()
Math and trigonometry
76/83SUM()ROUND()POWER()
Statistical
86/111AVERAGE()MEDIAN()STDEV.S()
Text
24/49TEXTJOIN()LEFT()SUBSTITUTE()
Coverage of Microsoft Excel’s own function list, category by category. Cube and web functions are out of scope. HyperFormula’s own functions and those from Google Sheets, such as ARRAYFORMULA and SPLIT, count toward the total but not toward Excel’s list.
Make every data point count. Turn millions of them into actionable wisdom.
Let’s make it easier.
Smoother. Faster. All Handsontable.