Skip to content
QDNALearn AI
FR

Lesson 8 · Intermediate · 15 min

Analyzing Documents and Files with ChatGPT

Analyze business files with ChatGPT: spreadsheets, PDF records, and memos. Extracting key metrics, targeted summaries, and data safety precautions.

Goal
You will upload business documents to ChatGPT, extract critical metrics, and verify the accuracy of cited factual excerpts.
Skills
Check
Step-by-step screenshot of ChatGPT: (1) uploading spreadsheet via (+), (2) analytical grouping prompt, (3) verified expense breakdown table.
Illustration generated by AI
In brief.

Document analysis in ChatGPT enables direct querying of PDF reports, spreadsheets, and extensive business agreements. Combining digital text extraction with OCR vision, the engine isolates critical terms and synthesizes complex records. To maintain legal defensibility, always demand verbatim quotations coupled with exact page citations for every extracted claim.

  1. 1Document ingestion and targeted extraction in ChatGPT

    Document ingestion and targeted extraction in ChatGPT turns hours of manual document review into structured analytical dialogues. When a file is uploaded, the platform parses text layers, indexes core passages, and injects relevant snippets directly into the attention window.

    With extensive records, the system may exhibit reduced focus on clauses located in the middle sections. Enforcing mandatory verbatim citations with page references compels the language model to locate the physical source before generating findings.

    Document Format Ingestion Pipeline Core Advantage Operational Precaution
    Digital PDF Direct text layer parsing High throughput and layout fidelity Verify multi-column text ordering
    Scanned PDF Optical Character Recognition Unlocks legacy archived paperwork Scrutinize ambiguous numerals
    Excel / CSV Tabular parser or Python Structured aggregation and sorting Run Code Interpreter for exact sums
    Word (.docx) Structural hierarchy reader Native heading and list preservation Strip private internal draft comments
    Diagram of document analysis: uploading PDF or spreadsheet files, text parsing, targeted extraction, and source quote verification.Diagram of document analysis: uploading PDF or spreadsheet files, text parsing, targeted extraction, and source quote verification.
    Diagram of document analysisDiagram generated by AI and reviewed
  2. 2Auditing an annual PDF report to extract critical ratios

    Auditing an annual PDF report to extract critical ratios eliminates manual data entry mistakes while preserving full auditability back to official financial notes.

    An ESG analyst assesses a contractor's annual report to evaluate greenhouse gas disclosures.

    Weak prompt.

    Review the attached PDF and tell me the company's carbon emissions.
    

    The model yields an aggregate figure without clarifying Scope boundaries or citing document locations.

    Strong prompt (Turn 1).

    Context: ESG audit of the attached annual PDF. Task: Extract the 2024 greenhouse gas inventory into a 4-column table: Emissions Scope (Scope 1, 2, 3), Emissions (Metric Tons CO2e), Year-over-Year Delta, and Source Page Number. Absolute rule: Quote the exact sentence verifying each reported metric.
    

    The model extracts reported data cleanly with verifiable page references.

    Turn 2: Capital expenditure audit follow-up.

    To uncover underlying capital commitments without losing context, the analyst follows up:

    From the same document, list in a three-column table the capital expenditure planned for decarbonizing the transport fleet: Initiative, Allocated Budget 2025-2026, Page. If an amount is not stated, write "not specified".
    

    ChatGPT extracts the three budget lines without speculating, referencing the exact financial disclosure notes.

    What changes. The initial prompt enforces strict accounting boundaries. The follow-up deepens the inquiry into actual investments without starting from scratch.

  3. 3Extract contractual obligations from a business agreement

    Extract contractual obligations from a business agreement to practice employing ChatGPT as a dependable legal pre-review assistant.

    To practice without handling sensitive records, here is an anonymized master services excerpt (fictional company NovaTech Ltd), ready to copy or save into logistics_agreement.docx:

    [Logistics Services Agreement Excerpt - NovaTech Ltd (Fictional Training Sample)]
    Article 3 - Service Level Agreements (SLA): The service provider guarantees monthly order platform availability of 99.5%.
    Article 4 - Dispatch Timelines: All orders validated before 2:00 PM must ship on the same business day. In the event of delays exceeding 48 hours not caused by force majeure, a fixed delay penalty of €150 excl. VAT per calendar day is credited against the monthly invoice.
    Article 5 - Data Residency & Security: Order tracking logs must reside exclusively within the European Union. (Audit Note: this contract contains no stipulations governing end-of-contract data reversibility or transfer protocols).
    

    The "Load exercise" button in the composer pre-fills the objective with the weak starting prompt:

    "Analyze this attached contract and list the provider's obligations."

    From this starting point, complete the prompt with the composer. Define the legal counsel role and require a four-column table: article, obligation, verbatim quote, and delay penalty.

    Enable the "not found" fallback for unstated terms, particularly data reversibility. Apply the end-instruction technique (arXiv:2307.03172) by placing your questions at the end to prevent attention loss across documents.

    Self-evaluation rubric: (a) document ingestion proceeds without error; (b) contractual articles and delay penalties are accurately identified with verbatim citations; (c) the absent reversibility clause correctly returns "not found".

    Open the prompt composer

  4. 4Exceeding context bounds or assuming the entire file was memorized

    Exceeding context bounds or assuming the entire file was memorized leads analysts to miss critical conditional waivers buried deep in contract exhibits.

    Across a 120-page document, attention models may capture executive summaries effectively while missing a pivotal liability clause placed on page 64.

    Correction: for lengthy files, segment queries across specific chapters: 'Restrict your audit to Chapter 4 regarding Off-Balance Sheet Commitments (pages 55 to 70)'.

    Rule to remember: as document length increases, prompt directives must pinpoint the exact section to inspect.

  5. 5Quiz

    Three questions, instant feedback. Each option comes with an explanation.

    1. What requirement ensures an extracted figure actually originates from the uploaded document?

    2. Which file type requires heightened vigilance due to optical character recognition ambiguity?

    3. How can you minimize information loss when auditing an 80-page document?

  6. 6Proof of mastery

    Upload a workplace document and produce a rigorous extraction featuring three verbatim quotes with their respective page references.

    Intermediate badgeThis lesson counts towards the Intermediate badgeSee the four badges

    Criteria

Going further

Review glossary definitions for context window and hallucination. Proceed to lesson 9: Multimodal ChatGPT vision and images. For processing large datasets with mathematical precision, explore Advanced Data Analysis with Python.

Frequently asked questions

Which file formats can ChatGPT ingest directly?

ChatGPT processes PDF documents, Word files (.docx), Excel spreadsheets (.xlsx, .csv), slides (.pptx), and plain text formats (.txt, .md, .json).

How does ChatGPT extract information from a PDF?

The system parses digital text layers and performs internal semantic retrieval. For scanned PDFs without text layers, it utilizes native OCR vision models.

Are uploaded files stored indefinitely in your account?

Files remain tied to the active chat conversation thread until deleted. In Team and Enterprise workspaces, they remain shielded within organizational boundaries.

Sources