Name: Formula Foundry
Rating: 5.0 (1 reviews)

Formula Foundry simplifies formula creation and management in Google Sheets and Microsoft Excel, with an AI assistant for generation and debugging. Key features: -Visual builder for IF, QUERY, XLOOKUP, VLOOKUP -AI assistant to generate or explain formulas -Automatic Excel ↔ Sheets translation -Reusable variables (e.g., @@TaxRate) -Formula snippet library -Rich editor with syntax highlighting Now with full native Excel support via Office Add-in. Free trial, no card required: formulafoundry.io

I've been using Formula Foundry in Google Sheets for a few months now. I work in project management and use spreadsheets on a daily basis.

The default formula field in Google Sheets is fine for short formulas but not for advanced ones which I have a lot. Formula Foundry made it much easier. I have initially been looking for just a formula code editor with larger window and code formatting, but I found more useful features with this product, e.g. the formula builder for those who are less familiar with programming, auto-formatting, and an integrated AI agent. I no longer need to copy-paste my formulas to ChatGPT, the chat is already there and ready to work for me.

The company also listens to its users. They implemented a bunch of improvements on the community feedback, including some of the features I asked for.

If you are an Excel or Google Sheets user, give it a try. It improved my workflow.

Although the default auto-formatting does the job, I would welcome to make it more configurable, as everyone has their own taste in formatting code and formulas.

It was the most easy-to-use tool of it's class.

One can create and manage variables that can be used in the formulas. The variables are saved on a hidden sheet. So, it's pretty transparent how it works.

Yes. Code snippets can be shared across the team.

I have not tried it offline.

Formula Foundry

Easier, faster formula creation & AI for Sheets and Excel

Easier, faster formula creation & AI for Sheets and Excel

Formula Foundry Reviews

The community submitted 1 review to tell us what they like about Formula Foundry, what Formula Foundry can do better, and more.

What's great

What needs improvement

vs Alternatives

Is the variable library easy to manage and scope?

Can saved snippets be shared across team members?

Does it work offline or require constant internet?