Online Data Cleaner — CSV · Excel · JSON
Clean messy CSV tables, Excel spreadsheets and nested JSON arrays without writing scripts or uploading your files. Chain visual cleaning steps, preview modified cells immediately, and export reusable Pipeline JSON recipes.
Included in the free local workbench
- Text & whitespace cleanup: trim spaces, collapse whitespace/newlines, strip zero-width and invisible control characters, full-width to half-width conversion, case transforms, and find & replace.
-
Missing values & Fill Down: drop empty rows, replace placeholder nulls (
N/A,null,-), fill down gaps left by merged Excel cells, and filter rows by condition. - Deduplication & columns: exact row or key-column deduplication (keep first or last), drop/keep/rename/reorder columns, split and merge columns.
- JSON flattening & number cleanup: flatten nested JSON objects into tabular columns, strip currency symbols and thousands separators, and switch between Excel worksheets.
- Before/after diff in FindChanged.com: after cleaning completes, send both the original and cleaned datasets straight to FindChanged.com via browser handoff to inspect every change side by side.
Free limits and upcoming Pro / API capabilities
The free workbench runs 100% locally in your browser for up to 5,000 rows and 8 pipeline steps, with full Pipeline JSON recipe import/export.
Upcoming Pro & Cloud API plans will unlock statistical outlier detection (Z-score / IQR / MAD), automatic column type profiling and type-mismatch quarantine, fuzzy deduplication, multi-format date normalization, PII masking, and large-file programmatic API execution.