Understand a spreadsheet without being an Excel expert

For: Anyone handed a spreadsheet they need to understand · Facts checked: 2026-10-21 · Use case UC038

The problem

You have a spreadsheet and a question, but not the confidence to know what the columns mean or what matters.

Recommended approach

Use the AI built into your spreadsheet if you have it (Copilot in Excel or Gemini in Sheets). First explain what a row and each column mean, then ask for a few findings with the calculation behind each. Check key numbers in the sheet.

Try this now ↓

Try this now

Define a row. Write one sentence: “Each row is…”.
Explain unclear columns. Units, currencies, date ranges, abbreviations.
Ask your question. Use the example request below.
Ask for the calculation. Every finding must show the numbers behind it.
Spot-check in the sheet. Recalculate one or two totals yourself with a filter or SUM.

What you should get: A plain-English description of the data, a data-quality note, and 3 findings with calculations you can check.

Example input · edit before use

This spreadsheet: each row is [one order / one employee / one month]. Columns: [explain unclear ones and units].
Question: [what you need to know].
1. Describe the data in plain English
2. Flag missing or odd values
3. Give 3 findings, each with the exact calculation
Don't guess what a column means; ask me.

Check the result

Recalculate at least one finding yourself
Units and date range are correct
Missing values were handled sensibly
Correlation isn't presented as cause

Privacy: Remove names and personal data before uploading to personal AI tools.

Which tool to use

Use what you already have first. These options are not ranked.

If you already have it

Use the AI built into your work apps

Best when: You have Microsoft 365 Copilot or Google Workspace with Gemini at work

Tools: Microsoft 365 Copilot Business, Google Workspace with Gemini

Free option

Use one general assistant you already have (free tiers often enough)

Best when: You have no AI at work, or only a personal account

Tools: ChatGPT, Claude, Gemini

More options: plans, costs and subscriptions

Moderate: documented workflow fit; no independent head-to-head testing of these tools for this job. Prices come from each tool's record, with the date checked; always confirm on the vendor's page.

If you already have it

Use the AI built into your work apps

Best when: You have Microsoft 365 Copilot or Google Workspace with Gemini at work
Tools: Microsoft 365 Copilot Business, Google Workspace with Gemini
Why it fits: Native analysis, formulas and charts stay inside your workbook.
Subscription: Only if your organization already licenses it. Don't buy it for this job alone.
Cost (from tool records): Microsoft 365 Copilot Business: Promotional $18/user/month annual commitment; regular $21 shown at verification. (reported, not re-checked 2026-10-21 · source)
Google Workspace with Gemini: Workspace business pricing varies by plan; official page lists AI integrated across Workspace. (reported, not re-checked 2026-10-21 · source)

Free / already-owned option

Use one general assistant you already have (free tiers often enough)

Best when: You have no AI at work, or only a personal account
Tools: ChatGPT, Claude, Gemini
Why it fits: Upload a copy of the file; ask for calculations you can reproduce.
Subscription: Not required: free tiers can be sufficient; usage limits vary by plan.
Cost (from tool records): ChatGPT: Free; Go $8/month U.S.; Plus $20/month. (reported, not re-checked 2026-10-21 · source)
Claude: Free; Pro $20/month billed monthly ($17/month with annual billing); Max from $100/month (U.S.). (verified 2026-10-21 · source)
Gemini: Free access plus Google AI Plus $9.99 and Pro $19.99/month U.S. (reported, not re-checked 2026-10-21 · source)

Assumptions

You can use at least one general AI assistant (many have free tiers), or your employer already provides one.
You are allowed to put this material into that tool. Check your workplace policy first.

Why this approach

Why it fits

In-sheet AI can add formulas and charts where you keep working.
Telling it what a row means prevents the most common misreadings.
A file-capable general assistant works if you don't have in-sheet AI.

When not to use it

The data is personal or confidential and your tool isn't approved.
High-stakes financial reporting: use a qualified person.

How we know

Claim	Evidence	Source	Checked
Promptivity's own research synthesis (Research 1) lists this among its 10 launch use cases, drawing on published survey, behavioural and experimental studies of workplace AI use. Internal prioritization by Promptivity, not an independent evaluation and not a performance result.	Promptivity research synthesis	Source	2026-10-21
Which tools fit, and on which plans, comes from Research 2: vendor documentation plus Promptivity editorial judgement. Its rankings are editorial, not measured. No product was hands-on tested.	Editorial	Source	2026-10-21
Microsoft Support documents Copilot in Excel for formulas, charts and data insights. Vendor documentation, checked 2026-10-21. Page fetched and read on 2026-10-21. Not hands-on tested by Promptivity.	Vendor-documented	Source	2026-10-21
Google Docs Editors Help documents Gemini in Sheets analysing data (trends, patterns, outliers) and creating charts. Vendor documentation, checked 2026-10-21. Page fetched and read on 2026-10-21. Not hands-on tested by Promptivity.	Vendor-documented	Source	2026-10-21

What we don't know yet

No independent tests of formula correctness and chart accuracy across products.

Evidence types: Vendor-documented (the vendor's own help pages) · Outside evaluation (independent published study) · Promptivity research synthesis (our own compilation of published studies) · Editorial (our judgement) · Unknown. Nothing on this page was hands-on tested by Promptivity. Revisit if credible independent testing shows one tool is materially better for beginners, or if a listed tool changes access or price.

How this guide was prepared

This guide is based on published sources. We have not independently tested this workflow hands-on.

Suggest a correctionDid this help?

Related jobs

Decision support & problem solving

Compare options with a decision matrix

You set the criteria and weights; AI organizes the evidence and shows what could change the answer.

For: Anyone choosing between options (suppliers, tools, hires, plans)Planning & organization

Build a project plan from a goal and deadline

Get a draft plan with phases, tasks and risks, then check it against real people and time.

For: Anyone organizing a project, even without project-management training

See this guide as a sample newsletter edition

One AI Use Case a Day

Get one useful AI use case in your inbox every day. Free.

Double opt-in: we email you a confirmation link first. Sent by Promptivity <newsletter@promptivity.ai>, once a day. Unsubscribe in one click. We never sell your address or share it with sponsors. Brevo stores and sends it for us as our data processor. Open and click tracking is optional and off unless you tick the box. How we handle your email.