Free toolRuns in your browser · no sign-up
Free Excel Formula Finder
Describe what you want your spreadsheet to do in plain English - get the matching Excel formula pattern, an example, and what it does.
Matching formula patterns will appear here. Describe what you need and click Find Formula.
How does this Excel formula finder work?
This is a static reference tool: it matches keywords in your description against a lookup table of the most common Excel formula patterns - lookups, conditional sums and counts, date math, and text extraction - and shows you the formula shape, a worked example, and a plain-English explanation.
It won't plug in your actual column names or handle a genuinely custom formula, but for the requests that come up again and again ("look up a value," "sum if a condition is met," "how many days between two dates," "pull text out of a cell") it gets you the right starting formula immediately.
For a formula built around your actual sheet - real column names, real edge cases - the AI Excel Formula Generator prompt pack on KissMySkills gives Claude or ChatGPT the framework to reason through it with you.
Like this free tool? Get the full Claude skill.
A ready-to-load skill that does this and far more - one of 2,400+ skills, prompts and agents for Claude & ChatGPT.
Copy it, or run it in your AI
Open it in your AI
Data Analyst AI Skill does it for you, $19
One file for your AI. Ask Data Analyst AI Skill for this job any time, in Claude or ChatGPT. Data Analyst AI Skill - Clara →
More free developer tools
All free tools →Questions
Is the Excel Formula Finder free?
Yes. Use it on this page as often as you need, with no sign-up.
Do I need the app to keep using this page?
No. This page stays free and keeps working without an account.
Can I get my money back?
Yes. The first charge of a paid plan has a 30-day money-back guarantee.
