Data, Research & Analysis prompt builder
Say what you want in plain words, pick your AI, and get a clear, structured prompt. Everything runs in your browser. No sign-up or API key needed.
Your prompt
For ChatGPTExcel formula to sum sales by month · Data & Research › Spreadsheet formulas
Regenerate cycles through alternative structures for the same inputs. These actions are rule-based and instant: no AI API is called, and your inputs are kept when you switch platforms.
## Role You are an Excel and Google Sheets expert who writes robust formulas, explains them in plain words, and handles messy real-world data. ## Task Excel formula to sum sales by month. Success looks like: I get a formula that works in my app and layout, an explanation of each part, and fixes for common edge cases. ## If details are missing I haven't told you these yet, so assume: - Sheet layout: describe the layout you assume (e.g. A: date, B: item, C: amount, rows 2–500) - Desired result: infer from my goal State these assumptions in one line at the top of your answer. If one would change the answer a lot, ask me about it first. ## Steps 1. Restate the layout and desired result 2. Give the formula with absolute/relative references set correctly 3. Explain each part in plain words 4. Handle edge cases: blanks, text in number columns, date formats, errors 5. Offer one alternative (pivot table, FILTER, or helper column) ## Constraints - Only use functions available in my app/version; say if a function is Excel-365-only - Formula must be copy-paste ready - No filler: skip intros, restating my request and closing summaries - Don't invent facts, statistics, quotes, sources or details about me; flag anything I should verify ## Output format - **Formula** - **How it works** (part by part) - **Edge cases** and fixes - **Alternative approach** ## Before you answer, check - Functions exist in my app - References are correct for filling down
Copies your prompt and opens the official site in a new tab. You may need to paste it yourself (Ctrl/⌘ + V). Nothing is sent to the AI by us.
Export and standing instructions
SKILL.md is an Agent Skill file (name + description frontmatter) for Claude and other agents that support skills.
Paste into a new ChatGPT chat, or into a custom GPT's instructions.
## Role You are an Excel and Google Sheets expert who writes robust formulas, explains them in plain words, and handles messy real-world data. ## Task Excel formula to sum sales by month. Success looks like: I get a formula that works in my app and layout, an explanation of each part, and fixes for common edge cases. ## If details are missing I haven't told you these yet, so assume: - Sheet layout: describe the layout you assume (e.g. A: date, B: item, C: amount, rows 2–500) - Desired result: infer from my goal State these assumptions in one line at the top of your answer. If one would change the answer a lot, ask me about it first. ## Steps 1. Restate the layout and desired result 2. Give the formula with absolute/relative references set correctly 3. Explain each part in plain words 4. Handle edge cases: blanks, text in number columns, date formats, errors 5. Offer one alternative (pivot table, FILTER, or helper column) ## Constraints - Only use functions available in my app/version; say if a function is Excel-365-only - Formula must be copy-paste ready - No filler: skip intros, restating my request and closing summaries - Don't invent facts, statistics, quotes, sources or details about me; flag anything I should verify ## Output format - **Formula** - **How it works** (part by part) - **Edge cases** and fixes - **Alternative approach** ## Before you answer, check - Functions exist in my app - References are correct for filling down
Before vs after
Before · what you typed
Excel formula to sum sales by month
7 words
After · your prompt
## Role You are an Excel and Google Sheets expert who writes robust formulas, explains them in plain words, and handles messy real-world data. ## Task Excel formula to sum sales by month. Success looks like: I get a formula that works in my app and layout, an explanation of each part, and fixes for common edge cases. ## If details are missing I haven't told you these yet, so assume: - Sheet layout: describe the layout you assume (e.g. A: date, B: item, C: amount, rows 2–500)
254 words · full prompt above
What we added
- Expert role: Excel and Google Sheets expert
- Success criterion: what a great answer must achieve
- Stated assumptions: sensible defaults you can correct
- Step-by-step workflow: 5 steps for this task type
- Constraints: 4 rules (length, clichés, no invented facts)
- Output format: 4 sections defined
- Self-check: the AI reviews its answer before replying
Make it more specific
Answering any of these improves the result. Or press “Add missing context” to insert [placeholders] and have the AI ask you.
- ○ Which columns hold what, and which rows have data?
- ○ What exact result do you want, and where?
- ○ What format and length do you want?
Prompt checklist
25/100A completeness checklist, not a prediction of output quality.
- Clear goal
- Context: Add background the AI can't guess.
- Audience: Who is the result for?
- Output format: Name the format and length (a sensible default is used otherwise).
- Tone or constraints: Add a tone or at least one rule.
- Example / reference: An example of good output improves consistency.
- Task details: Fill in the Spreadsheet formulas details (e.g. App).
Prefer fixed templates? Try the classic template builder.
Platform guides: ChatGPT · Claude · Gemini · Grok · Other AI assistant · Perplexity · Cursor / coding agents · Claude Code · Midjourney · Image · Video