Free · Browser-local tools
Clean CSV data
Choose trimming, duplicate-key and empty-row cleanup. Review changes, apply with undo, or copy and download the complete CSV.
Clean CSV
Start with your CSV
Open your file in the CSV editor with this tool already selected. Preview the result before downloading.
- Open your CSV and choose cleanup operations.
- Inspect before/after values and changed-cell or removed-record counts.
- Copy, download or apply the result with undo.
Free · No signup · File contents stay in your browser. Back to page and Resume keep your edits in this tab. Download your edited copy before refreshing; refresh opens the original file. Open files up to 1 GiB with browser storage.
Try a small example
4 records · 3 columns| id | name | amount |
|---|---|---|
| 1 | Example one | 12 |
| 1 | Example one | 12 |
| 2 | Example two | 24 |
| (empty) | (empty) | (empty) |
After trim and exact duplicate removal
| id | name | amount |
|---|---|---|
| 1 | Example one | 12 |
| 2 | Example two | 24 |
| (empty) | (empty) | (empty) |
Illustrative fictional data. Open the sample to try the tool.
How to clean csv
- 1
Open your CSV and choose cleanup operations.
- 2
Inspect before/after values and changed-cell or removed-record counts.
- 3
Copy, download or apply the result with undo.
What to expect
Choose trimming, empty-row removal and duplicate removal independently. Scope trimming to selected columns and choose duplicate-key columns. The first matching record is retained; missing values are not inferred.
Local files and clear limits
These tools process file contents on your device. The browser workspace accepts files up to 1 GiB and 5 million records, subject to available browser storage and decoded-record limits. This tool's calculations support up to 100,000 records, 2 million cells and 64 MB of text. Download a new copy to keep your result.
Plain answers
Clean CSV questions
What can I do with this clean csv tool?+
Choose trimming, empty-row removal and duplicate removal independently. Scope trimming to selected columns and choose duplicate-key columns. The first matching record is retained; missing values are not inferred.
Does my CSV leave my device?+
File selection, editing and these task operations run in your browser. No account or file upload is required. Download a new copy to keep your result; refreshing restores the original input, not unsaved edits.
Do the editor and task have the same file limits?+
The editor opens files up to 1 GiB and 5 million records, subject to browser storage and decoded-record limits. This task supports up to 100,000 records, 2 million cells and 64 MB of decoded text.