Clean messy data

Data copied from forms, websites and old systems is a mess. Each column’s type is detected, cleaned, and every change is shown before you download.

Free · No sign-up · Your files are processed on your device and never uploaded

How to use Clean messy data

  1. CSVmessy.csv
    1

    Choose your file

    Drop it on the page or pick it from your phone or computer.

  2. Clean each column
    2

    Press "Clean each column"

    Pick the options you want - the defaults suit most files.

  3. XLSXmessy-clean.xlsx
    3

    Download the result

    Ready in seconds. Your file never left your device.

Features

  • Detects names, emails, phones, dates and money columns (you can change each).
  • Dates: day-first or month-first detected, written as 2026-03-14, 14/03/2026, 03/14/2026 or real Excel dates.
  • Phones with your country code; names to Title Case; optional first/last name split.
  • Money like $4,500.00, (500) or 1.234,56 becomes a real number.
  • Before/after preview with changed cells highlighted.

How to use it

Choose a file or paste a table copied from Excel, Sheets or a web page.

Check the type chosen for each column in the header row.

Download as .xlsx or .csv.

Free and private

Everything happens inside your browser: your files are read on your own device and are never uploaded, stored or seen by anyone else.

Questions

How are 03/04/2026 dates handled?

If any date in the column has a first number over 12, the column is read day-first; otherwise you can choose.

Is my data uploaded?

No, it is cleaned in your browser.

Is it free?

Yes - free and unlimited, with no sign-up and no watermark.

More smart tools

All tools →