Cowork · Lesson 02 Pro ~12 min read 4 batch patterns

File workflows: where the time really hides.

Most people don't realize how much time they lose to file shuffling — renaming, sorting, converting, extracting. Cowork is uniquely good at this because it can read every file in a folder and do consistent operations across all of them. Once you've used these patterns, you stop accepting tedious file work as a normal cost of doing your job.

Workflow 01 Batch rename with smart logic

1

Rename a folder of files based on their content

Manual file renaming is one of the most demoralizing chores in knowledge work. Cowork can read each file, understand what's actually in it, and apply consistent naming based on real content — not just a pattern.

The prompt that works

Smart batch renameLook at every PDF and Word doc in my 'Invoices' folder. For each one, rename it to the pattern: [YYYY-MM-DD]_[VendorName]_[InvoiceNumber]_[AmountUSD].pdf The vendor name and invoice number should come from the content of the file, not the existing filename. Use the invoice date for the date field. Show me the proposed new name for each one and wait for me to approve before renaming anything.

Best use cases

  • Cleaning up an Invoices/ or Receipts/ folder
  • Renaming photos based on date taken or content
  • Standardizing meeting notes filenames by date + topic
  • Adding project codes to a folder of project files
Always ask Cowork to propose names first and confirm before renaming. Renames are reversible if you have a backup but painful if you don't.
Time savings: Manual: 2-3 hours per 100 files. Cowork: 5 minutes of supervision.

Workflow 02 Convert between formats

2

Bulk format conversion that respects content

PDFs to Word for editing. Word to clean Markdown for the web. CSV to nicely formatted Excel. Image batches to a single PDF. Cowork handles all of these by chaining the right tools — and unlike a single-purpose converter, it understands when content needs cleanup along the way.

The prompt that works

Format conversion with cleanupTake every Word doc in my 'Blog drafts' folder and convert them to clean Markdown files (.md). When you do, strip out any Word-specific formatting weirdness (smart quotes, weird spacing, table-of-contents artifacts). Save the Markdown versions in a new subfolder called 'markdown-export'. Keep the original .docx files untouched.

Best use cases

  • Word → Markdown for static-site publishing
  • PDF → editable Word with formatting preserved
  • Image folder → single combined PDF for sharing
  • Excel → CSV with proper escaping for upload
Always save to a new folder, never overwrite originals. If something converts badly, you want to go back to the source.
Time savings: 100 documents converted in under 10 min with Cowork supervision.

Workflow 03 Extract structured data from messy files

3

Pull data out of files that weren't designed to be parsed

Receipts as photos. Invoices as PDFs. Email exports as inscrutable HTML. The world is full of files that have data in them but not in a form you can use. Cowork reads them, extracts what you need, and gives you a clean spreadsheet.

The prompt that works

Extract-to-spreadsheet patternLook at every receipt image and PDF in my 'Receipts-2026' folder. For each one, extract: • Date of purchase • Vendor name • Total amount (USD) • Category (food, travel, supplies, etc. — use your judgment) • Last 4 digits of the card if visible Put it all into a single Excel spreadsheet (.xlsx) called 'receipts-2026-extracted.xlsx' in the same folder, with one row per receipt. If you can't read a receipt, flag it in an 'unreadable' tab so I can review it manually.

Best use cases

  • Receipt/expense report aggregation
  • Customer testimonials pulled from email screenshots
  • Resume data extracted from a folder of PDFs
  • Survey responses scattered across multiple files
Extraction quality depends on file quality. Blurry phone-photo receipts will produce 'unreadable' entries — that's correct behavior, not failure. Cowork won't guess.
Time savings: 100 receipts: 4-5 hours manual data entry vs. 15 min Cowork.

Workflow 04 Clean up a messy folder

4

Triage, sort, and organize a folder that's spiraled

We all have folders like this — Downloads, Desktop, that one project folder. Files with random names, duplicates, half-finished work. Cowork can analyze the whole folder, propose an organization scheme, and execute it once you approve.

The prompt that works

Folder triageLook at every file in my Downloads folder. For each one, determine: • What type of file it is (document, image, code, executable, archive, etc.) • Whether it looks like work, personal, or junk • Whether it was opened in the last 30 days (if filesystem supports it) Propose a folder structure (e.g., '/Downloads/Work/Reports/', '/Downloads/Personal/Photos/', '/Downloads/Junk-to-review/'). Show me the proposed moves and which files would go where. Don't move anything yet — just give me the plan.

Best use cases

  • Cleaning up Downloads after years of accumulation
  • Reorganizing a project folder that got messy
  • Archive prep before a system migration
  • Setting up someone else's computer (consulting)
The plan-first pattern matters here especially. Don't let Cowork move 500 files without showing you the plan — sometimes its categorization is wrong in interesting ways.
Time savings: A 5-year-old Downloads folder: half a day manual → 30 min reviewing the plan.

Pick your most chaotic folder

Choose the folder on your machine that you've been avoiding cleaning up. Run the 'folder triage' workflow above. Review the proposed plan carefully, then approve it. You'll have a clean, sorted folder in 30 minutes instead of the half-day it'd take manually.

What you can do now

  • Use the 'propose first, execute after approval' pattern for any batch op
  • Always save converted/transformed files to a new folder, not overwrite
  • Trust Cowork to flag files it can't read instead of guessing
  • Set up consistent naming conventions for your most-used folders
  • Build a habit of running cleanup workflows monthly, not annually
Pro
Up next in Copilot Mastery

Lesson 03 · Document creation: build Word, Excel, PowerPoint from a single prompt

Once your folders are clean, the next big Cowork win is creating documents from data — full Word reports, formatted Excel sheets, polished PowerPoint decks. With the skills system, output quality matches what a human would produce. See the track →