tools · csv cleaner

Clean. Normalize. Dedupe.

Fix messy exports without touching a spreadsheet.

Drop your CSV here

we'll clean it locally

What the cleaner fixes

Trim whitespace
Removes extra spaces, tabs, and line breaks inside cells and around values. Prevents ' $50 ' from breaking numeric imports.
Normalize dates
Converts scattered formats like 01/02/24, 2 Jan 2024, and 2024-01-02 into a consistent ISO YYYY-MM-DD format.
Normalize amounts
Strips currency symbols, fixes misplaced negative signs, and converts parentheses into signed decimals (e.g. ($50) → -50).
Drop empty rows
Removes rows where every cell is blank — a common artifact when exporting from spreadsheet software.
Remove duplicates
Compares the full row across all columns. If every value matches another row exactly, the duplicate is removed.
Preserve structure
All cleaning is non-destructive to column order and header names. You preview before downloading.

Privacy-first by design

Your CSV data is processed entirely in your browser. Nothing is sent to our servers. No signup, no tracking, no data retention.

No upload No storage No login required

Frequently asked questions

Will this delete data I need?
Only empty rows and exact duplicates are removed. Every other cell is preserved, just cleaned. You can toggle each option on or off before downloading.
What date formats are supported?
Most common regional formats: DD/MM/YYYY, MM/DD/YYYY, YYYY-MM-DD, and textual dates like 'Jan 15, 2024'. All are normalized to ISO YYYY-MM-DD.
Can I undo the cleaning?
The original file is never modified. Just reload the page and re-upload your original CSV to start over.
Does it work with large files?
Yes — processing happens locally in your browser, so the limit is your device's RAM, not a server quota.

Related tools