Combine CSV files into one report

Turn a folder of exports into one clean spreadsheet.

DocumentsInstant

The prompt

Combine all CSV files in ~/Downloads/exports into one Excel file. Keep the header once, add a column with the source file name, and remove exact duplicate rows. Tell me how many rows came from each file.

How to use it

Make sure Shellway is connected in ChatGPT, Claude or Cursor.
Paste the prompt and change the folder names or paths to match your computer.
Review the plan your AI shows before you confirm any changes.

Related prompts

Extract data from PDFs

Pull dates, amounts and names from a folder of invoices or bills into Excel.

Summarise a folder of documents

Get a one-page brief of everything in a folder of Word files and PDFs.

Build a notes knowledge base

Turn scattered notes into an organised folder of linked Markdown files.