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.
- productivity
- planning
- analysis
- intermediate
The prompt
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.
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
- Fill in the blanks above, or paste the prompt into your AI chat and replace the words in capitals there. How blanks work
- Save it to your library to use it again. Your copy keeps the blanks, so next time you only fill them in.
- Use it where you chat. With the Save My Prompts extension, pick the prompt inside ChatGPT, Claude or Gemini and fill the blanks there.
Related prompts
- 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.