Module 3 · Files, tools and your own data Lesson 8 of 15
Files, tables and long documents
Uploading a PDF, a spreadsheet or a screenshot and asking questions about it: ChatGPT reads uploaded PDFs, spreadsheets, images and slides, and its data analysis tool will compute on a spreadsheet rather than guess. This is where these tools stop being a chat and start being work, and where the failure modes are worth knowing.
The concept
ChatGPT reads uploaded PDFs, spreadsheets, images and slides, and its data analysis tool will compute on a spreadsheet rather than guess. The two failures to expect are the ones nobody warns you about: a long document is summarised as it is read, so a detail on page 60 can be missed; and a table with merged cells or a scanned page is likely to be read wrongly.
So the working method is: ask narrow questions, and ask the tool to quote the line it is answering from. "From the attached file only, what does clause 4.2 let me do? Quote the sentence." If it cannot quote it, it did not read it.
Common mistakes
For a spreadsheet, ask for the formula and an explanation instead of the computed column — ask for the formula, an explanation of each part, and what breaks on a blank cell — then you can fix it yourself next month when the columns change.
Worked example
Upload a marksheet and ask "which three subjects dropped the most between semester 3 and 4" — it can do the arithmetic, which is exactly what a chat window could not do two years ago.
Your practice task
Upload one real document you already own — a syllabus, a marksheet, a project report — and ask three questions whose answers you already know. When it gets one wrong, read the passage it quoted before you blame the file.
Do this before moving on. Reading a solution teaches the shape of it; typing it teaches you.
Key takeaway
ChatGPT reads uploaded PDFs, spreadsheets, images and slides, and its data analysis tool will compute on a spreadsheet rather than guess.
Keep your place in this course
A free account saves which lessons you have finished and unlocks the certificate. The lesson itself stays free to read.
Create free account or sign inCourse complete
You finished every lesson.
Your certificate is ready, and the projects you built are the proof to attach to an application.
Almost there
15 lessons left of 15
Finish every lesson to unlock the certificate. Each one ends in a practice task — do them and the final project brief writes itself.