Skip to content
PromptPilot AI

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.

Plain language is fine. This is the only required field.

2. Which AI will you use?
Chat assistants
Search
Image & video
Coding tools

Using: Data & Research › Spreadsheet formulas

Spreadsheet formulas details (optional)

Output language
More options: audience, tone, language, format, context

Your prompt

For ChatGPT

Excel 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
1463 chars · ~366 tokens (rough)

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
Optional: polish with an AI model. Generating above never calls an AI. If you want an LLM to rewrite this prompt, use the Enhancer with your own API key (billed by your provider; we don't store it).

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/100

A 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