Every now and then I step outside the daily executive search work and share something purely practical. If you spend any time reviewing budgets, analyzing hiring metrics, or building forecasts, you know how easy it is to get bogged down in syntax instead of the actual numbers.
In a previous post I highlighted the categories but did not include the exact commands. This version fixes that. Below is the full reference table of all 30 spreadsheet prompts, so you can copy, paste, and adapt them for real work.
The 30 prompts
| Prompt | What It Does | When To Use It |
|---|---|---|
| Setup & Foundation | ||
| “Build me a [TYPE] spreadsheet from this data“ | Creates a full file from scratch | First time generating a model |
| “List your top 10 assumptions before executing” | Forces AI to expose its logic | Every single prompt; non-negotiable |
| “Use named ranges so formulas read like English” | Makes the file easier to understand | Board-ready or client-facing files |
| “Keep all inputs on an Assumptions tab” | Separates inputs from logic | Models you will edit often |
| “Format for board presentation: clean palette, frozen rows” | Produces a polished output | Live presentations |
| Building the Structure | ||
| “Add a Dashboard tab with KPI tiles” | Creates a single-screen summary | Executive reviews |
| “Add Base / Bull / Bear scenario toggle” | Builds 3-way sensitivity | Investor pitches and budgets |
| “Add a P&L tab linked to the Revenue tab” | Creates connected statements | Financial models |
| “Build a 12-month forecast by service line” | Generates a time-series projection | Revenue planning |
| “Add a Funnel tab: audience, leads, deals” | Creates a conversion model | Sales pipeline planning |
| Analysis Without Formulas | ||
| “What trends stand out in 2026 vs 2025?” | Surfaces year-over-year insight | Quick variance reads |
| “Compare actuals to budget, explain top 3 variances” | Pinpoints why numbers moved | Monthly reviews |
| “Categorize these transactions into expense types” | Auto-classifies transactions | Cleaning bank exports |
| “Which line items grow faster than revenue?” | Spots margin risk | Cost discipline checks |
| “Find the deals that closed fastest: what is in common?” | Detects patterns | Sales playbook building |
| Editing with ChatGPT in Google Sheets | ||
| “Visualize @Revenue as a stacked bar” | Generates an in-sheet chart | Quick visualization |
| “Summarize @Funnel in 5 bullets” | Condenses a full tab | Status updates |
| “In @Assumptions, push Bull more optimistic but stay realistic” | Edits one tab while the model updates | Scenario stress tests |
| “Add conditional formatting on margin %” | Adds visual cues to the data | Highlighting outliers |
| “Translate @Dashboard into French” | Localizes content | International clients |
| Debugging and Cleanup | ||
| “Explain what the formula in [CELL] does in plain English” | Decodes formulas | Learning and handovers |
| “Trace [CELL] back to its source inputs” | Maps dependencies | Audit before sharing |
| “Why is [CELL] showing #REF! / #VALUE! / #DIV/0?” | Helps fix errors | Broken files |
| “Show me how [CELL] connects to the Assumptions tab” | Reveals the logic chain | Trust-checking the model |
| “Find any hardcoded numbers inside formulas” | Spots fragile logic | Pre-delivery quality checks |
| Advanced Moves | ||
| “Add a data table for revenue at different growth rates” | Builds a sensitivity grid | Investor questions |
| “Add a Monte Carlo simulation on key drivers” | Creates a probabilistic forecast | Risk-heavy decisions |
| “Convert this monthly model to weekly granularity” | Reshapes the timeline | Operational planning |
| “Reconcile @Revenue tab with @P&L tab: find mismatches” | Runs a cross-tab audit | Final QA before sending |
| “Stress-test the model: what breaks first?” | Finds edge-case weaknesses | Pre-board preparation |
Frequently Asked Questions
How do I use these spreadsheet prompts?
Copy a prompt, paste it into ChatGPT, Claude, or an in-sheet AI assistant while you work in Excel or Google Sheets, and swap the bracketed placeholders like [CELL] or [TYPE] for your own values. Treat them as a starting point and adapt the wording to your file.
Do these work in both Excel and Google Sheets?
Most work in either one. The prompts that reference a tab with an @ symbol, like Visualize @Revenue, are written for ChatGPT working directly inside Google Sheets, but the same intent works in Excel by naming the range or tab in plain language.
Which prompt should I always start with?
List your top 10 assumptions before executing. It forces the AI to expose its logic before it builds anything, which is how you catch a wrong assumption before it becomes a wrong model.
Can I use these with confidential financial data?
Be careful. Do not paste confidential employer, client, donor, or personal financial data into public AI tools. Use your organization approved or enterprise AI environment for anything sensitive, and describe the shape of the problem rather than pasting the underlying records.
