Prompt repository Data & spreadsheets
ChatGPT prompts for Excel, spreadsheets and data
17 prompts for spreadsheet work: a formula from a plain description, macros, cleaning messy data, themes from survey answers with real counts, and an honest explanation of what a chart does and does not show. They work for Excel and Google Sheets alike.
- Prompts
- 17
- Registry code
- DAT
- Average score
- 10 out of 10
- Works in
- ChatGPT, Claude, Gemini and Copilot
The 17 prompts
- DAT-001Find themes in open-ended survey responsesYou have hundreds of free-text answers and need themes with real counts and exact quotes, not an impression.
- DAT-002Write a spreadsheet formula from a plain descriptionYou know what you want a spreadsheet to calculate, but not the formula, and you want one others can maintain.
- DAT-003Explain why a metric movedA number went up or down and you need a careful write-up of what the data does and does not show before anyone acts on it.
- DAT-004Write a SQL query from a question and your schemaYou know the business question and the tables, and you want a query that runs on your database and says what it assumed.
- DAT-005Plan the cleanup of messy spreadsheet columnsAn export or a shared sheet has inconsistent dates, names, categories or numbers, and you want rules you can apply and check rather than a silently altered file.
- DAT-006Read out an A/B test result honestlyAn experiment has finished and you need a write-up that says what the numbers show, how sure you can be, and what they do not show.
- DAT-007Choose the right chart for your data and messageYou have a table of numbers and one point to make in a slide or report, and you want the chart type, its setup and a title that states the takeaway.
- DAT-008Analyze a spreadsheet and explain what it showsYou need trends, outliers and the main takeaways from a spreadsheet in plain language.
- DAT-009Write a spreadsheet macro or script from a plain descriptionYou need repeated Excel or Google Sheets steps automated with a VBA macro or Apps Script.
- DAT-010Pull a table out of a PDF, scan or emailYou need figures trapped in a document turned into a clean table you can paste into a spreadsheet.
- DAT-011Set up a recurring weekly or monthly reportYou need a fixed report structure that you refill with new numbers each period.
- DAT-012Summarize raw data with a pivot tableYou need the right rows, columns and values for a pivot table that answers your question.
- DAT-013Plan a dashboard before you build itYou need the questions it answers, the metrics, charts and filters agreed before building.
- DAT-014Find errors and anomalies in a datasetYou need duplicates, outliers and suspicious values flagged before you trust the numbers.
- DAT-015Explain how an inherited spreadsheet worksYou need to understand a colleague's workbook, its formulas and its flow before you change it.
- DAT-016Define the KPIs your team will trackYou need each metric defined with a formula, data source, owner and target so everyone counts the same way.
- DAT-017Break down sales data by product, region and repYou need sales performance sliced and explained so you know what is driving the numbers.
How to use them
- Open a prompt and press Fill in variables. Type your details into each blank; they stay in your browser.
- Copy the filled prompt into ChatGPT, Claude, Gemini or Copilot, or check it first in the Prompt Grader.
- Read the answer against your own facts before you use it. The Fact Check List shows what to check.
Questions
Can ChatGPT write Excel formulas?
Yes, and it is one of the most reliable things it does, if you describe the columns and what the result should be. The formula prompt asks for your sheet's layout and a worked example, then explains the formula so you can check it.
Do these prompts work in Claude, Gemini and Copilot?
Yes. Each prompt is laid out for one kind of model, shown beside it, but every one works in ChatGPT, Claude, Gemini and Microsoft Copilot. Fill in the blanks and paste the whole prompt into the chat.
Are these prompts free?
Yes. You can open ten prompts without signing up, and a free email unlocks all 319 in the repository. Use them in your own work and your clients' work; please do not republish the collection.