I’ve been manually cleaning up spreadsheets for years. Client data exports. Downloads from accounting software. Contractor invoices that came in as barely-readable CSVs. Every one of them required half an hour of reformatting before I could actually use it. Last month I dropped one into Claude out of frustration and typed “fix this.” Not expecting much. It returned a properly formatted .xlsx file. Headers aligned. Dates normalised. Currency columns showing as currency. Blank rows removed. Inconsistent spelling fixed. Sortable tables where there used to be blobs. Same data, finally usable. Opened in Excel like any other file. This is the prompt that works reliably: I’m uploading a file that has the following problems: [describe the mess - inconsistent formatting, scattered blank rows, dates in three different formats, no clear headers, whatever] I want the cleaned-up version to: - [specific thing #1, e.g. “every date in YYYY-MM-DD format”] - [specific thing #2, e.g. “currency as $ with two decimals”] - [specific thing #3, e.g. “blank rows removed, sorted by date descending”] Return the cleaned version as a downloadable .xlsx file. If you spot anything that looks like a data error (duplicates, impossible values, missing required fields), flag it separately before fixing. Don’t silently correct things that might be real. The file is attached. The last paragraph is the one that earns its keep. Without it, Claude will silently “fix” things you didn’t want fixed. With it, you get a list of items to verify before you trust the output. Things worth knowing if you try it: Works for .xlsx, .xls, .csv, .docx, .pptx, and .pdf. The output is a real file, not text you paste back in. For spreadsheets specifically, Claude can add working formulas, conditional formatting, and multiple sheets - not just data cleaning, actual spreadsheet logic if you ask for it. Expect one round of edits. The first pass isn’t always perfect. Still 10x faster than doing it manually. For very large files (thousands of rows), ask Claude to work in sections or use its analysis tool. Big files work but get more reliable in chunks. Don’t upload sensitive data you haven’t cleared. Standard rules apply. The reframe that made this useful for me: most users still think of Claude as a text tool. Text in, text out. The mental model that unlocks the actual value is Claude as a document operator
- files in, transformed files out. Every document in your workflow that’s slightly wrong, slightly messy, slightly outdated, or in the wrong format can be fixed in one prompt rather than manually rebuilt. I wrote up 10 specific tools I cancelled after figuring this out, with the exact prompts that replace each one, here if it helps. If you only test this on one file this week, try it on the messiest spreadsheet you’ve been avoiding. The first time you get back a properly formatted file in 90 seconds is the moment the mental model shifts. submitted by /u/Professional-Rest138
Originally posted by u/Professional-Rest138 on r/ArtificialInteligence