CSV Cleaner

Dedupe, trim, drop empty rows and columns — quotes handled correctly.

A free CSV cleaner: it detects the delimiter (comma, semicolon, tab or pipe), then removes duplicate rows, trims whitespace and drops empty rows and all-empty columns — telling you exactly how much of each it removed. The parser follows the CSV rules for quotes, so commas and newlines inside quotes never break a field — which is precisely where most online tools get it wrong.

How to use

1. Paste your CSV into the text box.
2. Tick the cleanups you want — the preview updates live.
3. Copy the result as either CSV or JSON.

FAQ

My fields contain commas and newlines — will they break?

No. As long as they are quoted per the spec (`"a,b"`, `"line1 line2"`), the parser keeps the whole thing as one field, and a doubled quote `""` becomes a single literal quote. Quoting is re-applied correctly when writing back out.

Can it handle large files, and is anything uploaded?

Everything runs in your browser and nothing is uploaded. Because it works in memory, very large files (tens of MB and up) are limited by your device’s memory — split them first.

Related tools

• Phone Parser — Parse any phone number: region, line type and four standard formats.
• IBAN & Card Check — IBAN mod-97 and card Luhn validation, with country and brand detection.
• Request Echo — See what the server actually received: every header, the real IP, the proxy chain.
• HTTP Testbed — Return any status, delay, redirect or payload size to exercise client retry and timeout logic.
• Webhook Box — Generate a temporary URL to capture third-party callbacks and inspect headers and body in full.
• Base58 · TRON Address — Convert & validate TRON (T…), hex (41…) and EVM (0x…) addresses; plus generic Base58.