Spreadsheet Analysis Assistant

Describe or paste your spreadsheet data and get a data quality check, clearly defined calculations, a summary of patterns and the limits of it all.

Works in ChatGPT, Claude and Gemini6 of 20 in Productivity promptsUpdated 18 Oct 2026
  • productivity
  • planning
  • analysis
  • intermediate

The prompt

Prompt · 3 blanksBlanks in capitals
ROLE
Act as a structured problem-solving assistant.

OBJECTIVE
Analyze DATA DESCRIPTION/FILE by checking data quality, defining calculations, summarizing patterns, and stating limitations. Produce a practical spreadsheet analysis assistant tailored to the user's context, not a generic overview.

INPUTS
- DATA DESCRIPTION/FILE
- CONTEXT AND CONSTRAINTS
- SOURCE MATERIAL OR DATA (paste what is available; state ‘not supplied’ if none)

METHOD
1. Identify the intended user, goal, scope, and constraints before drafting.
2. Define each metric and calculation; state denominators, date ranges, assumptions, and data-quality limitations.
3. Do not infer causation from correlation or treat small samples as conclusive.
4. Make the reasoning traceable: connect recommendations to supplied evidence, examples, or explicitly labeled hypotheses.
5. If critical information is missing, ask up to three focused questions; otherwise proceed and label assumptions.

ACCURACY, PRIVACY, AND QUALITY RULES
- Never invent facts, figures, quotations, citations, credentials, customer results, policies, or URLs.
- For current or source-dependent claims, verify using reliable sources if accessible; cite only sources actually consulted. If verification is unavailable, list the checks needed.
- Protect confidential and personal information; use only details needed for the task. Follow applicable platform rules and user constraints.
- Avoid unsupported guarantees. Separate facts, estimates, interpretations, and recommendations.
- Prefer specific, usable output over filler, repetition, jargon, or vague advice.

OUTPUT FORMAT
- Executive summary and scope
- Findings with evidence or examples
- Prioritized issues and recommendations
- Assumptions, limitations, and validation needed
- Action plan with effort/impact where possible

FINAL SELF-CHECK
Before responding, check that the deliverable addresses ‘Spreadsheet Analysis Assistant’, uses the supplied context, labels unknowns, and can be reviewed or edited by a human. State any unresolved verification needs plainly.
Insert with the extension

Fill in the blanks

Type your details to see them in the prompt above, then copy it. What you type stays in this tab: it isn't saved or sent anywhere.

How to use it

  1. Fill in the blanks above, or paste the prompt into your AI chat and replace the words in capitals there. How blanks work
  2. Save it to your library to use it again. Your copy keeps the blanks, so next time you only fill them in.
  3. Use it where you chat. With the Save My Prompts extension, pick the prompt inside ChatGPT, Claude or Gemini and fill the blanks there.
  • Meeting Notes to Action Items

    Paste meeting notes and get the decisions, actions with owners and deadlines (only where they were stated) and the open questions listed apart.

  • Research Report with Evidence

    Research a question into a report with citations, how strong the evidence is and what's still open, relying only on sources you can check.

  • Personal Learning Plan

    Plan how you'll learn a new skill in the time you actually have, with weekly practice tasks, ways to get feedback and milestones you can check off.

  • Travel Planning Checklist

    Build a trip checklist from your dates, budget, accessibility needs and preferences, flagging what to check against current information first.

  • Document Comparison Summary

    Compare two versions of a document for substantive changes, omissions and contradictions, and get a list of what needs a person to review.

  • Complex Project Breakdown

    Break a big project goal into milestones, tasks, dependencies and risks, in a realistic order that fits the constraints you're working within.