HyperFormula AI SDK for Vercel

A Vercel AI SDK tool that gives your agents deterministic spreadsheet and formula computation — backed by HyperFormula’s Excel-compatible engine.

What it does

Evaluate formulas deterministically — your agent runs any Excel-compatible formula through HyperFormula instead of asking the LLM to do math. Results are exact, reproducible, and auditable.
Read and write cells and ranges — the agent inspects, populates, or modifies sheet data through typed tool calls.
Trace dependencies — precedents and dependents are surfaced so the agent can explain how every value was derived.
400+ built-in functions out of the box — the agent has access to the full Excel-compatible function set (SUM, VLOOKUP, IRR, INDEX/MATCH, and the rest), no implementation work required.

Example

Using HyperFormula as a tool inside the Vercel AI SDK:

1
import { generateText } from 'ai';
2
import { openai } from '@ai-sdk/openai';
3
import HyperFormula from 'hyperformula';
4
import { createSpreadsheetTools } from 'hyperformula/ai';
5

6
// Build a workbook your agent can reason about.
7
const hf = HyperFormula.buildFromArray([
8
  ['Revenue', 100],
9
  ['Cost',     60],
10
  ['Profit', '=B1-B2'],
11
]);
12

13
// Pass the spreadsheet tools straight into generateText.
14
const result = await generateText({
15
  model: openai('gpt-4o'),
16
  tools: createSpreadsheetTools(hf),
17
  prompt: 'What drives the profit number, and what happens if revenue doubles?',
18
});

A single import, one extra line in tools, and the model can evaluate formulas, read ranges, and edit cells through the SDK — without inventing numbers.

Use cases

Explain the spreadsheet — ask the agent what a workbook does, which cells are inputs, and how each output is derived; get answers grounded in real formula evaluation.
What-if scenarios and forecasting — the agent tweaks assumptions and reports how downstream results change, deterministically.
Validate and clean data — the agent scans ranges for errors, missing values, or inconsistencies and fixes them in place.
Generate formulas from natural language — the agent translates a plain-English calculation into a verified, working Excel formula.
Financial modeling and reporting — NPV, IRR, amortization, KPI rollups, and other quantitative workflows where the answer must be exact and auditable.