
Inspect first, then ask narrow questions. Ask the assistant to show its working, and double-check one number by hand before you share results.
Clean up before you upload
- One header row with clear column names.
- One table per sheet; remove merged cells and notes in the margins.
- Delete private columns (names, emails, account numbers) you do not need.
- Use consistent formats for dates and currency.
Step 1: inspect the data
Before analyzing, inspect this file: list each column, its data type, missing values and anything that looks wrong (duplicates, outliers, mixed formats). Then suggest five questions this data can reliably answer.
Step 2: ask narrow questions
“What drove the drop in March revenue?” works better than “analyze my sales.” Name the metric, the time period and the comparison you care about.

AI Mastery Bundle
The next step after the basics: frameworks, precision prompting and a 1000+ prompt library.
$50 (was $100) · Look insideStep 3: charts and formulas
- “Make a line chart of monthly revenue by region with clear labels.”
- “Write a Google Sheets formula that flags orders over $500 from new customers.”
- “Explain this formula in plain English, then give me a simpler version.”
Trust, but verify
Ask it to show the calculation behind any headline number, and recompute one yourself. Spreadsheet answers look precise, which makes small mistakes easy to miss.
Run the result through our AI Output Checker before it goes into a report.
Put it into practice
Open the free AI Output Checker: review an AI answer before you trust it. This article is part of The Complete ChatGPT Guide (2026 Edition).
Sources & further reading
Product facts were checked against official sources on 16 October 2026. AI tools change quickly, so check the provider’s current documentation for anything you rely on. Our editorial policy.


