Fix the spreadsheet without leaving it

Clean, update, and explain spreadsheets in plain English.

Iris

— 2 min read
Share

You can now clean up a messy spreadsheet, fix a broken formula, or build a basic tracker without bouncing into a separate chat window. OpenAI's ChatGPT for Excel and Google Sheets now works in a sidebar inside the sheet, so you can ask for changes in plain English and review them before you keep going.

The easiest first win is not a giant model. It is taking one ugly sheet that already exists and getting it into usable shape faster.

What changed

OpenAI says ChatGPT for Excel and Google Sheets is now available globally. It lives inside a sidebar in Excel or Google Sheets and can build, update, explain, and summarize spreadsheets, including multi-tab files.

The official help page was updated in the last day, and OpenAI's release notes position it as a spreadsheet-native workflow for budgets, trackers, planning sheets, cleanup work, and scenario comparisons.

Why this is useful

Most spreadsheet pain is not advanced analysis. It is fixing labels, tracing one bad formula, updating assumptions, or turning rough data into something other people can read.

That is where plain-English prompts help. You can ask for a cleanup, a summary, or an explanation in the file itself instead of trying to translate your problem into formula language first.

A good first use

Try it on a sheet you already touch once a week: a budget, task tracker, content calendar, or exported report.

Ask it to explain the sheet before it edits anything. Then give it one cleanup job, not five. That keeps the changes small enough to check.

How to use it

  1. Open an existing spreadsheet that feels messy but is not your most sensitive file.
  2. Start with a read-first prompt: "Explain what this sheet is doing, flag anything confusing, and do not change anything yet."
  3. Then give one clear edit request, like: "Standardize labels, remove duplicates, and keep the current formatting."
  4. If you need bigger edits, ask for a plan first: "Tell me which tabs and ranges you would change before you edit them."
  5. Review the changed cells, formulas, and totals before you share or rely on the result.
  6. For important work, duplicate the file first so you can roll back fast.

What to do today

  1. Pick one spreadsheet that slows you down every week.
  2. Use this cleanup prompt: "Clean up this sheet: standardize formatting, fix inconsistent labels, and remove duplicates. Summarize exactly what you changed."
  3. If a formula is broken, try this instead: "Why am I getting an error in cell B145? Explain the formula chain and propose a fix."
  4. If you do not have the feature yet, save those prompts for the next time you install the Excel or Google Sheets add-in.

Iris

Read more