Can ChatGPT analyse my data and turn it into a chart?

Yes. ChatGPT can analyse uploaded files (.xls, .xlsx, .csv, PDFs and more), answer questions about the data, and create tables or charts, sometimes by running Python code to do it (OpenAI). What you get is a first pass — a chart plus a summary of trends and outliers — not a finished analysis. OpenAI's own guidance is to review the generated code, outputs and assumptions before relying on the result.

Tools that work

ChatGPT data analysis is the most direct fit if your data is already in a file you can upload, and it's the tool the rest of this page uses. Two other options cover the case where you'd rather stay inside a spreadsheet or want a second opinion from an AI chart generator.

Tool	What it does with your data	What it costs
ChatGPT (OpenAI)	Reads uploaded spreadsheets and CSVs, answers questions, builds charts, sometimes via Python	Free with limits; Plus at USD 20 per month, billed monthly (OpenAI)
Copilot in Excel	Works on the sheet you already have open; Microsoft's Excel FAQ lists the eligible licences, including Microsoft 365 Premium, or Personal or Family with an AI credits plan (Microsoft)	Paid subscription; see Microsoft's current plans
Gemini web app	Creates a chart from uploaded spreadsheets, which you can zoom into and customise (Google)	Free and paid tiers; see Google's current plans

Upload limits are the practical constraint on ChatGPT, not the analysis itself: up to 512MB per file, about 50MB for CSV or spreadsheet files, 20MB per image and 2M tokens per text file, with a general cap of 80 files every 3 hours (OpenAI). Free users get 3 file uploads per day, which is usually enough if you have one or two files to look at and don't need to iterate much. If you're uploading files daily, Plus raises the limits for USD 20 per month — OpenAI notes there's no annual billing option for Plus and that model availability and limits change over time, so check the current plan on OpenAI's site before you commit.

Gemini accepts files up to 100MB and up to 10 files per prompt. For Copilot, note that Microsoft's Excel FAQ also says to review, edit and verify anything Copilot creates — the same caveat applies whichever tool you pick.

A prompt to paste

Upload your file first, then paste this. Replace the bracketed parts.

You are analysing the spreadsheet I uploaded.

1. Describe the data: columns, number of rows, date range.
2. Flag data problems before doing anything else: missing values, duplicate rows,
   numbers stored as text, dates stored as text. Do not silently fix them.
3. Answer this question: [what did sales by region do between January and June?]
4. Create a [line] chart of [revenue] by [month], grouped by [region].
5. Below the chart, give me 3-5 bullets: what changed, by how much, any outlier
   worth checking, and what you excluded and why.
6. Show the code or calculation you used, and list every assumption you made.
7. Tell me what this chart cannot tell me.

Two follow-ups that usually pay off:

Change the chart to a [bar] chart grouped by [region] instead of [month].
Does the story change? If so, say which one is misleading and why.

Which rows drive the biggest change? List them and show how much of the
total movement they account for.

How far AI gets you

AI assists. The tool does the mechanical part — reading the file, aggregating it, drawing the chart, suggesting what stands out — and OpenAI's help centre still tells you to review the code, outputs and assumptions before you rely on it, partly because ChatGPT may pick an analysis method or chart type that doesn't match your intent on the first try. You keep the judgement: what question was worth asking, whether the numbers are right, and what the chart means.

What you still do

Name the chart and the columns. Ask for the chart type, grouping and measure you want rather than "chart this". ChatGPT may choose a method or chart type that doesn't match your intent first time.
Check the mechanics of the output. Interactive charts are supported for bar, line, pie and scatter; other types come back as static images you can't hover or filter (OpenAI).
Recompute at least one number yourself. Open the file, sum one column or filter one category, and confirm the chart agrees.
Read the assumptions. Things like how blanks were treated, whether partial months were dropped, or which currency a column is in change the story.
Decide what the outlier means. The tool can point at a spike; only you know whether it was a real event or a data-entry error.
Handle sensitive data deliberately. In Settings > Data controls you can turn off "Improve the model for everyone" so new conversations aren't used to train OpenAI models; chats still stay in your history, and temporary chats are not used to improve models (OpenAI).
Don't stop at the AI answer for decisions with consequences. For tax, legal, insurance, health or money questions, use the official source or a licensed professional.

Common questions

Can I do this on the free plan of ChatGPT?

Yes, with limits. Free users are capped at 3 file uploads per day, so a single file with a few rounds of follow-up questions works, while a project with many files won't (OpenAI).

Will my uploaded data be used to train the model?

Only if you leave the setting on. Turning off "Improve the model for everyone" under Settings > Data controls means new conversations won't be used to train OpenAI models (OpenAI).

Why does the chart look wrong?

Most often because the tool guessed. Ask for a specific chart type and name the columns, and check whether the shape changed because of an assumption rather than the data — OpenAI notes the first attempt may not match your intent.