ChatGPT Prompts for Excel

Two lists that should match but don't. Paste them — get what's in one but not the other, the duplicates, and the near-matches you'd miss by eye.

Drowning in rows and need a summary? Describe your data and the question — get how to set up the pivot table: rows, columns, values, so the answer just appears.

Describe what you need the cell to do. Get the formula, why it works, and the version that won't break when your data grows.

Want a budget that isn't a spreadsheet you abandon in a week? Tell it your income and life — get a simple system and the layout to track it without the misery.

Big decision with numbers behind it? Describe it — get a spreadsheet model you can build: the inputs, the formulas, and how to flex assumptions to see what happens.

Got data in the wrong shape? Paste it and say what you need — CSV, JSON, SQL, a table — get it converted cleanly, with the structure handled right.

Paste the spreadsheet nightmare — mixed formats, junk rows, weird dates. Get a clean version and the exact steps to do it yourself next time.