Skip to content
Get a free demo
Free tool · no upload, no sign-up

Clean a messy spreadsheet without uploading it

Your file stays in your browser. Nothing is sent to us or to anyone else.

Drop a CSV, TSV or Excel file here

.xlsx, .csv and .tsv, up to 100 MB

  • Never uploaded. The file is read on this device.
  • Your original isn’t touched. You download a cleaned copy.
  • Every change is listed. Anything doubtful is flagged, not changed.

What it cleans

  • Stray spaces at the start or end of a cell, double spaces inside one, and invisible characters copied from web pages.
  • Fully blank rows and fully blank columns.
  • Title rows sitting above the real headings. The cleaner finds the heading row and lists each row it took away, word for word.
  • Heading rows repeated halfway down, as page-by-page exports tend to do.
  • Exact duplicate rows, keeping the first copy. If two identical rows are genuine, as two equal payments on one day can be, untick the box and they stay.

What it refuses to guess

A cleaner that guesses wrong does more harm than a messy file, so these are reported and left as they are:

  • Dates such as 03/04/2025, which could be March 4 or April 3. If the same column holds 03/14/2025, the report says month/day is likely, but the cells stay as written.
  • Near-duplicates, such as two rows that differ by one letter in a name.
  • One value spelled several ways, such as NY, ny and N.Y.
  • Numbers Excel has already damaged, such as a phone number showing as 1.23457E+11, and ZIP codes that have lost a leading zero.
  • Placeholder text such as n/a or unknown, total rows, Excel errors such as #REF!, and columns with no heading.

Leading zeros and long ID numbers are kept exactly as written, and nothing is converted to scientific notation.

How to check that your file stays put

You don’t have to take our word for it. Load this page, turn off your Wi-Fi, and clean a file. It works, because nothing here needs the internet once the page has loaded.

Or open your browser’s developer tools at the Network tab and watch while a file is processed: no request appears. The page also carries a Content Security Policy that tells your browser to refuse any connection this page tries to make, and it loads no analytics or trackers. Our automated tests record every request during a clean and fail if one appears.

Our server sees what any website sees: that someone opened this page. See our Privacy Policy.

What you get back, and its limits

You choose an Excel file or a CSV. The Excel copy stores text as text, so leading zeros survive opening it, and it freezes the heading row. In the CSV, a cell that starts like a formula gets an apostrophe in front so a spreadsheet won’t run it; plain negative numbers and phone numbers are left alone.

It cleans one file at a time and saves nothing: there is no account, no history and no scheduled cleaning, and when you close the page the work is gone, so download your copy first.

From an Excel file it reads one sheet at a time, and you can switch sheets. Formulas become their last calculated value, and colours, fonts and charts aren’t carried over, so keep your original. Password-protected files and the older .xls format need saving as a plain .xlsx first, and the page tells you when that’s the case.

Questions

Questions about the file cleaner

Is my file really not uploaded?

Really. The cleaning runs in your browser on your own device, and the page is set up so that the browser refuses any connection it tries to make. You can turn off your Wi-Fi after the page loads and it still works.

Will it change my numbers or dates?

It won’t reinterpret them. Leading zeros stay, long numbers stay whole, and a date such as 03/04/2025 is flagged, never guessed at. The exception is a true date stored by Excel, which is written as 2025-03-04, since the file says exactly which day it is. The report lists that as a change.

Why did some cells get an apostrophe in the CSV?

A spreadsheet runs any cell that starts with = + - or @ as a formula, which is a known way to attack someone with a file. The CSV puts an apostrophe in front of such a cell so it shows as plain text. Plain negative numbers and phone numbers are left as they are, and the Excel download doesn’t need this at all.

What does it cost, and do I need an account?

It is free and has no accounts. It cleans one file at a time and saves nothing between visits, so download your copy before you close the page.

Can I use it on a phone?

Yes. It works in current phone browsers, though very large files are better handled on a computer, which has more memory.

Does a spreadsheet run part of your business?

We build new apps from scratch around how your business works, on phone, tablet and computer. See a first version at no cost.

Get a free demo