Generate Excel formulas with AI magic
Describe what you need in plain English. Get the perfect Excel or Google Sheets formula in seconds. No more syntax headaches.
How it works
Three simple steps to your perfect formula.
Describe
Type what you want your formula to do in plain, everyday English. No need to know any formula syntax.
Generate
Formulr's AI (powered by Gemini 2.5 Flash) instantly converts your description into a working formula.
Copy & Paste
Copy the formula with one click and paste it directly into your Excel or Google Sheets spreadsheet.
Three powerful modes
Whether you're creating, understanding, or fixing formulas — Formulr has you covered.
Generate
Describe what you need in plain English and get the exact Excel or Google Sheets formula instantly. No syntax knowledge required.
Explain
Paste any complex formula and get a clear, human-readable explanation of what it does. Perfect for learning or auditing spreadsheets.
Debug
Got a broken formula? Paste it in and AI will identify the error, fix it, and explain what went wrong. Like a debugger for spreadsheets.
Simple, honest pricing
Start free. Upgrade to unlock 500 generations/month.
Free
- ✅ 15 formula generations/month
- ✅ 10 formula explanations/month
- ✅ 5 formula debugs/month
- ✅ Gemini 2.5 Flash AI
- ❌ Unlimited generations
Pro
- ✨ 500 formula generations/month
- ✨ Unlimited explanations
- ✨ Unlimited debugging
- ✨ Always-on Gemini 2.5 Flash
- ✨ Priority email support
Frequently asked questions
Everything you need to know about Formulr.
What is Formulr?
Formulr is an AI-powered tool that generates, explains, and debugs Excel and Google Sheets formulas. Simply describe what you need in plain English, and Formulr instantly provides the correct formula — no syntax knowledge required.
How does Formulr generate Excel formulas?
Formulr uses Google's Gemini 2.5 Flash AI to understand plain English descriptions and convert them into precise Excel or Google Sheets formulas. It supports complex functions including VLOOKUP, SUMIFS, INDEX-MATCH, XLOOKUP, and more.
Is Formulr free to use?
Yes! Formulr offers a generous free plan with 15 formula generations, 10 explanations, and 5 debugs per month. The Pro plan at just $4.99/month unlocks 500 generations and unlimited explanations and debugging.
Does Formulr work with Google Sheets?
Absolutely! Formulr supports both Microsoft Excel and Google Sheets. You can toggle between platforms in the formula generator to ensure the output is optimized for your specific spreadsheet application.
Can Formulr debug my broken formula?
Yes. Formulr's Debug mode identifies errors in your formula, fixes them, and explains what went wrong. It's like having a spreadsheet expert on demand — paste your broken formula and get a working version in seconds.
Is there a browser extension?
Yes! The Formulr browser extension is now live on Firefox. Chrome and Edge versions are currently under review and will be available soon. You can also use the full web application at getformulr.app anytime.
What Excel formulas can Formulr generate?
Formulr can generate virtually any Excel or Google Sheets formula including VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, AVERAGEIFS, nested IF statements, array formulas, UNIQUE, FILTER, SORT, LAMBDA, LET, TEXTJOIN, dynamic arrays, date functions, text manipulation, financial functions like PMT and NPV, and much more. Simply describe your logic in plain English.
Is Formulr better than ChatGPT for Excel formulas?
Formulr is purpose-built for spreadsheet formulas, unlike general-purpose AI tools. It distinguishes between Excel and Google Sheets syntax, enforces formula-only output without extra commentary, and provides a dedicated interface for generating, explaining, and debugging formulas. This specialization leads to higher accuracy and a faster workflow compared to general AI chatbots.
Can Formulr help with VLOOKUP and INDEX MATCH?
Absolutely! Formulr excels at lookup formulas. Just describe what you want to look up — for example, "find the price of a product by its ID from another sheet" — and Formulr will generate the optimal VLOOKUP, INDEX-MATCH, or XLOOKUP formula for your use case. It can also explain existing lookup formulas step by step.
Popular formulas users generate
See real examples of formulas Formulr creates from plain English.
"Sum sales where region is East and date is this quarter"
=SUMIFS(Sales,Region,"East",Date,">="&DATE(YEAR(TODAY()),CEILING(MONTH(TODAY()),3)-2,1),Date,"<="&EOMONTH(DATE(YEAR(TODAY()),CEILING(MONTH(TODAY()),3),1),0))
"Count unique customers who purchased more than $100"
=SUMPRODUCT((1/COUNTIF(IF(B2:B100>100,A2:A100),IF(B2:B100>100,A2:A100)))*(B2:B100>100))
"Find the second highest value in column B"
=LARGE(B:B,2)
"Extract the domain name from an email address in cell A1"
=RIGHT(A1,LEN(A1)-FIND("@",A1))