Power Query
Builds Power Query (M) steps to clean and reshape data.
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
Builds Power Query (M) steps to clean and reshape data.
When to use it
You import messy data that needs transforming.
Prompt template
Act as a Power Query expert. Write the M steps to [transformation] on data from [source]. Explain each applied step.
Example
Unpivoting monthly columns into a tidy long table.
Common mistakes to avoid
- Not describing the source shape
- Skipping the target shape
Best practices
- Show before/after column layout
- Mention refresh needs
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.