How to use
Paste CSV data (or load a local file), choose an action, then run.
- Paste CSV into the input (or use Load file).
- Select Delimiter (Auto works for most CSV/TSV).
- Pick an Action (Clean, Validate, Dedupe, Sort, Keep columns).
- Click Run and copy or download the output.
FAQ
Is this free CSV tool really client-side (no upload)?
Yes. Your CSV stays in your browser; the tool doesn’t send data to a server.
Can it handle quoted values like "New York, NY"?
Yes. It supports standard CSV quoting with double quotes and escaped quotes ("").
What delimiters are supported?
Comma, tab (TSV), semicolon, and pipe. Auto-detect picks the best match for common files.
How do I sort or keep columns by index?
Use 1-based indexes (1 = first column). Example: keep 1,3,5 or sort by 2.
Why does Validate fail on my file?
Usually because some rows have a different number of columns (often caused by missing quotes around delimiters inside values).
Will dedupe remove the header row?
No. If “Has header row” is enabled, the header is kept and only data rows are deduped.
Can I download the cleaned output?
Yes. Click Download to save the current output as output.csv.