All Mini Tutorials

AI Does It For You

Turn a Spreadsheet Into an Interactive Chart in ChatGPT

Upload a sales or expense spreadsheet and get a chart you can click and filter, plus a simple "what if" calculator, then check the numbers yourself.

5 minBeginnerExcel, Small BusinessChatGPT

The problem

You have a spreadsheet full of numbers, such as monthly sales, expenses or orders, and you want to see what is going on without building charts and formulas yourself. Since October 2026, ChatGPT can answer with interactive charts, buttons, forms and small tools instead of only text. OpenAI calls this Intelligent UI. That means you can upload a spreadsheet and get a chart you can click and filter, or a small "what if" calculator, right in the chat. It is a fast way to explore your numbers. It is not a replacement for your spreadsheet, and the numbers still need a quick check before you rely on them.

What you need

  • ChatGPT on the web (chatgpt.com) or in an up-to-date ChatGPT mobile app.
  • As of October 11, 2026, Intelligent UI is rolling out on every ChatGPT plan, including Free and Go. Older ChatGPT desktop apps for Windows and Mac do not support it.
  • A spreadsheet saved as Excel (.xlsx) or CSV.
  • One question you want answered, such as "Which product sold best each month?"

Safety first

Work on a copy of your spreadsheet, never the original. Before you upload it, delete columns you do not need for the chart, especially customer names, email addresses, phone numbers, home addresses and bank or card details. A chart of sales by month needs dates, products and amounts, not who bought them. If the file belongs to your employer, check whether you are allowed to upload it to an AI tool. Treat every number ChatGPT shows you as a draft until you have checked it against your spreadsheet.

Copy-paste prompt

I have attached a spreadsheet of [DESCRIBE IT, e.g. monthly sales by product]. Please do this in order: 1. FILE CHECK: Tell me in plain English what is in the file: the columns, the date range, the number of rows, and anything that looks wrong, such as blank cells, duplicates or odd values. Do not fix anything yet. 2. CHART: Show me an interactive chart of [WHAT YOU WANT TO SEE, e.g. sales by month], where I can filter by [e.g. product]. 3. WHAT IF: Add a simple calculator: if I change [e.g. price] by a percentage, show what happens to [e.g. total revenue]. List the assumptions you used. 4. CHECK NUMBERS: Give me 3 totals from the file that I can check by hand in my spreadsheet. Use only the numbers in my file. If something is unclear, ask me instead of guessing.

Steps

  1. Make a safe copy. Save a copy of your spreadsheet, delete any columns with personal or payment details, and keep only the columns you need for your question.
  2. Open ChatGPT on the web or in the up-to-date mobile app. Attach the copy using the paperclip or + button, then paste the copy-paste prompt above and fill in the brackets.
  3. Read the file check first. If ChatGPT finds blank cells, duplicates or odd values, fix them in your spreadsheet and upload it again, or tell ChatGPT how to treat them.
  4. Explore the chart. Click or tap the filters and the points on the chart. Ask follow-up questions in plain language, for example: "Show this by quarter instead of by month." "Compare 2025 with 2026." "Which three products dropped the most?"
  5. Check 3 numbers. Compare the 3 totals ChatGPT gave you with a SUM in your own spreadsheet. If any do not match, tell ChatGPT which ones and ask it to show how it calculated them.
  6. Keep your spreadsheet as the master copy. Use the chat to explore and decide, then record the decisions and the checked numbers in your spreadsheet. A screenshot of the chart is a quick way to share what you found.

What success looks like

Before: a spreadsheet full of numbers and no clear picture. After: a chart you can click and filter, a "what if" calculator for one decision, and 3 numbers you have checked against your own file. Current as of October 11, 2026. ChatGPT features and rollout can change quickly, so check OpenAI's ChatGPT help pages for the latest details.

If it goes wrong

Only getting text or a still picture instead of an interactive chart? Intelligent UI is rolling out gradually, so it may not have reached your account yet. Use ChatGPT on the web or update the mobile app. Older desktop apps for Windows and Mac do not support it. On the web, check that Settings → "Layout and visuals" is turned on. You can also ask directly: "Show this as an interactive chart I can filter." If the numbers look wrong, ask ChatGPT: "List each column and how you read it." Dates stored as text and amounts with currency symbols are the most common causes.

Next useful tutorial

Clean a Messy Customer Spreadsheet With AICompare Two Excel Files With AI and Find What ChangedScan Receipts Into Excel With AI — No Manual Typing
Spreadsheet to Interactive Chart in ChatGPT | NonDevApps