Clean up messy data in an Excel file online

Numbers stored as text are why a SUM comes back as zero and a filter on "over 500" matches nothing. Describe the cleanup and the comparison works on the result, in the same run.

The instruction to paste

Example instruction

In the Raw Amount column the numbers are stored as text with spaces. Turn them into numbers and keep the rows where the result is at least 500. Trim the spaces around Region, put it in upper case, and put Status in lower case

What comes back

Before

Region	Raw Amount	Status
EMEA	1 200	Paid
apac	340	cancelled
EMEA	890	OVERDUE
amer	1 500	paid

After

Region	Raw Amount	Status
EMEA	1200	paid
EMEA	890	overdue
AMER	1500	paid

How it works

01
Upload the file — .xlsx, .xls or .csv, up to 100 MB.
02
Paste the instruction, changing the column names to the ones in your own file.
03
Download the result. Whatever was cut comes back on a separate tab, so nothing is lost.

Other ways to ask

The instruction is read as a sentence, not filled into a form. These all work on the same file.

Trim the spaces in every text column and replace empty cells with a dash
Turn the Date column from text into real dates and sort by it, oldest first

The rows and values in your file are never sent to an AI model — only the column headers and your instruction ever leave our servers.

Questions

Why does my filter on a number column match nothing?

Almost always because the values are text, not numbers — often from an export that used spaces as thousands separators. Ask for the column to be converted and the comparison starts working.

Can it fix the case without touching anything else?

Yes. Cleaning a column and filtering on it are separate requests; you can ask for either on its own.

Will it change values I did not mention?

No. Only the columns you name are touched.

Related tasks

See everything you can ask for

Try it on your own file

Create an account, upload your spreadsheet and paste the instruction above.

Start free