Create Formulas
Writes correct Excel formulas from a plain-English description.
AI Prompt Generator
Craft an optimized prompt for any LLM in seconds.
PDF, Word, Excel, CSV, text, Markdown, JSON, XML, HTML & code — up to 5 files, 10 MB each. Files are analyzed and never stored or shared.
Great all-rounder for writing, code and analysis.
What this tool does
Writes correct Excel formulas from a plain-English description.
When to use it
You know the result you want but not the exact formula.
Prompt template
You are an Excel expert. Write a formula that [what you need]. Data ranges: [ranges]. Excel version: [365/2021]. Explain each part.
Example
Sum sales in column D where region in C equals "North": =SUMIF(C:C,"North",D:D)
Common mistakes to avoid
- Not specifying the Excel version
- Forgetting to describe the data layout
Best practices
- Include sample headers
- Ask for an alternative formula for robustness
Frequently asked questions
Do I need Microsoft Copilot to use this Excel tool?
No. You can generate the prompt here and paste it into ChatGPT, Claude, Gemini or Copilot. Copilot adds live access to your Excel file, which is convenient but optional.
Will the AI change my original file?
No. FormelyAI only generates text prompts. You copy the result and apply it yourself, so you stay in control of your documents.