Prompt Library for Small Businessby Small Business Control Center · free
Admin, taxes and legalReview or audit something Low riskAbout 8 minutes

Understand a spreadsheet someone else built

Have AI explain what each tab and formula in an inherited Excel or Google Sheets file does, and what might be wrong.

Useful for: most businesses (8 of 8 types).

  1. 1Copy the prompt
  2. 2Replace what’s in [brackets] with your details
  3. 3Paste it into ChatGPT, Claude, Gemini or Copilot

The prompt

Act as a spreadsheet expert who explains things to someone non-technical. Write in English. My business is in [COUNTRY, e.g. the US, the UK or Australia]: if something depends on the rules there and you’re not sure, tell me. I use a spreadsheet someone else built and I don’t really know what it does or whether it’s right. Details: - What it’s used for: [USE, e.g. prices, stock, rotas, collections] - Tabs and columns, with their names: [STRUCTURE] - The formulas I don’t understand, copied exactly: [FORMULAS] - What result looks odd to me: [SUSPICIONS] Give me: 1) what the sheet does, in 5 lines; 2) what each formula does, in plain words and with a worked example; 3) what might fail (ranges that don’t reach new rows, values typed over a formula, references to another tab) and how to check; 4) how to color-code what gets filled in and what must not be touched; 5) a half-page instruction sheet for whoever uses it next. Don’t make up what I haven’t shown you: if you need to see another part, tell me which. If information is missing, ask me.
Fill in the gaps on this page
Example of what to write: COUNTRY: Canada | USE: calculating the selling price of each product | STRUCTURE: Costs and Prices tabs | FORMULAS: =VLOOKUP(A2,Costs!A:D,4,FALSE)*(1+$H$1) | SUSPICIONS: new products come out at 0.

Did it work for you?

One click is enough. Your answer tells us which prompts need work, and it helps the next person who uses it.

Reviewed with: Claude (Nov 2026). Last updated: 2026-11-18. AI answers can contain mistakes. Check what matters.

More like this

Recommended tools

Tools we recommend for your business

We picked them because they suit small businesses. Some links are affiliate links: if you sign up through them we get a commission, at no extra cost to you. How we choose them and all the tools.

Affiliate linkEmail and teamworkGoogle Workspace

Email on your own domain, shared documents, calendar and video calls.

Works with Small Business Control Center: the workbook runs in Google Sheets, which comes with Google Workspace.

What’s new

New and reviewed prompts every week

See more updates →

Help us improve the library

What would you like AI to take off your plate?

Tell us the task that eats up your week. We read every request and the most repeated ones become new prompts.

We’ll only use them to reply about this request. No newsletter unless you ask for it.

Free newsletter · 1 email a week

Get practical tools to run your business better

A selection of prompts, guides and tips to put AI to work and improve how you run your business. We only ask for your email; unsubscribe whenever you like.