Data & Research -

Spreadsheets, analysis, charts, research, surveys, fact-checking, extraction and forecasting. 57 copy-ready prompts across 8 categories – fill in the brackets, copy, and paste into ChatGPT, Claude, Gemini or any capable assistant.

There is one rule underneath every category in this pillar: a language model is a language model. It is excellent at reading, structuring, explaining and writing about data, and unreliable at computing over it.

So the pattern that works is consistent throughout — let it write the formula, the query or the code, run that yourself, and bring the numbers back for it to explain.

8 categories

Spreadsheets & Excel
Formulas, pivots, cleaning and the macro you would rather not write.
7 prompts
Data Analysis
Exploration, hypotheses and the analysis code you then actually run.
7 prompts
Charts & Visualisation
Chart choice, plotting code and figures that are not misleading.
7 prompts
Research & Literature
Literature work, synthesis and note-taking — with citations you verify.
7 prompts
Surveys & Feedback
Question wording, scales and the analysis of what came back.
7 prompts
Fact-checking
Using AI to find what needs checking — not to do the checking.
7 prompts
Documents & Extraction
Contracts, invoices and PDFs into structured fields that hold up.
7 prompts
Forecasting & Modelling
Model structure, assumptions and scenarios — computed in a spreadsheet.
8 prompts

A good first prompt from each

Spreadsheets & ExcelWrite an Excel or Sheets formula from a descriptionGet the formula you need without hunting through documentation.Get the prompt →Data AnalysisExplore a dataset before analysing itUnderstand what you have before drawing conclusions from it.Get the prompt →Charts & VisualisationChoose the right chart for your dataPick a chart that shows what you mean.Get the prompt →Research & LiteratureResearch a topic systematicallyInvestigate something properly rather than reading the first three results.Get the prompt →Surveys & FeedbackAnalyse open-ended survey responsesFind the themes in hundreds of free-text answers.Get the prompt →Fact-checkingCheck a claim before repeating itVerify something you are about to publish or act on.Get the prompt →Documents & ExtractionExtract structured data from a documentPull specific fields out of a contract, invoice or report.Get the prompt →Forecasting & ModellingBuild a simple forecast with honest uncertaintyProject forward without pretending to know the future.Get the prompt →

How to use these prompts

Pick a category above, or search the whole prompt library.
Press “Fill in” on any prompt to replace the [BRACKETED] parts in a simple form – or copy it and edit it in your AI tool.
Read the tip under each prompt. It usually names the thing that goes wrong first.
Got your own prompt? Run it through the Prompt Improver to see what is missing.