Free AI Excel Formula Generator
Describe what you need in plain English and get a working formula with a short explanation. Or paste a formula to have it explained or fixed.
Free, no sign-up. 5 uses a day, shared across all free tools.
Your text will appear here.
Fill in the left side and press Generate.
How it works.
- 01
Pick a task
Write a new formula, explain one you found, or fix one that returns an error.
- 02
Describe your sheet
Say which column holds what. The more precise you are, the fewer edits after.
- 03
Paste it in your cell
Copy the formula from the code block and adjust the ranges if your layout differs.
What you get.
Excel and Google Sheets
Pick Excel 365, an older Excel or Google Sheets, and the formula only uses functions that exist there.
Explained, not just written
Each formula comes with what every part does, so you can change it yourself later.
Explain and fix modes
Paste a formula that returns #N/A or #VALUE! and get the cause and a corrected version.
Assumptions spelled out
The answer says which rows and columns it assumed, so you know exactly what to edit.
Questions, answered.
Something else on your mind? Write to us.
Is the Excel formula generator free?
Yes. You can use it without an account. Every visitor gets 5 free uses a day, shared across all of Merlio's free tools, and they reset the next day.
Does it work with Google Sheets?
Yes. Choose Google Sheets and the formula uses Sheets functions, including some Excel doesn't have, such as QUERY and ARRAYFORMULA.
Why does the formula give an error in my sheet?
Usually the ranges don't match your layout, or the function doesn't exist in your version of Excel. Check the Assumptions part of the answer, then run Fix a formula with the formula and the error you see.
Which Excel version should I pick?
Pick Excel 365 or 2021 if you have XLOOKUP. If you don't, pick Excel 2019 or older: the tool then avoids XLOOKUP, FILTER, UNIQUE and LET and uses INDEX, MATCH and SUMIFS instead.
Can it write VBA macros or Apps Script?
No, this tool sticks to cell formulas. For macros and scripts, Merlio's chat can write VBA or Apps Script, and a free account includes 10 chats a day.
Should I paste my real data?
No need, and better not to if it is personal or confidential. The tool only needs the layout: which column holds what and what result you want.
More free tools.
All free AI tools- AI Code GeneratorGenerate code in any language with AI. Describe what you need and get working code with explanations. Free, no signup.
- AI Business Plan GeneratorGenerate a business plan outline with AI. Enter your business idea and get a structured plan with market analysis. Free, no signup.
- AI Answer GeneratorGet accurate answers to any question with AI. Paste your question and get a clear, detailed response instantly. Free, no signup.
Need more than five a day?
A free Merlio account adds daily chats and images with our fast models. Paid plans bring GPT, Claude, Gemini, video and music into the same app.
Free plan: 10 chats and 5 images a day. No card needed.