How to Use ChatGPT to Analyze a Spreadsheet for Work

Written by

It’s Monday, 4:40 pm. Someone forwards you a spreadsheet with 2,000 rows and one line on top: “Can you tell me what’s going on here before tomorrow’s meeting?” You open it, scroll, and your eyes glaze over somewhere around column K. You can use ChatGPT to analyze a spreadsheet for work in about twenty minutes, but not by uploading it and typing “analyze this”. What works: clean the file in two minutes, make ChatGPT describe the data back to you first, ask the one question your meeting needs answered, make it show the numbers behind every insight, then turn it into a five-line summary for the person who asked.

Imagine it’s Tuesday morning. You walk in with three findings you have checked yourself, one simple chart, and the exact rows behind the number everyone will ask about. When your manager says “where does that 18% come from?”, you know.

Want more practical AI workflows like this one, free? Join Launchpad.

No password needed – your reset opens instantly.

No password. Just your email, and you’re in.

Short answer

Attach the spreadsheet (XLSX, XLS, CSV or TSV) to a ChatGPT chat. Before you ask for any insight, ask it to list the columns, the number of rows, the date range and anything that looks broken, such as blanks, duplicates or numbers stored as text. Then ask a specific business question, tell it which columns to use, and ask for a small table of the numbers behind each finding. Check three of those numbers yourself in Excel or Google Sheets. Only then ask for the summary, written for one named reader.

Why the check? For data work, ChatGPT often writes and runs Python code to do the calculations, and OpenAI tells you to review that code, the outputs and the assumptions before you rely on the result (OpenAI Help Center: Data analysis with ChatGPT). It can also sound confident when it’s wrong, which is why OpenAI calls it a first draft, not a final source (OpenAI Help Center: Does ChatGPT tell the truth?). A wrong total in a meeting costs you more than the twenty minutes you saved.

Before you upload: two minutes that save you twenty

OpenAI’s own advice for spreadsheets is simple: descriptive column headers in the first row, one row per record, plain-language column names. Avoid several unrelated tables on one sheet, empty rows or columns that split the data, and values that only exist inside images (OpenAI: Data analysis with ChatGPT). In practice that means:

Delete the decoration. Title rows, merged header cells, a totals row at the bottom, a notes box in the corner. ChatGPT may read a totals row as one more customer.
Rename cryptic headers. “Amt_EUR_ex” becomes “Amount EUR excl. VAT”. You’ll get better answers and you won’t have to explain it later.
Remove what you don’t need. If the question is about regions and months, the column with customer phone numbers doesn’t have to come along.
Check you’re allowed to upload it. On ChatGPT Business, Enterprise and Edu, OpenAI says it does not use workspace content to train its models by default. On a personal account, turn off “Improve the model for everyone” under Settings, Data controls (OpenAI: Data controls in ChatGPT). Your company’s rules still come first.

Working in Google Sheets? Download a copy (File, Download, Microsoft Excel or CSV) and upload that (Google: Export spreadsheets). A CSV only holds the sheet you had open, so pick the right tab first. If your account has connectors switched on, ChatGPT can also attach files straight from Google Drive, OneDrive or SharePoint.

Step 1: make ChatGPT describe the file back to you

This is the step most people skip. It’s also where you catch the problems that make every later answer wrong: a date column read as text, two “Region” spellings, 40 empty rows in the middle. I do it every single time, even with files I made myself.

I'm uploading a spreadsheet. Don't analyze it yet.
First tell me:
1. How many rows and columns it has, and which sheets.
2. Each column name, what kind of data is in it (date, number, text, category), and one example value.
3. The date range covered.
4. Anything that looks wrong or messy: empty cells, duplicates, numbers stored as text, odd spellings of the same value, outliers.
Then ask me up to 3 questions about anything you're unsure of.

Read the answer like a colleague’s handover. If it says 1,940 rows and you know there should be 2,000, stop and find out why before you go on. If it guesses what a column means, correct it in one line: “Status 3 means cancelled, leave those out.”

Step 2: ask the question your meeting needs, not “analyze this”

“Analyze this spreadsheet” gets you a tour of averages nobody asked for. A good question has a decision behind it. Give ChatGPT the context, the columns and the comparison you care about.

Context: this is our [monthly sales export / support ticket log / project budget]. I need to explain [what changed this quarter / why costs are over budget / where tickets pile up] to [my manager] tomorrow.

Use these columns: [Date], [Region], [Product], [Amount EUR excl. VAT].
Compare [Q3 with Q2].

Give me the 3 findings that matter most for that question. For each finding:
- one sentence in plain English
- the exact numbers behind it, in a small table
- how you calculated it (filters, groupings, which rows you left out)
If something can't be answered from this data, say so instead of guessing.

That last line matters. Without it, a chatbot tends to fill gaps with something that sounds reasonable. With it, you get “the file has no cost column, so I can’t calculate margin”, which is far more useful.

Step 3: make it show its work, then check three numbers

When ChatGPT runs Python for an analysis, you can open the code and the outputs. You don’t have to read Python to use this. Ask for the method in words instead:

