Skip to content
{ }

Available for Google Sheets and Excel

The formula editor
they forgot to build.

Multi-line editing, global variables, and AI — all in one add-on. Trusted by data and finance professionals on Google Sheets™ and Excel.

Free trial — days only count when you use it. No credit card required.

InsertViewSnippets
Pro
Microsoft Excel
‘Q3 Financials’!D14
1
2
3
4
5
6
7
=IF(ISERROR(VLOOKUP(A2, @@Prices, 2, FALSE)),“Not Found”,VLOOKUP(A2, @@Prices, 2, FALSE))
=IFERROR(VLOOKUP(A2, ‘Prices’!A:B, 2, FALSE), “Not Found”)

Your spreadsheet experience, reimagined.

Rich Formula Editor (Simple)
editor.js
=IFS(
  D14 > @@Threshold, “Approved”,
  AND(D14 > 0, C14 = “VIP”), “Review”,
  TRUE, “Reject”
)
Excel Translator
Excel
Sheets
=XLOOKUP(A2, D:D, E:E)
=ARRAYFORMULA(XLOOKUP(...))
Global Variables
{ } Variables
+
@@TaxRateSHEET
0.21
@@Q4_Forecast
GLOBAL
=SUMIFS(…) * (1 + @@Growth)
Visual Builder
Formula Builder
QUERY
SELECT A, B, SUM(C)
WHERE D = ‘Active’
AI Assistant
How do I sum column A only if B is “Paid”?

Use SUMIF:

=SUMIF(B:B, “Paid”, A:A)
Snippet Library

Snippets

Library

+ New
MRR CalculationTEAM

Calculates monthly revenue across all subscriptions…

2h ago Toom
Regex: Email ValidPRIVATE
Yesterday

What our users say

Formula Foundry is genuinely impressive. Simplifying complex formulas, adding variables, snippets, and multi-tab editing inside Sheets is such a game-changer. As someone who has to deal with sheets, dashboards and pipelines every day, this feels like a tool built exactly for the pain points data people deal with.
Pavan Kishore ChaparlaData Analyst
Variables and vlookup are extremely useful in transferring Excel skills and keeping a sheet clean, as well as processing in fewer steps than I otherwise would have known how.
Jason TauSenior Financial Planning Analyst
I found the AI Assistant extremely helpful because it saved me time by generating formulas automatically and suggested improvements I might not have thought of. It made complex tasks much easier and more intuitive, especially for repetitive or complicated formulas.
Anand Kumar GadeFinancial & Reporting Analyst
As a marketer, I always end up back in spreadsheets — forecasting, funnel math, quick models, etc. I’m thrilled Formula Foundry created a productivity tool that actually makes a difference with my critical spreadsheet work.
Megan WellsVice President Marketing
My favorite feature is the editor and being able to more easily structure my formulas. The easy readability is a game changer! Also, the variables are super useful when I need to put together a complex report.
Brian NormanSales Engineer

Your next complex formula takes 30 seconds.
Not 30 minutes.

Join data and finance analysts who stopped fighting their spreadsheets.

Free trial — days only count when you use it. No credit card required.

Already have AI in Sheets?
Here’s what’s missing.

Feature
Gemini in Sheets
Copilot in Excel
Formula Foundry
Multi-line formula editor
No
No
Yes
Global @@variables
No
No
Yes
Team snippet library
No
No
Yes
Excel ↔ Sheets translation
No
No
Yes
AI formula generation
Yes
Yes
Yes

Free trial — days only count when you use it. No credit card required.

Frequently Asked Questions

Yes – we offer a free 14-day trial for all plans. Install the add-on and you’ll automatically have access to all features. No credit card required.
After the trial period is over, you’ll be offered to subscribe to one of our products.

“Starter” and “Pro” plans can be billed monthly or annually. Monthly subscriptions can be canceled at anytime. Our annual plan offers two months free. All payments are managed via our secure payment portal.

Absolutely. Formula Foundry doesn’t store your spreadsheet data. All computations happen within your Google Sheets™. We only store your name, email address and snippets in our database which can remove anytime by request. We comply with Google’s security standards for Google Workspace™ add-ons.

We’re here for you. All users have access to our online documentation and contact forms. We also love feedback – many of our new features come from user suggestions!