Formula Foundry
Formula Foundry is a spreadsheet productivity add-on for Google Sheets and Excel that replaces the cramped native formula bar with a code-style multi-line editor featuring syntax highlighting, indentation, and dark mode. The tool adds global variables (e.g., @@TaxRate), an AI assistant for formula generation and debugging, Excel-to-Sheets translation, and a visual formula builder. It is trusted by data and finance professionals who need readable, maintainable formulas across large workbooks.
- Artificial Intelligence
- AI Agents
- Software Only
Funding
Founders
Product
Problem
Spreadsheet formula bars are notoriously limited, squeezing long formulas onto a single line and making complex logic difficult to read, audit, and maintain. Analysts waste time debugging nested functions, and migrating formulas between Excel and Sheets often requires manual rewriting.
Solution
Formula Foundry provides a rich, IDE-style formula editor as an add-on for Google Sheets and Excel, bringing code-grade readability to spreadsheet work. It enables multi-line editing with syntax highlighting, auto-indentation, and dark mode, and it introduces global variables that users can define once and reference by name across an entire workbook. The tool also includes an AI assistant that suggests formulas, explains existing ones, and debugs errors, plus a compatibility mode that converts Excel-specific functions to their Sheets equivalents and vice versa. A visual builder lets users construct formulas through form fields and drag-and-drop logic, while a snippet library supports saving and sharing approved formulas across teams.
Target Audience
Primary users are data analysts, financial modelers, and spreadsheet-heavy teams in finance, operations, and data functions who need to write, audit, and maintain complex formulas across Google Sheets and Excel.
Features
- Multi-line formula editor with syntax highlighting, auto-indentation, dark mode, find & replace, and auto-suggest for functions and range names
- Global variable system (e.g., @@TaxRate) stored in a hidden sheet, enabling one-click updates that ripple across hundreds of formulas for scenario analysis
- Excel-to-Sheets and Sheets-to-Excel formula translation, alerting users when functions cannot be converted
- AI assistant for natural-language formula generation, plain-English formula explanation, and error debugging suggestions
- Visual formula builder with form-based argument entry, validation, and drag-and-drop reordering of nested expressions
- Snippet library with search, cross-device sync via Google account, and shared team libraries for approved formulas
- Enterprise features including centralized billing, domain-based onboarding, shared snippet libraries, custom SSO, and priority support