You just got a spreadsheet from work with 500 rows of sales figures, customer feedback, and delivery times. Your eyes glaze over before you even scroll past the first page. The good news: today's AI tools can read those files the way you'd read a paragraph. You ask a question in everyday language, the AI scans the data, and you get a clear answer back.
Before we walk through the steps, here's what you'll need on hand.
What you need first
- A free or paid account with ChatGPT (chatgpt.com), Claude (claude.ai), or Gemini (gemini.google.com). Free tiers work for small files; ChatGPT Plus, Claude Pro, or Gemini Advanced unlock bigger uploads and better charts.
- A spreadsheet saved as .csv, .xlsx, or .gsheet (Google Sheets link). Keep it under the size limit of your chosen tool—roughly 50 MB on free tiers, more on paid.
- A clear question in mind. Not sure what to ask? Step 1 will help you work that out.
Step 1 — Write down the one question you want answered
Open a notes app or grab a piece of paper. Don't open the AI yet. Just write the one thing you actually want to know. A good question has a subject, a time frame, and a number or comparison in it.
💬 Try one of these starter questions:
- "Which of my products had the highest sales each month in 2025?"
- "Why did customer complaints spike in March 2025?"
- "What's the average delivery time for orders over $100?"
You'll know it worked when your question is specific enough that a person could answer it without asking you for more context. If your question is vague ("tell me about my data"), the AI's answer will be vague too.
Step 2 — Open the AI and attach your file
Go to chatgpt.com, claude.ai, or gemini.google.com and start a new chat. Look for the paperclip icon, "Attach" button, or "+" symbol next to the message box—usually on the left side of the input area. Click it and choose your file from your computer, or paste a Google Sheets link.
💬 After the file uploads, type: "I've attached a spreadsheet of [what it contains]. Before I ask my question, can you tell me what columns and rows you see in plain English?"
You'll know it worked when the AI replies with a short summary of your file's structure, like "I can see 12 columns including date, product, region, and sales amount, with 487 rows of data." If it says it can't read the file, try saving it as a plain .csv first.
Step 3 — Ask your main question in plain English
Now type the question you wrote in Step 1. Don't worry about using special words like "aggregate" or "regression" (a statistical method for finding trends in data). Plain English works best.
💬 Example prompt: "Here's my sales data for 2025. Can you tell me which product had the highest sales in each month? Please show me a table."
You'll know it worked when the AI gives you a direct answer with specific numbers, names, or a small table—not a generic explanation of what sales data is. If the answer is too general, add one more detail (a date range, a region, a product type) and ask again.
Step 4 — Ask follow-up questions to dig deeper
This is where the real value comes in. Once you have a first answer, push further. A useful follow-up narrows the scope or asks for a visual.
💬 Try follow-ups like these:
- "Can you make a bar chart showing sales by month?"
- "Which region had the lowest sales in Q2, and what might explain it?"
- "Is there a connection between delivery time and customer satisfaction score?"
You'll know it worked when the AI produces a chart you can screenshot, or a sentence that names a pattern you can act on—like "deliveries over 5 days had a complaint rate 3x higher than faster ones." If the chart looks messy, ask for a simpler version: "Can you redo that as a simple bar chart with 4 bars?"
Step 5 — Sanity-check any surprising result
AI can confidently make things up, including fake patterns in your data. This is called a hallucination—when the AI invents a connection that isn't really there. Before you act on anything unusual, verify it.
💬 Ask the AI itself: "Are you sure about that pattern? Walk me through how you found it, step by step."
Then open your spreadsheet yourself and sort or filter the relevant column to confirm. If the numbers don't match, ignore that answer and ask the question differently.
You'll know it worked when you can point to the actual cell or row in your spreadsheet that backs up the AI's claim. If you can't, treat the answer as a guess, not a fact.
Step 6 — Turn the insight into one concrete action
The whole point of this exercise is making a decision. Pick one finding that matters and decide what you'll do with it this week.
💬 Ask the AI for help here too: "Based on this finding, suggest 3 practical actions I could take next week. Keep them small and cheap."
You'll know it worked when you've written down one specific action with a date attached—for example, "Email the logistics team on Monday about the 5-day delivery threshold." If you finish this step without a clear next move, go back to Step 3 and ask a sharper question.
Common mistakes
- Uploading the wrong file or a corrupted one. The AI may pretend to read it and give you confident nonsense. Fix: Open the file yourself first, make sure the columns have headers and the rows aren't broken, then re-upload.
- Asking vague questions like "tell me about this data." You'll get a vague answer. Fix: Always include a subject, a time frame, and what you want compared (Step 1 has ready-to-copy prompts).
- Trusting surprising numbers without checking. AI sometimes invents patterns. Fix: Use Step 5 every time a result feels too neat or too dramatic—open the spreadsheet and verify before acting.
- Putting sensitive personal or customer data into a free AI account. Free tiers may use your uploads to train future models. Fix: Remove names, emails, and addresses before uploading, or use a paid plan that promises not to train on your data.
- Stopping after the first answer. The first response is rarely the most useful one. Fix: Always do at least 2–3 follow-up questions, including one that asks for a chart.
