Domain 218%

Quick Reference: File Management, Data Processing & Output

TL;DR

One-page cheat sheet for File Management, Data Processing & Output

File Access & Permission Model

  • Folder access: Granted per session, scoped to the selected folder and its subfolders only
  • Read/write: Free within the granted folder — no permission prompt
  • Deletion: Requires explicit user approval via system-level prompt
  • Overwrites: No permission prompt — an overwritten file is just as lost as a deleted one
  • Path traversal: Impossible — Claude cannot access parent directories even if you type the full path
  • Session boundaries: Each new session requires re-selecting a working folder

The #1 security rule: Never point Cowork at Documents, Desktop, or your home folder. Always create a dedicated workspace and copy only the files you need.

Document Analysis Decision Table

ScenarioBest Approach
Quick question about one documentChat upload (simple, fast)
Analyse a single large file (>30MB)Cowork — direct file access, no size limit
Cross-reference multiple documentsCowork — all files in one working folder
Batch extract data from 20+ filesCowork with sub-agents — "for each one" phrasing
Ongoing reference across many sessionsProject knowledge base (up to 200K tokens)

Common trap: Analysing files one at a time in separate sessions loses cross-document synthesis. Keep all related files in the same working folder.

Professional Document Creation

What Cowork can create:

  • Excel (.xlsx) with working formulas (VLOOKUP, SUMIFS, IF), conditional formatting, charts, and multiple tabs
  • Word (.docx) with heading hierarchies, tables, bullet lists, and page breaks
  • PowerPoint (.pptx) with structured slides, data tables, and logical flow
  • PDF reports with professional formatting

What it cannot do well:

  • Corporate-branded slide decks (no custom themes or animations — treat as a first draft)
  • Designer-quality visual layouts

Quality depends on prompt specificity:

Prompt qualityTypical output
"Create a spreadsheet"Flat data dump, no formulas
Specify formulas, tabs, charts, formattingProfessional workbook ready for leadership

Batch Processing Patterns

  • Trigger phrases for parallelism: "for each one," "analyse all," "process every," "in parallel"
  • Best for: Renaming, converting, extracting, summarising many files
  • Sub-agents handle: Independent units of work (one file per agent)
  • Main agent handles: Combining results after all sub-agents complete
  • Always review the plan — errors multiply across all files simultaneously

Sequential vs Parallel decision rule:

  • Files are independent (each can be processed alone) → Parallel
  • Step 2 needs Step 1's output (e.g., rename based on content analysis) → Sequential

Output Format Specification Checklist

For every document creation task, specify:

  • File type — .xlsx, .docx, .pptx, .pdf, .csv
  • File name — e.g., "Q1-Regional-Summary.xlsx"
  • Structure — tabs, sections, slides, pages
  • Formulas — SUMIFS, VLOOKUP, IF, SUBTOTAL
  • Formatting — conditional highlighting, colour coding rules
  • Charts — bar, pie, line; what data they visualise
  • Column names — explicit headers for each data column
  • Naming conventions — for batch-produced files

Without a format specification, Claude defaults to a conversational text response in the chat window rather than creating a file on your system.

Common Exam Traps — Domain 2

TrapCorrect Answer
"The 30MB file limit applies to Cowork"30MB limit is Chat-only; Cowork reads files directly from disk
"Claude asks permission before editing files"Deletion protection only; edits and overwrites happen freely
"Folder access carries over between sessions"Access is granted per session; each new session requires selection
"Cowork can only create text files and CSVs"Creates .xlsx, .docx, .pptx, and .pdf with full formatting
"Excel formulas are static values"Cowork writes real working formulas that recalculate
"Document creation needs the Analysis Tool toggle"That toggle is Chat-specific; Cowork uses its sandboxed VM
"Sub-agents share context during parallel analysis"Sub-agents work independently; the main agent synthesises after