AI WORLDHow to analyse files and spreadsheets with ChatGPT
Learn how to upload a PDF or Excel sheet, ask for a quick summary, get answers, and create simple charts – all in a few easy steps.
Hook: 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 to summarise the key points, pull out specific data, and even ask for a basic chart – no coding required. This is for anyone who wants to make sense of documents faster, whether at home or at work.
- You need a free (or paid) ChatGPT account – sign up at chat.openai.com if you haven’t already.
- A web browser on a computer or tablet; the file‑upload feature works best on a desktop‑size screen.
- A PDF file or a spreadsheet (XLSX, CSV, or Google Sheet) you’d like to explore.
Open a new chat
In the ChatGPT web page click the + New Chat button (usually a plus sign at the top left).
Why? Starting a fresh conversation keeps the AI’s focus on the file you’ll give it, without mixing in past topics.
[New Chat] – you’ll see a blank chat window ready for your prompt.
Upload your file
Look for the paper‑clip icon or the “Upload a file” button at the bottom of the chat box. Click it, then select your PDF or spreadsheet from your computer.
Think of this like handing a colleague a printed report; the AI will read it just as a human would.
You select budget‑2025.xlsx and see a small thumbnail appear in the chat area.
Ask for a plain‑language summary
Now type a simple request such as:
Please give me a short summary of the main points in this file.
The AI will scan the document and return a concise paragraph that highlights headings, key figures, or conclusions – just like a quick briefing you might get from a teammate.
“Your budget shows a 7 % rise in marketing spend, a stable payroll cost of $1.2 million, and a projected net profit of $3.4 million for FY 2025.”
Query specific data
If you need a particular answer, ask a focused question. Replace “summary” with something like:
What was the total revenue listed for Q3?
or for a spreadsheet:
Which product category had the highest sales in the East region?
The AI will locate the exact cell or row that contains the answer and reply with the value and its context.
“The Q3 revenue is $2.8 million, which is 12 % higher than Q2.”
Request a simple chart
ChatGPT can generate a quick bar or line chart using the data you’ve provided. Write a prompt such as:
Create a bar chart of quarterly sales from the spreadsheet.
The AI will produce an image of the chart and embed it in the chat. You can download the chart by right‑clicking and saving it, then paste it into a report or presentation.
A bar chart appears showing sales for Q1‑Q4, with each bar labelled by quarter.
- Uploading the wrong file type: The chat only accepts PDFs, XLSX, CSV, and a few image formats. Double‑check you selected the correct document.
- Vague prompts: Asking “Explain this” without specifying what you want (summary, numbers, chart) can give a generic answer. Be as specific as possible.
- Expecting complex visualisations: ChatGPT can make simple charts, but detailed dashboards need dedicated spreadsheet tools.
Open a recent PDF receipt or a small Excel file, start a new ChatGPT chat, upload the file, and type:
Summarise the main points in this file.
You’ll see how fast the AI turns a raw document into clear, actionable information – all in under two minutes. Happy analysing!
✦ Original step-by-step guide by AI World Co.'s AI editorial team. Written in plain language, reviewed for accuracy.
← Back to all stories