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 reads and writes the data in the apps you connect, so the shape of your spreadsheet and the names of your form fields are part of the design. This is where these tools stop being a chat and start being work, and where the failure modes are worth knowing.
The concept
It reads and writes the data in the apps you connect, so the shape of your spreadsheet and the names of your form fields are part of the design. 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 — write the field names down between steps before you build, the way you would write a schema — then you can fix it yourself next month when the columns change.
Worked example
A spreadsheet whose column headers are consistent becomes a usable database for automations; one with merged cells and three date formats does not.
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 reads and writes the data in the apps you connect, so the shape of your spreadsheet and the names of your form fields are part of the design.
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.