Trust your numbers again with a plain-English spreadsheet audit
It explains every formula in plain English and spots the broken one you've trusted for years.
A picture made with AI to show the idea.
Your prompt
Fill in your details. Skip any you like.
Claude opens with your prompt already typed in. It's copied too, just in case.
The prompt that gets copied
Don't change anything in this spreadsheet. Audit it and give me: 1) what this spreadsheet is for and how it's laid out, in plain English, 2) every formula and what it does, explained so a non-accountant understands, 3) any errors, broken references, typed-in numbers that should be formulas, or logic that looks wrong, ranked by how much they could cost me, 4) anything confusing in the layout, and 5) how you'd rebuild it better from scratch. This is my [SPREADSHEET TYPE, e.g. pricing calculator] for a [TYPE OF BUSINESS, e.g. bookkeeping practice]. If something depends on an assumption you can't see, ask me instead of guessing.
Have Claude audit a spreadsheet you rely on, like your budget or pricing calculator, without changing a thing. It explains every formula, flags errors and plans a cleaner version.
Step by step
- Open a copy of a spreadsheet you actually use.
- Use the Claude in Excel add-in, or upload the file to a Claude chat.
- Run the audit prompt and pick the 3 or 4 fixes that matter.
- Ask Claude to write a step-by-step plan for a rebuilt version.
What you'll get
A plain-English audit of your spreadsheet: how it works, what each formula does, ranked errors, layout issues, and a rebuild plan.
- Made for
- Consultants, Small business owners, Coaches
- Works in
- Claude
