DataMadeClean

Messy files. Clearer possibilities.

Clean data
for real work.

An online data cleaning tool for CSV and Excel files. Standardise inconsistent formats, see every change, and review uncertain values yourself.

Free up to 500 rowsNo account or card required

  • Works in your browserCSV, Excel & delimited text
  • Your files stay yoursTemporary storage for anonymous uploads
DataMadeCleanRegion: United States
sample_customer_data.csv7 shown · 6 retained
Changes at a glance
NameEmailPhone
Before: JOHN SMITH After: John Smithjohn.smith@example.comBefore: +1 415 555 0128After: (415) 555-0128
Before: sarah o'connorAfter: Sarah O'ConnorBefore: SARAH.OCONNOR@EXAMPLE.COMAfter: sarah.oconnor@example.comBefore: 2125550199After: (212) 555-0199
Before: Priya NairAfter: Priya Nairpriya.nair@example.com(312) 555-0144
Michael ChenEmail needs reviewmichael.chen@exampleNeeds review · unchanged(512) 555-0182
Before: EMILY WILSONAfter: Emily Wilsonemily.wilson@example.comBefore: 1-206-555-0166After: (206) 555-0166
Grace Hallgrace.hall@example.com(615) 555-0130
Grace HallDuplicate removedgrace.hall@example.com6155550130
Clear fixes. Every change listed.Review
What we clean
  • Names
  • Emails
  • Phone numbers
  • Dates
  • Numbers
  • Boolean values
  • Text & whitespace
  • Categories
  • Addresses & localities
  • Duplicate checks
  • Missing values
  • Column splitting
  • Consistency checks
  • Outlier checks

Review every change.
You stay in control.

The original value, the result, and the rows affected. Clear fixes are recorded - ambiguous findings are flagged for your review.

Changes & review findingsExamples from the sample
  • Exact duplicate removedGrace Hall → one identical record retained1 row
  • Phone format standardised+1 415 555 0128 → (415) 555-01281 shown
  • Invalid email flaggedmichael.chen@exampleUnchanged — needs your reviewReview
  • Extra spaces removedPriya  Nair → Priya Nair1 shown

And more: Missing values Category casing Data imputation Text repair Address format checks

Save time with
reusable recipes.

Save your cleaning settings, then reuse them whenever a similar file comes along.

Example saved recipes

  • Customer Importcustomer_data.csv · saved settings Run
  • Monthly Reportssales_export.csv · saved settings Run
  • Event Registrationsevent_signups.csv · saved settings Run

More control over your data cleaning.

Review what changed and why. Recover missing values where the data supports it, then format and split columns for easier analysis.

REVIEW

Review with confidence

See what was changed, what was only flagged, and why — then keep a record of how the recipe itself has evolved.

Applied automatically 9

Flagged for your call 3

  • Every change grouped by type, with the rows it touched
  • Issues separated by severity rather than buried in a list

DATA IMPUTATION

Fill the gaps
the data can explain.

Recover missing values from confirmed relationships between columns, or consistent values within a group. When the answer is ambiguous, the gap stays for review.

Confirmed relationship: Quantity × Unit price = Total

Illustrative rows after the relationship has been confirmed
QuantityUnit priceTotal
212.0024.00
512.0060.00
312.00Missing → 36.00
  • Use confirmed arithmetic relationships
  • Fill from groups only when known values agree

COLUMN SETTINGS + SPLITTING

Make the columns
work your way.

Make analysis and grouping easier with consistent formats and separate columns. Split dates into day, month and year to group results by period, separate dates from times, or extract email domains to analyse customers by organisation.

Preview of a column split
Order dateDayMonthYear
12/31/202531122025
01/15/202615012026

The original date stays. Three extra columns are added.

  • Set date and phone formats for individual columns
  • Choose which columns to split

See what a
clean looks like.

A customer file with inconsistent formats, duplicate rows and values that need a closer look. Choose your options, then see what changes—and what stays yours to decide.

Try the sample clean

No account needed · Paid cleaning options included for the sample

Sample customer dataReady to explore
CustomerEmailSignup date
  1. Choose your options

    Start with a sample already loaded. Add optional columns if you need them.

  2. Run a real clean

    Use the same cleaning tools available for your own files.

  3. Review what changed

    Explore the fixes, review uncertain values and download the results.

Simple, transparent pricing

Plans for every stage.

Start free, pay once for a larger file, or subscribe when cleaning becomes a routine.

Free

For trying DataMadeClean on smaller files.

$0 / forever

  • Up to 500 rows per file, files up to 5 MB
  • No account required
  • Free-tier cleaning rules, every change listed
  • See what a paid clean would find
  • Temporary results. Download a copy to keep
Clean a file free

Pro+

For recurring files and repeat workflows.

$29 / month

  • Everything in Pro, without the per-file cost
  • Unlimited rows, files up to 50 MB
  • Saved recipes and matching file layouts
  • Saved date and phone format preferences
  • Optional date, time and email-domain column splits
  • Restore earlier saved recipe versions
  • Import from Google Sheets and export a new Sheet
  • Keep results as long as you want
Get Pro+

Pricing is shown in US dollars based on your location. Checkout uses the same regional currency.

Before you upload

A few useful answers.

Try the sample file to explore cleaning options, run a clean and review the changes before uploading your own.

What file types can I clean?

Upload CSV, Excel, TSV or delimited text files. The free tier supports up to 500 rows per file, with a 5 MB file limit.

What changes automatically?

Clear fixes, such as standardising formats, are applied and recorded in the change log. Ambiguous findings are flagged for your review, so you can decide what to do with uncertain values.

Will this overwrite my spreadsheet?

No. Uploading a file does not change the copy on your computer. Download the cleaned result separately, along with a record of the changes, and keep your original for comparison.

How is my uploaded data handled?

Files are encrypted in transit and stored on an encrypted volume. Anonymous uploads and results become eligible for deletion after a one-hour retention period, which changes made during review can extend. Cleanup runs when a new file is uploaded, so files can remain stored longer. With an account, you choose how long results are kept. Read the privacy policy.

Start with a file.
See every change.

Less time fixing spreadsheets. More time using them.

Clean a file free

Not sure whether your file is suitable?
Get in touch