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: It produces files you can download, and it can work from files you upload — a spreadsheet in, a cleaned spreadsheet out. This is where these tools stop being a chat and start being work, and where the failure modes are worth knowing.
The concept
It produces files you can download, and it can work from files you upload — a spreadsheet in, a cleaned spreadsheet out. 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.
For a spreadsheet, ask for the formula and an explanation instead of the computed column — require a source next to every number, since the agent will otherwise fill gaps — then you can fix it yourself next month when the columns change.
Worked example
Upload a messy list of forty companies and get back the same list with a website, a sector and a source for each.
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
It produces files you can download, and it can work from files you upload — a spreadsheet in, a cleaned spreadsheet out.
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.