ChatGPT for Excel: Formulas, Cleanup and Error Fixes · Module 2 of 3

ChatGPT: Clean Up a Messy Spreadsheet Export Without Guessing

ChatGPTBeginner~9 min practice19 steps
Start the practice →Straight to step 1, right here. Free, and nothing touches your real accounts.

Why this matters

Every export is a little broken: names in capitals, three date formats, the same person twice, a phone number with two digits missing. Use it as it is and the mail merge greets people as "MARIA" and the headcount is three too high.

ChatGPT cleans a file like this in under a minute. The risk is that it also quietly fixes things it cannot know, such as a missing email. Two habits prevent that: make it list the problems before it changes anything, and give it a Needs review column for whatever it would otherwise guess.

Practice

Do every step yourself in a practice copy of the real tool. It checks your work, and “Do it for me” finishes any step you get stuck on.

ChatGPTChatGPT: Clean Up a Messy Spreadsheet Export Without Guessing19 steps · ~9 min · nothing touches your real accounts

What you’ll build

You run workshop sign-ups at a college continuing-education office (made up). You attach a 16-row export, get every problem listed with its Reg ID, and then have it cleaned by your rules.

The result in the real run: 13 rows kept, 3 duplicates removed and listed, 4 rows flagged for review with the broken field left blank, and a headcount per workshop of 5, 4 and 4.

What you need

  • Nothing to start the practiceThe lesson is a practice copy of ChatGPT. The college and the registrants are made up.
  • A ChatGPT account, to do it for realA plan that can attach a file and return one. The answers shown came from a Plus account.
  • Your rulesHow names, emails, phones, dates and yes/no values should look, and which row to keep when two match.

Concepts

Diagnose first, change nothing

The first request ends with "Don't fix anything yet." You get a list you can read in a minute: three duplicate pairs, a blank email, an email with no ending, four date formats, a phone number that stops short, and a Paid column holding Y, yes, PAID and $75.

That list is also your check on the cleanup. If the second answer does not account for each item, something was skipped or guessed.

Rules, and a place for what it cannot know

The second request gives the target format for each column and one rule for duplicates: keep the earliest row and list the one removed. Then the line that matters most: "Do not guess anything that is missing or broken: leave it blank and put the reason in a new column called Needs review."

In the real run that produced four flagged rows: a missing email and a $75 where Yes or No belonged, an email with no ending, a blank payment status and an incomplete phone number.

Open the file before you trust it

The answer describes the cleaned file. It is not the file. Open it and look at the four flagged rows, the three removed duplicates, and Reg ID 1015, whose date was written day-first (13/10/2026) when every other row was month-first.

It also pointed out something nobody asked about: every address ends in example.com, a domain reserved for examples. On a real list, that kind of remark is worth reading.

Do it for real

Now repeat it in your own account. Tick each step as you go.

Downloads

Quick check

3 questions to check you’ve got it.

1. Why ask for a list of problems before any cleaning?

  • ChatGPT cannot clean without it
  • You see what is wrong and can check the cleanup against it
  • It makes the file smaller
Show the answer

You see what is wrong and can check the cleanup against it. The list is your checklist. Every item should show up in the change log or the Needs review column.

2. A row has no email address. What should the cleaned file show?

  • A likely address built from the name
  • The row deleted
  • A blank, with the reason in Needs review
Show the answer

A blank, with the reason in Needs review. A guessed address is worse than a blank one: it looks finished and sends mail to the wrong person or nowhere.

3. ChatGPT says the file is clean. What do you do next?

  • Open it and check the flagged rows, the removed duplicates and any odd dates
  • Send the mail merge
  • Ask it to confirm it is sure
Show the answer

Open it and check the flagged rows, the removed duplicates and any odd dates. The answer describes the file. Only opening it shows what is in it.

Up next · Module 3

ChatGPT: Fix #N/A, #VALUE!, #DIV/0! and #REF! Errors in Excel

Clean data, working formulas. Next, the workbook someone else built, with five errors and invoices due Friday.

Start module 3 →