Step-by-step
📊 ChatGPT
OpenAI
📘 Step-by-step 📘 OpenAI · ChatGPT↗ ChatGPT · Official sitebeginner 🔄 Life & Business

How to analyze files and spreadsheets with ChatGPT

Upload a PDF or Excel file, get a quick plain‑language summary, pull out specific figures and even generate a simple chart – all in a few easy steps.

6 min read·June 24, 2026·🔄 Updated:

This guide was written by AI. It passed automated fact and quality checks, and our editor spot-checks published guides every day.

See AI World HQ first on GoogleAdd us as a preferred source and our stories show up higher in Google’s Top Stories.Add on Google

By the end of this guide you'll be able to drag‑and‑drop a PDF report or an Excel budget into ChatGPT, ask it for a short summary, request exact numbers, and have it draw a basic chart for you. This is for anyone who wants to make sense of documents faster, whether at home or at work.

💡 Tip: tap a step’s number when you finish it — a green tick appears and your browser remembers how far you got.

✅ Before you start
  • A free or paid ChatGPT account (sign up at chat.openai.com if you don't have one).
  • A web browser on a laptop, desktop or tablet – the file‑upload button is easiest to see on a full‑size screen.
  • The document you want to explore: a PDF (Portable Document Format) or a spreadsheet file such as XLSX, CSV or a Google Sheet export.
  • An internet connection and about 5 minutes of uninterrupted time.
  • For chart generation (Step 5), you'll need a paid ChatGPT plan (Plus, Team, or Enterprise).
1
Step 1 of 5

Open a new chat

Click the + New Chat button – usually a plus‑sign at the top‑left of the ChatGPT homepage. You'll see a blank conversation window with a faint line that says "Start typing…" at the bottom. The platform prepares a fresh context so the AI will focus only on the file you later provide.

💬 Examplesimply click the button – no text to type yet.
✅ You'll know it worked when

the chat pane clears and a blinking cursor appears ready for you to type.

🔄 If it looks different

If you don't see a plus‑sign, look for a button that says "New chat" or a similar icon in the upper corner.

Next step ↓
ChatGPT+ New Chat
✏️ Sketch — your screen may look a little different
2
Step 2 of 5

Upload your file

Locate the paper‑clip icon or a button labeled "Upload a file" underneath the text box. Clicking it opens your computer's file picker; navigate to the PDF or spreadsheet you saved and select it. After you confirm, a small thumbnail (for PDFs) or a file name (for spreadsheets) appears inside the chat area. This is the AI's equivalent of handing a paper report to a colleague.

💬 Exampleselect *budget‑2025.xlsx* and wait for the thumbnail to show.
✅ You'll know it worked when

the file name or preview shows up right under the message box.

🔄 If it looks different

If you don't see a paper‑clip, look for a button that says "Attach" or a menu item called "Upload".

Next step ↓
Upload your file
3
Step 3 of 5

Ask for a plain‑language summary

Type a concise request such as:

Please give me a short summary of the main points in this file.

When you press Enter, ChatGPT scans the uploaded document and begins typing a paragraph that highlights headings, key figures and any conclusions it finds – much like a teammate giving you the gist of a meeting. The response may take a few seconds, especially for larger PDFs. If the reply looks generic, try adding "in plain language" to your prompt.

💬 Examplecopy‑paste the exact sentence above.
✅ You'll know it worked when

the AI returns a short paragraph that mentions the document's major sections or numbers.

Next step ↓
ChatGPTEnter
✏️ Sketch — your screen may look a little different
4
Step 4 of 5

Query specific data

Now ask a focussed question, for example:

What was the total revenue listed for Q3?

or, for a spreadsheet:

Which product category had the highest sales in the East region?

After you send the prompt, the model looks through the file, finds the relevant row or cell, and replies with the exact value and a brief context. If the answer seems unrelated, make sure you referenced the correct file – you can re‑upload it or specify "in the spreadsheet". If the AI says it cannot find the data, try phrasing the request differently, such as "show me the cell that contains Q3 revenue".

💬 Examplecopy‑paste either of the two questions above.
✅ You'll know it worked when

the response includes a number (e.g., "$2.8 million") and mentions the row or column where it was found.

Next step ↓
Query specific data
5
Step 5 of 5

Request a simple chart

Finally, ask the AI to visualise the data. A typical prompt looks like:

Create a bar chart of quarterly sales from the spreadsheet.

The assistant will generate an image of a bar chart and embed it directly in the chat. You can right‑click the image and choose "Save image as…" to download it for a report or presentation. Chart generation requires a paid ChatGPT plan – it's not available on the free tier. If no chart appears, check that the file contains numeric sales data and try a more explicit request such as "draw a line chart of the sales column".

💬 Examplepaste the exact sentence above and hit **Enter**.
✅ You'll know it worked when

a picture of a chart shows up beneath your message, complete with labeled axes.

Request a simple chart
⚠️ Common mistakes
  • Uploading the wrong file type: ChatGPT only accepts PDFs, XLSX, CSV and a few image formats. Double‑check the file extension before you click "Open". Fix: If the upload fails, select a supported file and try again.
  • Being too vague in the prompt: Phrases like "Explain this" often lead to generic replies. Fix: Include the specific thing you want – "summarize the key findings" or "list the Q3 revenue".
  • Expecting the AI to edit the original file: ChatGPT can read and comment on a document, but it cannot change the file itself. Fix: After you get the information, open the original file in Excel or a PDF editor to make any edits.
  • Trying to generate charts on the free plan: Chart generation requires a paid ChatGPT subscription. Fix: Upgrade to Plus, Team, or Enterprise if you need visualisations.
🚀 Try it now

Open a recent PDF receipt or a small Excel file, start a new ChatGPT chat, upload the file, and type: 

Summarize the main points in this file.

You'll see the AI turn a raw document into clear, actionable information in under two minutes. Happy analyzing!

🎯 Next guideGetting Started with ChatGPT: Your First 15 MinutesA friendly walk‑through that gets you set up, sends your first prompt, and shows how to keep the conversation going—all in under a quarter of an hour.

❓ Quick questions

How long does this take?

About 6 minutes — the guide has 5 steps, and you can tick each one off as you go.

Which tool do I need?

This guide uses OpenAI ChatGPT — but the approach works very similarly in other AI assistants.

Do I need to prepare anything?
  • A free or paid ChatGPT account (sign up at chat.openai.com if you don't have one).
  • A web browser on a laptop, desktop or tablet – the file‑upload button is easiest to see on a full‑size screen.
  • The document you want to explore: a PDF (Portable Document Format) or a spreadsheet file such as XLSX, CSV or a Google Sheet export.
  • An internet connection and about 5 minutes of uninterrupted time.
  • For chart generation (Step 5), you'll need a paid ChatGPT plan (Plus, Team, or Enterprise).
What mistakes should I avoid?
  • Uploading the wrong file type: ChatGPT only accepts PDFs, XLSX, CSV and a few image formats. Double‑check the file extension before you click "Open". Fix: If the upload fails, select a supported file and try again.
  • Being too vague in the prompt: Phrases like "Explain this" often lead to generic replies. Fix: Include the specific thing you want – "summarize the key findings" or "list the Q3 revenue".
  • Expecting the AI to edit the original file: ChatGPT can read and comment on a document, but it cannot change the file itself. Fix: After you get the information, open the original file in Excel or a PDF editor to make any edits.
  • Trying to generate charts on the free plan: Chart generation requires a paid ChatGPT subscription. Fix: Upgrade to Plus, Team, or Enterprise if you need visualisations.

Keep reading

📘 How to study and learn faster with AI – a beginner’s step-by-step guide Turn complex subjects into clear explanations, generate quick practice quizzes, and check your understanding – all using a free AI chat tool. 📘 How to Draft a Wedding Speech When You Have No Idea Where to Start Use ChatGPT to turn a few honest details about the couple into a short, heartfelt toast you'll actually want to deliver. 📘 Getting Started with ChatGPT: Your First 15 Minutes A friendly walk‑through that gets you set up, sends your first prompt, and shows how to keep the conversation going—all in under a quarter of an hour. 📘 How to Build a Beginner Workout Plan With ChatGPT (and Stick to It) Tell ChatGPT your goal, time and gear, then adjust the plan each week instead of saving another PDF you'll forget about. 📘 How to upload a long PDF and get a plain-English summary from Claude Drop a dense contract, research paper, or user manual into Claude and walk away with a short summary plus the points you actually need. 📘 Draft a Complete FAQ Page for Your Website with ChatGPT Learn how to use ChatGPT to quickly generate a comprehensive list of frequently asked questions and answers for your website, simplifying customer service and saving you time.
Was this helpful?

✦ Generated by AI in AI World HQ's automated newsroom, written in plain language. Checked by automated fact and quality gates, and our editor spot-checks published guides every day. Spot a mistake? Use the buttons above.

📘 Prefer it in one file? Work and Email: The AI Pack (20 guides, free printable PDF)

← Back to all stories