CSV Cleaner
Clean CSV rows in your browser. Quoted commas survive the split, cells are trimmed, blank rows go and repeats collapse; nothing is uploaded.
What this csv cleaner does
The split is quote-aware: a comma inside a quoted field stays data, and a doubled quote stays one quote, so a cleaned file still parses as the same table. An unbalanced quote is refused with its line number rather than merged into the next row, and a delimiter must be exactly one character.
How to use it
CSV Cleaner: paste the CSV into the box above, set Delimiter (one character), default ",", Whitespace inside cells (default "yes"), Rows whose cells are all blank (default "remove") and Repeated lines (default "no"), and press Run to get the Cleaned CSV below.
Worked example
Input:
name, age
Alice , 30
,
"x, y",1
Output:
name,age
Alice,30
"x, y",1
Why it runs in your browser
The conversion happens on this page with JavaScript. Your input is not posted to a server, so it works offline after the page loads and nothing is retained anywhere. The page reads CSV and returns Cleaned CSV; reloading the page discards both.
The split is quote-aware: a comma inside a quoted field stays data, and a doubled quote stays one quote, so a cleaned file still parses as the same table. An unbalanced quote is refused with its line number rather than merged into the next row, and a delimiter must be exactly one character.
Clean CSV rows in your browser. Quoted commas survive the split, cells are trimmed, blank rows go and repeats collapse; nothing is uploaded.
How to use it
CSV Cleaner: paste the CSV into the box above, set Delimiter (one character), default ",", Whitespace inside cells (default "yes"), Rows whose cells are all blank (default "remove") and Repeated lines (default "no"), and press Run to get the Cleaned CSV below.
Why it runs in your browser
The conversion happens on this page with JavaScript. Your input is not posted to a server, so it works offline after the page loads and nothing is retained anywhere. The page reads CSV and returns Cleaned CSV; reloading the page discards both.
What to Expect
Best for
- Converting CSV to Cleaned CSV when the data is already on screen.
What this tool keeps
- Your input is not posted to a server, so it works offline after the page loads and nothing is retained anywhere.
Sample input
name, age Alice , 30 , "x, y",1
Sample output
name,age Alice,30 "x, y",1
Frequently asked questions
How do I use the csv cleaner?
CSV Cleaner: paste the CSV into the box above, set Delimiter (one character), default ",", Whitespace inside cells (default "yes"), Rows whose cells are all blank (default "remove") and Repeated lines (default "no"), and press Run to get the Cleaned CSV below.
Is my input uploaded?
No. The text is parsed on this page with JavaScript and is never posted to a server.
Is there a size limit?
Yes: 5 MB per run. Larger input is refused with a message rather than freezing the tab.
Build custom tools for your store
Join the SDK program to create useful ecommerce utilities for your store.