It’s a Monday morning. There’s a CSV from accounting sitting in your downloads. Dates in three different formats. Currency showing as plain numbers. Blank rows scattered every few lines like landmines. You open it, feel a small death inside, and close it again. Tomorrow, you tell yourself.
u/Professional-Rest138 on Reddit had the same routine for years. Client data exports. Downloads from accounting software. Contractor invoices that came in barely readable. Each one required 30 minutes of reformatting before it was actually usable.
Last month, the author dropped one of those files into Claude out of frustration and typed two words: “fix this.”
What came back was a properly formatted .xlsx. Headers aligned. Dates unified. Currency columns showing actual currency. Blank rows gone. Inconsistent spelling normalized. Sortable tables where there used to be blobs of text. It opened in Excel like any other file. Not a screenshot. Not text to paste back in. The actual rebuilt file.
📊 Why This Actually Matters
Most people still think of Claude as a text tool. Text in, text out. That mental model leaves a lot on the table.
The better frame, as the expert put it: Claude is a document operator. Files in, transformed files out. And this works across more formats than you might expect:
- Messy spreadsheets (.xlsx, .xls, .csv), which alone can replace hours of weekly manual work if you handle data regularly
- PowerPoint decks with inconsistent formatting (drop it in, ask for unified styling, get it back fixed)
- Word documents that need restructuring or cleaning
- PDFs you want converted to editable documents
- CSVs that need transforming into proper tables with calculated columns
The insight here isn’t just “AI cleans files.” It’s that every document in your workflow that’s slightly wrong, slightly messy, or in the wrong format is now a one-message fix instead of a manual rebuild.
🛠️ The Prompt That Makes It Work
Here’s the prompt the original poster developed through real use. Copy it exactly, fill in the brackets for your specific file, and attach:
I’m uploading a file that has [describe the problem – e.g. “inconsistent formatting, blank rows scattered throughout, dates in three different formats, and no clear column headers”].
Here’s what I want the cleaned-up version to do:
- [specific thing #1 – e.g. “every date in YYYY-MM-DD format”]
- [specific thing #2 – e.g. “currency columns formatted as $ with two decimals”]
- [specific thing #3 – e.g. “blank rows removed, data sorted by date descending”]
- [add any formulas or calculations you want included]
Return the cleaned file as a downloadable .xlsx (or .docx or .pptx as appropriate). Don’t just show me the changes, rebuild the file properly.
If you spot anything in the original 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.
That last paragraph is the one that earns its keep. Without it, Claude may silently “fix” things you didn’t want touched, overwriting data that just happened to look like an error. With it, you get a separate list of flags to review before trusting the output. When the data belongs to a client, that distinction matters.
The specificity in the instructions also matters. Vague input (“clean this up”) produces vague results. Telling Claude exactly what you want, down to date format, currency format, and sort order, is what gets you a file you can actually hand off.
💡 Tips Worth Knowing Before You Try
A few things the post’s author learned from putting this through real workloads:
- The first pass isn’t always perfect. Budget one round of corrections (“this column should be X, please redo”) before it’s done. It’s still 10x faster than doing it manually.
- For spreadsheets, you can ask for working formulas, conditional formatting, and multiple sheets. This isn’t just data cleaning. It’s actual spreadsheet logic Claude can build for you.
- For large files with thousands of rows, ask Claude to work in sections. It handles big files but gets more reliable in chunks.
- Don’t upload files with sensitive data you haven’t cleared for external tools. Apply the same standard you’d use with any service that processes your data.
One person in the thread added a useful extension: ask Claude to turn the cleaned spreadsheet into an HTML document with visuals before committing to the final format. Useful for data reviews where you want a quick overview first.
🧹 Try It on the One You’ve Been Avoiding
You almost certainly have a spreadsheet sitting in purgatory somewhere. Drop the messiest one in, use the prompt above, and see what comes back. The full thread with more examples and community variations is on r/PromptEngineering. Worth checking if you have edge cases specific to your file types.
You can drop a messy Excel file into Claude and get back a clean, formatted version. I didn’t know this until last month.
by u/Professional-Rest138 in PromptEngineering