For finding 1, explain step by step in plain words how you got the number: which rows you filtered, which column you summed or averaged, and how many rows went into it. Then give me one filter I can set in Excel to see the same rows myself.

Now take two minutes in the spreadsheet itself. Set that filter, look at the sum in the status bar at the bottom, and compare. Do this for three numbers: the biggest one, the most surprising one and the one your manager will ask about. If they match, you can trust the rest a lot more. If one doesn’t, ask ChatGPT why, and you’ll often find the totals row or the duplicate it warned you about in Step 1.

How to use ChatGPT to review a spreadsheet and summarize insights

Once the numbers hold up, the summary is the easy part. The trick is to write it for one person, with one length, and one thing you need from them.

Using only the findings we checked above, write a summary for [my manager, who has 2 minutes before the meeting].
- 5 lines maximum
- start with the single most important change, with its number
- then 2 supporting findings, each with its number
- then 1 open question or risk the data can't answer
- end with the decision or next step we need from them
Plain English, no jargon, no numbers that aren't in our checked tables.

Swap the reader and you get a different, equally useful summary: “my team, so they know what to focus on next week” or “a client, without internal cost figures”. Same data, same checked numbers, a different message.

Step 4: one chart, if it helps

ChatGPT can turn uploaded data into charts. Bar, line, pie and scatter charts can be switched to an interactive version, other chart types come back as an image (OpenAI: Data analysis with ChatGPT). Ask for exactly one chart that shows your main finding:

Make one bar chart of [Amount] by [Region], [Q2] next to [Q3]. Sort from largest to smallest change. Title it with the finding in plain words, not the column names. Label the bars with the values.

If the first chart isn’t what you meant, say so directly. OpenAI notes it may pick a chart type or method that doesn’t match your intent on the first try, and naming the chart type, grouping or column fixes most of that.

When the spreadsheet is big, messy or full of formulas

Very large files. Spreadsheets and CSVs have a size limit of roughly 50 MB, depending on how wide each row is (OpenAI: Uploading files to ChatGPT). Above that, filter to the period or region you need and upload that slice.
Lots of formulas. OpenAI says the number and complexity of formulas can affect processing, even when the file is small enough. Paste the sheet as values into a new file (Paste special, Values) and upload that copy.
Several tabs. Tell ChatGPT which sheet to use, or ask it to inspect one sheet at a time. If an answer seems incomplete, that is OpenAI’s own suggestion too.
A table inside a PDF or screenshot. ChatGPT may not read exact values reliably from scans or images of tables. Get the original spreadsheet if you can. If you only have the PDF, pull the table out first, for example with Claude: extract data from a PDF into a spreadsheet.
A recurring report. If you do this every month, save your Step 1 and Step 2 prompts in a ChatGPT Project with last month’s file, so next month starts from the same questions.

If what you really need is a formula you can keep in the sheet, not a one-off answer, see how to use AI to write Excel formulas. It shows the prompt to use and how to check the result before you trust it.

Common mistakes

Skipping the describe-back step. Every answer after that is built on a guess about your columns.
Asking for “insights”. You get generic observations. Ask for the answer to a question with a decision behind it.
Trusting a number you didn’t check. Three spot-checks take two minutes. Do them.
Uploading the whole CRM export. Personal data you don’t need for the question shouldn’t leave your systems.
A summary for nobody. “Summarize this” gives you a shorter spreadsheet in words. “Brief my manager on what changed” gives you something you can send.

FAQ

Can I do this on the free ChatGPT plan?

Yes. Spreadsheet uploads are available on Free and paid plans, with plan-specific limits. Free users can upload 3 files per day, so one well-prepared file beats three attempts (OpenAI: Uploading files to ChatGPT).

Can ChatGPT pull live data from the web into my analysis?

Not inside the analysis itself. OpenAI says the Python environment used for data analysis can’t make web requests or API calls, so upload or connect any extra data you want included.

I have a sales pipeline export. Is there a ready-made prompt?

Yes, we wrote a full weekly review kit for exactly that: ChatGPT prompts for sales pipeline management.

Related guides

Survey results instead of a sales sheet: how to use AI to analyze survey data, including open text answers.
Documents instead of data: how to get ChatGPT to summarize long documents for work.
Turning your findings into a written report: how to get ChatGPT to help write a report for work.
Weekly updates from your numbers: Gemini for automated status updates.
After the meeting: use ChatGPT to summarize meeting notes.
Not sure ChatGPT is the right tool for your setup: ChatGPT vs Gemini vs Copilot, and when Gemini or Copilot is the better pick for spreadsheets.
When the job turns into a script instead of a one-off analysis: Claude vs Gemini for coding, for automating a sheet or merging a folder of CSV exports.
Presenting what you found in the data: how to use AI to make a presentation from your findings.

Try it on the spreadsheet you’ve been avoiding

Pick the file that’s been sitting in your downloads folder since last week. Run only the Step 1 prompt and read what comes back. Often that alone tells you more than ten minutes of scrolling: how much data there really is, what’s broken, and which question is worth asking.

Want a new practical AI workflow like this every week? Join Launchpad.