# HyperFormula AI SDK for Vercel
A Vercel AI SDK (opens new window) tool that gives your agents deterministic spreadsheet and formula computation — backed by HyperFormula's Excel-compatible engine.
Not available yet — coming soon
This integration is on our roadmap and cannot be installed or used today. The API shown below is a preview and may still change before the first release.
If you'd like to try it, join the early access list (opens new window) — we'll ping you the moment the first beta is ready, and your sign-up directly tells us how strongly to prioritize this integration.
# 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:
import { generateText } from 'ai';
import { openai } from '@ai-sdk/openai';
import HyperFormula from 'hyperformula';
import { createSpreadsheetTools } from 'hyperformula/ai';
// Build a workbook your agent can reason about.
const hf = HyperFormula.buildFromArray([
['Revenue', 100],
['Cost', 60],
['Profit', '=B1-B2'],
]);
// Pass the spreadsheet tools straight into generateText.
const result = await generateText({
model: openai('gpt-4o'),
tools: createSpreadsheetTools(hf),
prompt: 'What drives the profit number, and what happens if revenue doubles?',
});
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
- Spreadsheet Q&A — 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.
# Get early access
Be the first to try it
We're actively building this integration. Drop your email and we'll notify you the moment the first beta lands — so you can try it before the public release.