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
FF team here:
Were excited to launch Formula Foundry, an app that makes formula work simpler and more reliable in both Google Sheets and Microsoft Excel Cloud.
Spreadsheet formulas can slow down workflows: complex logic that's hard to build, errors that are tough to debug, and real headaches when migrating between Excel and Google Sheets or keeping values consistent across teams.
We built Formula Foundry to handle all that in one tool that's now available for Google Sheets and Excel.
Key features:
Visual builder: Point-and-click for IF, QUERY, XLOOKUP, VLOOKUP and nested logic with previews/validation
Rich editor: Syntax highlighting, auto-completion, bracket matching, smart formatting, bug detection
AI assistant: Generate formulas from plain English, explain existing ones, or get help debugging
Variables: Custom named values (e.g., TaxRate) for use in formulas across tabs, update once see change everywhere
Snippets library: Save/search reusable trusted formulas
Excel ↔ Sheets translator: Handles function differences and alerts on limits
Perfect for analysts, finance teams, or anyone dealing with spreadsheets on a regular basis.
We offer a 14 day Free trial (no card required) and competitive pricing..
Get it here:
Main site: Formula Foundry
Google Workspace Marketplace
Microsoft Marketplace
We’d love feedback: what would improve your spreadsheet workflow?
Thanks for checking us out!
Formula Foundry team
Hey Product Hunt!
I’m Will, co-founder of Formula Foundry.
Formula Foundry didn’t start in a boardroom. It started with friends talking about loving spreadsheets — but then that conversation took a turn...
We realized we were tired of that tiny formula bar, where nuances of simple and complex formulas easily get lost.
Fast forward about a year (and 6 features later), our passion project has turned into the tool we wished we had — built to simplify and improve Google Sheets and Excel for all users.
My favorite features are the formula editor, variables, and AI assistant:
No more having to work in that tiny formula bar — no more having to remember obscure cell references — and the ability to accelerate through debugging hiccups that derail productivity.
So, we’re incredibly excited to share this with the community.
Please let us know what you think!
@will_kaufman Coming from a strong background in SQL and data querying, I found the Query Builder in FormulaFoundry to be an impressive and highly practical tool for working with Google Sheets.
It effectively bridges the gap between traditional SQL-style querying and spreadsheet-based data analysis. The structured approach to selecting columns, defining conditions, applying filters, grouping, and sorting feels very familiar to anyone experienced in writing SQL queries. This makes the learning curve minimal for data professionals.
@gunjan_shrivastava Thank you for sharing how Formula Foundry is making life better for you as a data analyst! We love to hear it =) Please let us know if while you are using the QUERY feature (or any other feature) you come across room for improvement!
FF co-founder (and the person currently powered by 90% caffeine) here!
I’m the "technical nerd" behind the curtain who built the engine, the UI, and probably a few of the bugs you might find. Since I’ve been living in the code and the business logic simultaneously for months, there’s one thing I need to shout from the rooftops:
Formula Foundry is NOT just another AI wrapper!
Look, I love LLMs as much as the next dev, but if I see one more "ChatGPT-with-a-fresh-coat-of-paint" product, I might lose it. We actually built a real, living, breathing IDE for spreadsheets.
While we do have AI to help you out, the heart of the product is a custom-built logic engine. We’re talking a multi-line editor, a visual logic builder, and a cross-platform translator that I spent way too many late nights perfecting so you don't have to deal with "Formula Trauma" ever again.
A few things I’m particularly nerdy about:
The Parser: It doesn't just "guess" what you want; it understands the structure of your logic.
The Visual Builder: Mapping out nested IFs like a flowchart because, honestly, who can read 10 sets of parentheses?
The "One-Man Army" Build: I’ve touched every line of code and every business requirement. I built this because I wanted a tool that treated spreadsheets with the same respect we give to professional software development.
Being the solo dev on this means I’m the one answering your support tickets and fixing your bugs. I’ll be hanging out here all day to talk about the tech stack, the roadmap, or why we are still wrestling with single-line formula bars in 2026.
Ask me anything - I’m an open book!
Huge congrats on the launch! I just went through the Product Hunt cycle with my own project a few weeks ago, so I know exactly how much work goes into a V1 like this.
Spreadsheet logic is usually where productivity goes to die, so seeing a legitimate IDE for Excel/Sheets is honestly huge. The UI looks super sleek and it feels like a tool built by people who actually code. I’m definitely going to be using this to track my own product metrics from now on. Rooting for you guys to hit that top spot!
@ryanrudd , thanks, man! And big respect for your recent launch too - I was following your progress and you killed it. It's definitely a marathon!
You nailed it with the "productivity graveyard" comment. That’s exactly what I was trying to fix. I spent a lot of late nights making sure the engine handles edge cases without breaking the whole sheet, just so the grid could feel more like VS Code and less like a calculator from 1995.
Really glad to hear it’s going to help you track your own project. Let me know if you have any feature requests as you scale your startup!
@ryanrudd Thanks Ryan, that means a lot coming from someone who just went through the same level of effort. We hope it went well for you! We also couldn't agree more that spreadsheets are where productivity goes to die. It has been an unchanged paradigm for decades now with very little tooling to make it better. The last thing we wanted was to develop some clunky over engineered product that took more effort to learn to use than it was to just do the work in the sheet itself. We're also happy to hear you're going to use it, please feel free to reach out to the team and provide any feedback! Thanks again.
If you’ve ever had to build a custom attribution model or a cross-campaign reporting sheet in Google Ads, you know the literal pain of a broken formula at 2:00 AM before a client meeting. I’ve been doing this for years, and the standard way of handling formulas is just... fragile.
I started using Formula Foundry specifically to clean up my messiest tracking sheets. Being able to see the logic mapped out visually - instead of squinting at a string of text that looks like a cat stepped on the keyboard - is a massive relief. It actually makes my sheets client-proof because the logic is organized. If you're managing six-figure spends, you really shouldn't be relying on a single-line formula bar. Great launch, guys.
@pavel_prykhodko , LMAO, "cat stepped on the keyboard" is the most accurate description of a nested REGEX I've ever heard.
Honestly, marketing trackers were some of my primary test cases when I was building the engine. I knew that if the parser could handle a 1,000-character attribution formula with nested IFs and query strings without crashing, it could handle anything.
That "fragility" you mentioned is exactly what I wanted to kill. By treating formulas as structured logic blocks rather than just "text in a cell", we make them way harder to break by accident. I'm really glad it’s helping you keep those client meetings low-stress - that’s a huge win in my book!
I work in HR and I use Excel for many hours every week. For me, formulas were always very scary and difficult. I was always afraid to make a mistake in my reports.
But Formula Foundry is very different. It is simple to understand. I can see my logic like a map, and I don't feel lost anymore. It helps me finish my work much faster so I can focus on people, not just cells. I am so proud of this team. Very good job!
@yuliia_sas , thank you so much for the kind words! I know how much work you put into those employee sheets every single day.
My main goal was to take all the "scary" parts of a formula and hide them behind a clean UI. It’s actually quite a difficult coding challenge to make something look that simple on the screen, but hearing that it makes your life less stressful makes all those late nights worth it.
So glad it helps you get through your reports faster! Let me know if you need help with any specific HR templates.
Working in the agency world, I see "Formula Fatigue" every single day. My media buyers are brilliant at arbitrage, but they often get bogged down in the syntax of their reporting sheets rather than the story the data is trying to tell.
What I love about Formula Foundry is that it feels like a translation layer. It takes the cryptic, almost dead language of standard Excel and gives it a living, breathing structure. It turns a wall of text into a logical sequence. It’s rare to find a tool that respects the logic of a developer while understanding the frantic pace of a marketing team. Formula Foundry definitely hits that sweet spot. Truly impressive work you guys!
@max_leletskyi , a "translation layer" - I love that! Honestly, that was the goal from day one. I spent so many nights trying to figure out how to bridge the gap between "I want to calculate my ROAS across these specific variables" and the absolute mess of brackets that usually follows.
As a dev, I always viewed formulas as a dialect of code, but you're right - it really is its own language. I've focused heavily on the Cross-Platform Translator because no one should be "lost in translation" just because they moved a project from Sheets to Excel.
Thanks for the support! Tell the team I’m ready for them to try and break my logic engine with their wildest campaign trackers.