Tools › Clean Excel Data
Clean Excel Data Online — Free Data Cleaning Tool
Spaces trimmed, empty rows removed, names, emails, phones, dates and numbers made consistent — with a report of every change. Free — no sign-up.
Free tools powered by Toolsitz — more free tools for files, PDFs and images.
How to use it
- Choose your Excel or CSV file.
- Tick what to fix: spaces, empty rows, name case, emails, phone numbers, dates, numbers.
- Press Run. You get the cleaned file plus a report of every change.
Nothing is changed silently — the change report lists each cell with its old and new value, and anything that could not be fixed is flagged instead of guessed.
What you get
- Clean XLSX (and CSV)
- Change report: sheet, cell, before, after, rule
- Flagged rows sheet (invalid emails, unparseable dates)
Good to know
- Does not decide business meaning — a column named 'Notes' is left alone
- Up to 20 MB per file, 10 files at a time.
- Files are deleted from our server within an hour.
Do it yourself in Excel
Questions
Which date format should I pick?
YYYY-MM-DD sorts correctly everywhere. Pick DD/MM/YYYY if the file is for people in India or the UK.
Will it change my original file?
No. You download a new cleaned copy.
