Excel to TypeScript
Convert Excel to TypeScript code
Generate a typed TypeScript client for the REST API Codcel builds from your Excel workbook, or run the calculations in the browser with WebAssembly.
How it works
- 1
Tag inputs and outputs
Mark which cells in your workbook are inputs and which are results. Your formulas stay exactly as they are.
- 2
Generate TypeScript code
Codcel reads every formula and dependency and generates a TypeScript project that you own.
- 3
Test against Excel
Generated tests compare the code's results with your workbook's values, so you can show they match.
What Codcel generates for TypeScript
Web client
A typed TypeScript client for the generated REST server that handles the HTTP calls and JSON for you.
WebAssembly module
Runs your calculations in the browser, with no server, through generated JavaScript and TypeScript bindings.
Powered by a compiled Rust engine
The TypeScript client calls a generated REST server, so your front end and back end share one tested calculation engine.
Calling the generated code
Each calculation in your workbook becomes a POST endpoint on the generated server. In this example the workbook has a calculation named monthly_payment.
POST /monthly_payment
Content-Type: application/json
{
"interest_rate": 5.5,
"loan_amount": 250000,
"term_years": 30
}
HTTP/1.1 200 OK
{
"monthly_payment": 1419.47
}Build and test
- Build system
- npm with TypeScript 5.8
- Build
npm run build- Test
npm run test
Why teams use Codcel
460+ Excel functions
Lookups, dynamic arrays, financial, statistical, text and date functions, with the known differences from Excel documented.
Source code you own
No proprietary runtime and no lock-in. The code lives in your repository and is reviewed like any other code.
Built for large models
Tables with millions of rows, including a one-billion-row benchmark, run through the same engine.
Proven against Excel
Generated tests check the code's results against the values in your spreadsheet.
Frequently asked questions
- Can Codcel convert any Excel spreadsheet to TypeScript?
- Codcel converts the formulas, named ranges and tables in .xlsx, .xlsb and .xls workbooks, and supports more than 460 Excel functions. The documentation lists every supported function and the few known differences from Excel.
- Do I need to rewrite my formulas?
- No. You mark which cells are inputs and outputs, and Codcel reads your formulas as they are.
- Is the generated TypeScript code readable?
- Yes. It is ordinary source code with typed inputs and outputs and generated tests. Your developers can review it, version it and change it.
- Does the generated code need Excel or a Codcel service?
- No. The generated project runs without Excel and without calling any Codcel service. It includes the open-source Codcel calculation engine, which is built along with your code.
- How much does it cost?
- Codcel is free for personal use. Commercial use runs on credits, and every plan includes the full source code and all generation options.
Turn your spreadsheet into TypeScript code
Download Codcel Desktop for free, or bring your hardest model to a 30-minute demo.