Clean up a messy spreadsheet without starting over

If a spreadsheet is mostly right but still full of duplicate rows, bad labels, or confusing formulas, you can now fix more of it from inside Excel or Google Sheets with plain English. ChatGPT has a new sidebar that works in the file itself.

The best first use is a sheet you already inherited or half-finished. Ask it to clean one tab, explain the trouble spots, and list what it changed before you share it.

What changed

OpenAI says ChatGPT for Excel and Google Sheets is now available globally. It lives in a sidebar inside the spreadsheet and can build, update, explain, and clean up multi-tab files with natural language.

For beginners, cleanup is the clearest win. You stay in the sheet instead of bouncing between cells and a chatbot tab, and you can tell it exactly what to preserve, what to fix, and which tab to touch.

A good first use

Start with a spreadsheet that already has the right data but bad structure. Good examples are a budget with inconsistent category names, a contact list with duplicate rows, a tracker with broken formulas, or a report you did not build yourself.

Do not start with your most sensitive finance model. Make a copy of a routine sheet first, then test one cleanup task you can verify in a few minutes.

A prompt to copy

Try this inside the sidebar:

Clean up the Inputs tab only. Standardize category names, remove duplicate rows, keep my formatting, and tell me exactly what you changed. If any formula looks risky, explain it before editing.

If the sheet has multiple tabs, name the tab in the prompt. If the edit is important, ask for a plan first before you let it change anything.

How to use it

Install ChatGPT from the Microsoft Marketplace for Excel or the Google Workspace Marketplace for Google Sheets.
Open a spreadsheet you want to fix, then duplicate the file first if the work matters.
Open the ChatGPT sidebar and sign in with the ChatGPT account tied to your plan.
Name the tab or range you want it to work on, and say what must stay untouched.
Ask for a plan before editing if the sheet is large or messy.
Make one cleanup request at a time, then review the changed cells, formulas, and totals before moving on.
Save the prompt that worked so you can reuse it on the next spreadsheet.

What to do today

Pick one spreadsheet you have been avoiding.
Make a copy.
Ask ChatGPT to fix one problem only, such as duplicates, inconsistent labels, or a broken formula chain.
Compare the before and after version for five minutes.
If it saved time, keep that prompt in a note called spreadsheet cleanup.

Official links

Iris