VBA Generation
Generates VBA macros to automate repetitive Excel tasks.
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
Generates VBA macros to automate repetitive Excel tasks.
When to use it
You repeat the same manual steps in a workbook.
Prompt template
You are a VBA expert. Write a macro that [task]. Include comments, error handling, and instructions to run it.
Example
A macro that loops sheets and exports each as PDF.
Common mistakes to avoid
- Not describing the sheet structure
- Ignoring error handling
Best practices
- Describe ranges and sheet names
- Ask for comments to learn from it
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.