Guides › Documents & Data
Ask your spreadsheet questions in plain English
Get straight answers from your spreadsheet, like your best month or biggest customer, without writing formulas or pivot tables.
When to use it
Whenever you have a question about your data
Step by step
Tidy the sheet first
Make sure there's one header row and one row per record. Delete blank rows and unmerge any merged cells.
Use the built-in assistant or upload a copy
If your plan includes Gemini in Google Sheets or Copilot in Excel, open its side panel. Otherwise download the sheet as a CSV or Excel file and upload it to ChatGPT, Claude or Gemini.
Ask clear questions
Paste this prompt and change the questions to your own.
Prompt to copyThis spreadsheet contains [what the data is, e.g. our sales for 2026, one row per order]. Columns: [list the main columns]. Answer these questions, showing the figures you used and how you worked each one out: 1) [Which month had the highest total sales?] 2) [Who are our top 5 customers by total spend?] 3) [What is the average order value by product category?] Then point out anything unusual in the data, such as gaps, duplicates or odd values.Double-check one answer
Pick one answer and check it yourself with a quick filter or SUM. If it doesn't match, ask the assistant to show its working.
What you get
1) Highest sales: July, £18,240 (312 orders). 2) Top customers: Harbour Café £2,410, Lane Studio £1,980... 3) Average order: Cakes £21.40, Bread £8.90. Unusual: 14 orders have no date; 3 look duplicated (same customer, amount and time).
Tips
- Delete columns with names, emails or phone numbers before uploading if you don't need them for the question.