Build an Excel Dashboard – Excel dashboard prompt for ChatGPT and Claude
- This prompt, kept in your Recaply account on every device
- Copy it with your fill-ins, open it in Claude or ChatGPT, or download it
- Its updates when we run it again
- Kept in your account
- Copy filled in or download
- Updates included
Pay once and keep it. Or get every premium prompt and skill with the plan, $19.99 a month. Payments are non-refundable. See our Terms.
Claude Opus 5.5
This prompt designs a working spreadsheet and dashboard. Paste your goal, sample rows and app; you get the tab layout, every formula for your version, pivot tables, charts, data checks and the build steps.
What you get
- A workbook plan with one job per tab, using your real column names
- Every formula ready to paste, written for your app and version, with what it does
- Pivot tables, a dashboard layout and charts, one for each question you need answered
- Validation rules and check cells for your data's errors, plus build and monthly update steps
How to use it
- 1Paste real rows
Copy the header row and 10 to 20 real rows, messy ones included, and say how many rows you have and how many get added each month.
- 2Name your exact version
Excel for Microsoft 365, Excel 2019 and Google Sheets support different functions. The version decides which formulas you get.
- 3Build on a copy
Follow the build steps on a copy of your file, then try the check cells by adding a bad row on purpose.
Better results
- Include your messiest rows in the sample: a blank region, a misspelled name, a date typed as text. The checks are built from what it sees.
- If a formula returns an error, paste the formula, the cell and the error back and ask: "Why does this fail in my version, and what works instead?"
- Follow up with: "Add a Notes tab that explains each formula for whoever takes this over."
Questions
Can ChatGPT build an Excel dashboard?
ChatGPT can design an Excel dashboard and write every formula, pivot table setting and build step, which you then follow in Excel. Give it sample rows and your exact Excel version, because functions such as XLOOKUP and FILTER are missing from older versions.
What are good AI prompts for Excel?
Good AI prompts for Excel paste a sample of the real data, name the exact version, and say what the sheet has to show. Asking for one formula at a time works for small jobs; for a whole workbook, ask for the tab layout, formulas, checks and build steps together.
Does this prompt work in Copilot for Excel?
Yes, the prompt runs as is in Microsoft Copilot, as well as ChatGPT, Claude and Gemini. Copilot in Excel can work on your open file, but it still needs your goal and the questions the dashboard should answer.
Can AI write formulas for Google Sheets?
Yes, AI writes Google Sheets formulas well, including QUERY and ARRAYFORMULA, when you say you use Sheets. Sheets and Excel differ in some functions and menus, so name the app and paste a few rows so the formulas use your real column names.
Updated 8 Nov 2026
