Ask ChatGPT to Analyse a Spreadsheet Carefully
Define the decision, important columns and checking rules before asking for patterns or calculations.
Reviewed 29 August 2026 · Beginner friendly · Free to copy
Analyse the attached spreadsheet to help me decide [decision]. First describe the sheet structure and flag missing, inconsistent or ambiguous data. Then calculate [metrics], show the formula or method, and identify the three most important patterns. Separate facts from interpretations. Do not alter the file unless I ask.
Why this prompt works
The prompt requires a data-quality check before analysis and makes calculations easier to audit.
Use it in three steps
- CopyUse the button above to copy the complete prompt.
- PersonaliseReplace every item in square brackets. Specific, truthful details produce more useful answers.
- CheckRead the answer carefully. Verify important facts, dates and advice before acting.
Small changes that improve the answer
- ✓ Remove personal or confidential information.
- ✓ Explain unfamiliar column names.
- ✓ Check a sample calculation manually.
Useful follow-up prompts
The first answer is a starting point. Continue the same conversation with one of these:
“Show the result as a simple table.”
“Which conclusion is least certain?”
“Create a chart only if it adds useful information.”