← All tools

CSV Data Cleaner — Power Query Edition

PapaParse-powered Power Query editor: type detection, 1-click auto-clean, applied steps with undo, data quality panel, number/date conversion. English + Arabic UI. 100% local.

UI language / لغة الواجهة:

Drop a CSV file here or click to browse

.csv only · optional header row · runs 100% in your browser

Similar Tools

JSON / CSV Converter

Convert between JSON and CSV with a tree viewer.

Dummy Data Generator

Generate fake users as JSON, CSV or SQL INSERTs.

Smart Text Analyzer

Count words, chars & case.

What is the CSV Data Cleaner “Power Query Edition”?

It brings a spreadsheet-style workflow to messy CSV files. The header row is never treated as data: every column is scanned for its type (Number, Date or Text) using only real rows. The Data Quality panel reports exact empties and unique values per column, while the Applied Steps panel records every operation you perform so you can undo the last three in sequence.

How to use the CSV Data Cleaner?

  1. Drop a .csv file into the upload area (or click to browse). Use the “Use First Row as Headers” toggle as needed.
  2. Review the Data Quality panel (computed in a Web Worker) for exact empty/valid percentages and unique value counts.
  3. Click 1-Click Auto-Clean, or open a column’s Clean menu for Trim, Capitalize, Convert to Number or Convert to YYYY-MM-DD.
  4. Check the Applied Steps panel; press Undo (last 3) to reverse operations in sequence or Clear History to start fresh.
  5. Download the cleaned CSV and inspect the Change Report for exact counts, including conversion errors.

Frequently Asked Questions (FAQ)

Is the CSV Data Cleaner free?

Yes, completely free with no signup and no file uploads.

Are my files uploaded to a server?

No. Parsing runs with PapaParse and heavy analysis runs in a Blob Web Worker inside your browser. Nothing ever leaves your device.

How large a file can it clean?

Optimized for up to ~50,000 rows. Any processing above 5,000 rows runs in a Web Worker so the page never freezes.

Does auto-clean fix possible typos?

No. 1-Click Auto-Clean only removes completely empty rows and exact duplicates. Probable typos are labelled “Manual Review Required” so you decide what to do.