You export a report, open it, and four thousand rows stare back at you. The answer your manager or your supervisor wants is somewhere in that file. Finding it used to mean an afternoon of pivot tables and half remembered formulas.

This is one area where AI has become properly useful. You can hand a spreadsheet to a chatbot, ask plain questions about it, and get back a summary, a chart, and the formula you were trying to remember. Below is how to analyze data with AI using free tools, which questions actually work, and where these tools still get things wrong.

What it means to analyze data with AI

Two different things share the same name, and mixing them up causes a lot of confusion.

• Chat tools that read a file you upload. You give ChatGPT, Claude, or Gemini a CSV or Excel file and ask questions about it in normal language. This route is free to try.
• AI built into the spreadsheet itself. Copilot in Excel and Gemini in Google Sheets sit inside the app and can edit your sheet directly. Both normally need a paid plan.

If you are starting out, begin with the first one. It costs nothing and it teaches you what these tools are good at before you pay for anything.

The free way: upload your spreadsheet and ask

The workflow is short. Tidy the file, upload it, then ask a specific question.

1. Tidy the sheet first. One header row, one record per row, clear column names, no merged cells or decorative blank rows. OpenAI says the same thing in its own guidance: structured data with clear column names and one record per row gives the best results.
2. Save it as CSV or XLSX. Delete the columns you do not need before you upload.
3. Upload and say what you want to learn. Not “analyze this”, but “which three products lost the most sales between March and June, and by how much”.

If you have already tried our guide on how to chat with a PDF using AI, this will feel familiar. Same idea, different file type.

Which free tools handle spreadsheets

ChatGPT can inspect an uploaded file, answer questions about it, and build tables and charts. Free accounts are limited to three file uploads per day, and a CSV or spreadsheet can be roughly 50MB at most, as set out in the official data analysis help article.

Claude takes a slightly different approach. Its analysis tool writes and runs real code to do the calculation instead of predicting an answer as text. For anything involving actual arithmetic, that distinction matters more than it sounds.

Gemini works the same way in the main Gemini app, and it connects neatly to Google Drive if your files already live there.

The built-in option inside Excel and Google Sheets

If your workplace or university already pays for one of these, the AI is sitting in the app and most people never open it.

Copilot in Excel lives on the Home tab of the ribbon. Microsoft lists four main jobs for it: importing data, highlighting and sorting and filtering, generating formulas and explaining how they work, and surfacing insights as charts, PivotTables, summaries, trends, or outliers. It needs an eligible Microsoft 365 subscription, and your data has to be formatted as a table or supported range before Copilot can read it.

Gemini in Google Sheets opens from the Ask Gemini button in the top right. It can create tables and formulas, generate analysis and charts, and carry out edits you describe in words, including conditional formatting, pivot tables, sorting, filtering, and multi step cleanups. Two practical notes from Google: it needs an eligible Workspace or Google AI plan, and it works best on native Sheets files, so an uploaded .xlsx should be converted with File and then Save as Google Sheets. If a cell shows a formula error, hovering over it and clicking Fix asks Gemini to explain what went wrong.

Five questions worth asking about any dataset

Vague prompts get vague summaries. These five are a reliable starting set, and they work in every tool above.

• Describe this dataset. How many rows are there, what does each column mean, and what data is missing?
• What are the top five and bottom five rows by [column], and what is the gap between them?
• Group this by month and tell me whether the trend is rising or falling.
• Which rows look like duplicates, typing errors, or outliers?
• Write the Excel formula that does this, and explain each part of it.

Important tip: ask for the working, not just the answer. Adding “show me the steps and the columns you used” turns a black box into something you can actually check, and it is the single habit that catches most mistakes.

If your prompts keep returning generic replies, our guide on how to write better AI prompts covers the structure in more detail.

Always check the numbers before you use them

This is the part people skip. A chatbot answering in plain text can produce a confident figure that is simply wrong, which is the same problem behind AI hallucinations. Tools that run code are safer, but code can still read the wrong column or quietly ignore blank rows.

Three checks take about a minute between them. Recalculate one figure by hand. Confirm the row count the AI reports matches the row count in your file. Ask which columns it used, and read that answer properly.

From my own work on websites and analytics data, the failure is almost never the arithmetic. It is the tool confidently answering a slightly different question than the one I asked, and it looks right until someone checks.

Keep private data out of the chat

Spreadsheets are usually the most sensitive files an organisation owns. Customer lists, student records, salaries, and health data should not be dropped into a personal chatbot account just because it is quicker.

A safer habit: delete the name, email, and ID columns before you upload, or build a small anonymised sample that keeps the shape of the data without the identities. Our guide on how to use AI safely and protect your privacy walks through the account settings that matter here.

Common Questions

Do I still need to learn Excel? Yes, and probably more than before. AI writes the formula, but you are the one who has to notice when the result looks wrong. Understanding what a VLOOKUP or a pivot table does is what makes you useful next to the tool rather than dependent on it.

Which free tool is best for spreadsheets? For calculation heavy work, a tool that runs code is the safer bet. For quick summaries and charts, any of the three will do. Try the same file in two of them and compare the answers, which is also a decent accuracy test.

Can AI make charts from my data? Yes. All the tools mentioned can produce charts, and both Copilot in Excel and Gemini in Sheets can insert one directly into the sheet. Google notes that a chart Gemini inserts sits on a new tab with its own copy of the data, so it does not update when the original figures change.

Final takeaway

You do not need a data science course to get value here. Tidy one spreadsheet, upload it to a free tool, ask it the five questions above, then verify one number by hand. That single round trip will teach you more about what AI can and cannot do with data than any amount of reading.

Start small, keep the sensitive columns out, and treat every figure it gives you as a draft until you have checked it.