Skip to content

Free 14-day trial

Formula editor, Formula library, Formula collaboration, Formula AI assistant, for Google Sheets™

Formula Foundry is a Google Sheets™ add-on that makes writing, understanding, and managing formulas fast and easy – Save hours, reduce errors, and boost productivity.

Made for Sheets users, by Sheets users

The editor space you’ve always wanted

Painless editing – Our multi-line code editor, plus improved readability via syntax highlighting, structured formatting, and indentation.

Easy access to what you use most

Save time – Create and manage a library of formulas and variables accessible across all your sheets – insert snippets anywhere.

Enhanced team collaboration

Consistency – your saved library snippets are synced and shared across your organization, so your whole team benefits

AI debugging and auto-saving

AI Assistant automates formula writing and debugging via simple prompts. Auto-saving within Formula Foundry reduces the risk of any lost work.

Features that elevate your output

Excel syntax support

Compatibility mode to convert Microsoft Excel™ formulas to Google Sheets™ and vice versa, so you never get stuck rewriting formulas.

Rich formula editor

Advanced formula editing with syntax highlighting, autocomplete, and indenting for clarity.

Drag-and-drop builder

Visual tool to build formulas step by step without writing code.

Reusable snippets

Save frequent formulas or sub-formulas and insert them with a click in any sheet.

Variable syncing

Define variables (like exchange rates or constants) and use them in formulas across your workbook, all updated in one place.

AI assistance

Use AI to suggest formulas or explain complex ones in plain English, then fine-tune with the editor.

Who is it for

Formula Foundry is useful to all Google Sheets™ users!

Experts

People who know sheets inside and out – you relish your hours in the sheets.

Frank

Frank handles massive budgets in Google Sheets™ and feels uneasy trusting huge nested IFs and lookups.

With Formula Foundry’s code editor and error-highlighting, Frank confidently audits and reuses verified formula snippets, ensuring every calculation is correct and compliant.

Megan

Megan spends hours cleaning campaign data and building ROI formulas. She worries about mistakes in her complex formulas.

Formula Foundry gives her a visual formula builder and AI suggestions to quickly create accurate formulas for metrics, so she can focus on insights rather than debugging syntax.

Novices

People with information to organize, but who don’t have a lot of sheets experience.

Mike

Mike wears many hats and uses Google Sheets™ to track sales and inventory. He often Googles for formulas and prays they work.

Formula Foundry acts as his smart assistant – offering ready-made formula templates, Excel-to-Sheets conversions, and a quick snippet library. Mike saves time and avoids costly mistakes, all without hiring a spreadsheet expert.

Alicia

Alicia teaches spreadsheet skills and helps colleagues with Google Sheets™, but complex formulas intimidate her students.

Formula Foundry simplifies learning with an easy formula breakdown and step-by-step builder. Alicia can even show a live formula demo in class, turning fear into aha-moments for her students.

What our users say

“I always wanted a larger, number-delineated entry field for editing longer formulas — Formula Foundry’s editor truly delivers!”
Will Kaufman
“Opening Google and/or ChatGPT for syntax and formula writing assistance was always helpful, but one more step in my workflow – Formula Foundry simply added the power of AI directly into Google Sheets, and it’s super convenient!”
Yurii Vasyliev

FAQs