# Ask AI questions about your spreadsheet

> Researched. Small business · Beginner · Research. Updated 2026-11-02.

Canonical page: https://www.aisetupsthatwork.com/setups/ask-ai-questions-about-your-spreadsheet/

## What it does
Upload a spreadsheet export and ask plain-English questions about it, such as which campaign cost the most or which customers paid late, with the working shown so you can check it.

## Who it's for
Owners with sales, ad, expense or job data in a spreadsheet who want answers without building formulas.

## Tools
- Claude or ChatGPT with file upload
- A CSV or Excel export of your data

## Steps
1. Export the sheet as CSV or Excel. Remove columns with personal or payment details you do not need for the question.
2. Upload it. Anthropic says you can upload CSV and other files for data analysis and charts.
3. Ask it to describe the columns first and confirm what each one means. Fix any wrong guesses before asking real questions.
4. Ask one question at a time with the prompt below, and require the rows and math behind each answer.
5. Spot-check one answer by hand in the sheet. If it is wrong, tell it which number is wrong and why.
6. Ask for a small chart or a cleaned table you can paste back into your sheet.

## Copy-paste prompt
Adapt bracketed fields to your situation.
```text
I uploaded a spreadsheet. First, list each column and what you think it means, then wait for me to confirm.

After I confirm, answer this question: [YOUR QUESTION, E.G. WHICH AD CAMPAIGN COST THE MOST PER LEAD LAST MONTH?]

Rules:
- Show the exact rows and the math you used.
- Say how many rows you included and why any were left out.
- If the data cannot answer the question, say so and say what column is missing.
- Do not round money until the final answer.
```

## Guardrails
- What it touches: Chat input you provide (Claude or ChatGPT with file upload; A CSV or Excel export of your data).
- Needs your OK: Send, pay, publish, and account changes stay with you. Treat agent output as drafts first.
- Safety level: Read-only
- Dates in mixed formats get misread. Ask it to list any dates it could not read.
- Totals that include a summary row double-count. Remove summary rows before uploading.
- Trusting a chart without checking one number.

## Tips
- Confirm column meanings first; most wrong answers come from a misread column.
- Ask for the rows behind the answer, not just the answer.
- Keep a copy of the original file; never let a tool overwrite your only sheet.

## Estimates (labeled, not measured)
- Time saved: About 20 to 40 minutes saved per question compared with building formulas.
- Money saved: Not stated in sources.
- Tool cost: File analysis may need a paid plan depending on the tool; prices: Not stated in sources.

## Sources
Summaries use the public sources below, not independent verification.
- Anthropic: https://support.claude.com/en/articles/12111783-create-and-edit-files-with-claude (Create and edit files with Claude: upload CSV and other files for data analysis and charts; create Excel, Word, PowerPoint and PDF files (read 2026-11-02 from the official help page via search))
- Anthropic: https://support.claude.com/en/articles/8241126-upload-files-to-claude (Upload files to Claude: add files to a chat or to a project's Files section for use across conversations (read 2026-11-02 from the official help page via search))

## Get the free starter pack
Five beginner copy-paste AI setups, free by email: https://www.aisetupsthatwork.com/starter-pack/?utm_source=ai-agent&utm_medium=markdown&utm_campaign=setup-ask-ai-questions-about-your-spreadsheet

Related:
- [Track inventory in a spreadsheet with reorder alerts](https://www.aisetupsthatwork.com/setups/inventory-tracker-with-reorder-alerts/index.md)
- [Turn a stack of documents into one brief](https://www.aisetupsthatwork.com/setups/turn-a-stack-of-documents-into-one-brief/index.md)
- [Build a knowledge base your AI answers from](https://www.aisetupsthatwork.com/setups/build-a-business-knowledge-base-your-ai-answers-from/index.md)