Skip to main content
MyDataFixer

Spreadsheet Cleaner

Remove duplicates and empty rows, trim spaces, fix capitalization, dates, phone layouts and numbers stored as text, edit any cell, preview every change, undo mistakes and download a clean copy.

Open a file to see what can be cleaned. Every change is shown before it is applied and can be undone. Everything happens on your device, and your original file is never changed: you download a cleaned copy.

Your file is read by your browser on this device. It is not uploaded to our servers.

How the Spreadsheet Cleaner works

  1. Open an Excel workbook (.xlsx or .xls) or a CSV file. It is read on your device.
  2. The cleaning tools list shows what each tool would fix in your sheet: extra spaces, duplicate rows, empty rows, empty columns, numbers stored as text, capitalization, date formats and phone number layouts.
  3. Tap a tool to see a preview of every change. Tools that need a decision (a date format, a phone layout, a spelling) ask for it in the preview.
  4. Tap any cell in the table to edit it by hand, for values no tool can fix, such as a wrong email address.
  5. Undo or redo any change, see the full history, and download a clean copy as CSV or Excel. The file is checked before it is offered.

Example

An exported sales sheet has amounts written as “1,250” and “'45” (numbers stored as text), so totals don't add up. “Convert numbers stored as text” shows each value before and after. Values that could mean two things, such as “1,250” in a column that also uses decimal commas, are left for you and listed with the reason. After applying it, the totals work, and the downloaded Excel file keeps the original formatting.

What the Cleaner never does

  • Upload your file or change the original.
  • Apply a change you haven't seen: every tool shows a preview first.
  • Change formula cells automatically, or remove rows and columns that formulas, charts or named ranges elsewhere in the workbook refer to.
  • Convert values that could mean two different things.

Good to know

  • Changes are kept only in the open browser tab until you download them. MyDataFixer asks before you leave the page with changes that haven't been downloaded.
  • Excel workbooks are cleaned one sheet at a time.
  • Very large files need a computer or a recent phone with enough memory.

Questions and answers

Is my file uploaded?

No. Your browser opens the file on your device and every check, fix and download happens there. The contents of your file are not sent to MyDataFixer's servers or to anyone else, and your original file is never changed.

What's the difference between the Cleaner and the Error Detector?

They use the same checks and fixes. The Error Detector starts from the list of problems found; the Cleaner starts from the cleaning tools, so you can go tool by tool.

Can I edit cells myself?

Yes. Tap a cell in the table (or move to it with the arrow keys and press Enter) to open the editor. Column names can be renamed with the pencil next to each name. If a cell holds a formula, MyDataFixer warns you first, because saving a value replaces the formula.

Which spelling is kept when capitalization differs?

The most common one in that column. When two spellings are equally common, MyDataFixer asks which to use.

Will removing duplicates keep the first row?

Yes. The first copy is kept and each removed row is listed as “Exact copy of row N”.

Can I download as Excel?

Yes, for Excel workbooks: only the changed cells are rewritten inside your original workbook. CSV files are downloaded as CSV.

Related tools