1
Connect
Declare worksheet ranges and names as reactive inputs. Workbook edits flow into the Python dependency graph.
Turn spreadsheets into software
Build interactive applications in Excel with Python. Connect live workbook data, create controls and visualizations, publish results back to cells, and deliver the workbook in a simplified Run mode.
No separate desktop Python installation is required for workbook users.
One workbook, two experiencesAuthor in Edit mode. Deliver in Run mode.
1
Workbook inputsRanges, tables, assumptions
↓
2
Reactive PythonModel, controls, validation, charts
↓
3
Publish to Excel
BF.OUTPUT + BF.FUNCTION↓
4
Save and hand offOperator opens the same workbook in Run mode
=BF.OUTPUT("forecast")=BF.FUNCTION("project_arr", A1, B1)Python for Excel
Build the application in Python. Deliver it through Excel.
Python for Excel is Boardflare’s flagship product for turning workbook inputs, reactive Python logic, and notebook UI into a reusable application. Excel remains the familiar assumptions, review, and delivery layer.
2
Build
Use ordinary Python, marimo controls, scientific packages, validation, and AI-assisted authoring where it helps.
3
Deliver
Publish values and functions back to Excel, save source with the workbook, and choose the operator-oriented Run startup mode.
Built for the handoff
The author sees a development environment. The user sees an application.
The point is not only to run Python in Excel. It is to package a model so another person can operate it without maintaining the implementation.
Build and maintain
- Edit reactive Python cells
- Use AI to generate and revise code
- Inspect dependencies and errors
- Publish workbook values and functions
Operate the model
- Change workbook assumptions
- Use application controls
- View charts, tables, and explanations
- Work without editing Python during normal use
Examples and templates
Working applications from the current demo catalog.
The current catalog spans finance, accounting, operations, analytics, engineering, and optimization rather than hypothetical use cases.
See all current examples and templates →Revenue Command Center
Workbook drivers, scenario controls, SciPy Sobol quasi-Monte Carlo forecasting, risk bands, worksheet outputs, and a live Python function.
View example →Close Reconciliation
Controller-oriented reconciliation with explicit tolerances, control totals, exception routing, and a worksheet-callable variance check.
View example →Portfolio Optimizer
Explainable capital allocation under budget, headcount, mandatory-project, and risk constraints with published recommendations.
View example →AI-assisted authoring
Use AI to write the application. Keep the application deterministic.
The notebook can generate, explain, debug, and revise code with the Boardflare workbook API in context. The durable output is inspectable notebook source and a workbook application—not an opaque chat answer.
See how AI authoring works →Example author request
“Read the project table and constraints from Excel, validate missing inputs, optimize the allocation, and publish the selected projects and summary back to the workbook.”
Review the generated cells, run them against representative workbook data, reconcile the result, then save the working application.
Other Boardflare products
Focused tools for other spreadsheet workflows.
Build your first workbook application.
Use Python for Excel in your workbook or explore the same application model in the browser demo.