Bring Excel Formulas
to your app

Run complex calculations at high speed. Power spreadsheet logic inside your application.

Read the docs Pricing

Trusted by:

server.ts

const hf = HyperFormula.buildEmpty();
hf.setCellContents({
  sheet: 0, row: 2, col: 1
}, '=B1*B2');
// Deterministic, exact result
const result = hf.getCellValue(...);

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.

use familiar Excel-inspired formulas without full spreadsheet complexity
enable only the functions your application needs
reference data using named expressions or simple inputs
support both simple formulas and more advanced calculation logic

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.

Deterministic results: Get consistent, bug-free outputs every time formulas run.
Familiar formula language: Use Excel syntax as a universal way to define calculations; easy for both developers and end users.
High performance: Run calculations faster and with less overhead than a full spreadsheet application.
Flexible integration: Open-source, headless, and compatible with both browser and server environments.

Independently security-audited Verified through penetration testing and code review against OWASP standards, backed by an official certificate from TestArmy. View certificate →

Hundreds of Excel functions. Ready to run.

A library of ~400 built-in functions covering major categories used in spreadsheet applications. Fully compatible with Microsoft Excel and Google Sheets syntax.

run real spreadsheet formulas without modification
support complex calculation models
work with familiar, widely used syntax

Array Manipulation

Includes: ARRAYFORMULA, FILTER, ARRAY_CONSTRAIN

Date and Time

Includes: DATE, DAY, MONTH, YEAR, NOW, TODAY

Engineering

Includes: BIN2DEC, DEC2HEX, HEX2BIN, etc.

Financial

Includes: PMT, NPV, IRR, RATE, etc.

Information

Includes: ISBLANK, ISNUMBER, ISTEXT, etc.

Logical

Includes: IF, AND, OR, NOT, XOR

Lookup and Reference

Includes: VLOOKUP, HLOOKUP, MATCH, INDEX, CHOOSE

Mathematical and Trig

Includes: SUM, PRODUCT, SIN, COS, ROUND, INT

Matrix Functions

Includes: MMULT, MDETERM, TRANSPOSE, etc.

Statistical

Includes: AVERAGE, COUNT, STDEV, MEDIAN, etc.

Text

Includes: LEFT, RIGHT, MID, LEN, TEXT, SEARCH, FIND

Error Handling

Includes: IFERROR, IFNA, ERROR.TYPE

Database

Functions like DAVERAGE, DCOUNT, DSUM are not implemented

Cube

OLAP-related functions (e.g. CUBEMEMBER, CUBEVALUE) are unsupported

Compatibility

Functions mostly for Excel/ODF compatibility (e.g. GETPIVOTDATA)

Web/External Data

Functions like WEBSERVICE, FILTERXML are out of scope

Simulate Excel behavior

Run Excel spreadsheets programmatically inside your application.

Server-side and browser-side execution

Run spreadsheet calculations in both backend systems and frontend apps.

Calculated fields in CRM, ERP tools

Define business logic directly within your data models.

Familiar syntax

Work with standard formula language, easily written by AI and understandable for humans.

Math engine for AI apps

Provide a reliable way for a LLM model to run complex calculations deterministically.

Formulas inside spreadsheet-like apps

Keep calculations live and responsive as users edit data.

[Our feature] Mark Books is made by formulas so we needed to support this throughout – and Handsontable does this seamlessly.

Alistair Price
Managing Director at iSAMS

The next bit I always come back to is the support and the forums and getting answers quickly. That was key for us.

Dave Stewart
Asterisk Networks

Resources

GitHub

Explore HyperFormula source code, contribute, and track development progress.

View on GitHub →

Documentation

Learn how to design, develop, and implement HyperFormula with the official guide.

Read the Docs →

Demo

Explore interactive and customizable data grid in action.

Live Demo →

Bring Excel Formulasto your app

Spreadsheets run critical calculations.Bring them into your software.