DataMimiDataMimi

Clean messy Excel data

Fix merged cells, headers buried in row 5, and numbers stored as text.

Want it to work exactly your way?

Keep this tool in your Mini-Apps to run it again in one click, or describe the job and AI builds an app of your own.

✦ Make your own app

How to use Clean a messy spreadsheet

  1. 1Select your file, or drop it on the page
  2. 2Run it — nothing to set up
  3. 3Download cleaned.xlsx

Your file is opened in an isolated sandbox with no internet access, processed and deleted with it. It is read the way people's spreadsheets really are — headers that are not on row 1, merged cells, totals pasted at the bottom, dates in two formats — and everything that is changed is listed back to you.

Questions

What counts as cleaning?

Finding the real header row, unmerging cells and filling the value down, removing totals rows pasted at the bottom, converting numbers stored as text, and parsing dates written in more than one format in the same column.

Will it change my numbers?

It converts them to real numbers, which means a column stored as text becomes something you can sum. Every change it makes is listed back to you, so you can check any of them against the original.

My thousands separator is a full stop. Does that break it?

No. The convention is worked out per column rather than assumed, so 13.500 in a column that uses full stops for thousands is read as 13500, not 13.5 — and the page tells you which convention it decided on.

Does it keep the original file?

The original is untouched; you get a cleaned copy. Nothing is stored on our side either way.

More Excel tools

See all