Messy CSV in.
Clean CSV out.
Stray spaces show as · dots, so you can see what a trim will change.
Blank cells are counted per column. Fill a column’s blanks with a value you choose.
Duplicates are counted before you apply anything, and every step can be undone.
Private by default
One account · one cookie · no third-party scripts
Your file stays in your account. Only you can open it, and deleting it takes the original, every version and its history with it.
What it fixes
Six tools · one table · nothing to install- 01
Spot missing values
Counted per column, with a completeness meter. “N/A” stays data; only real blanks count.
- 02
Remove duplicate rows
Keeps the first occurrence, drops exact repeats.
- 03
Trim whitespace
Leading and trailing spaces, tabs and line breaks — often hiding duplicates.
- 04
Fill blanks
Give one column’s empty cells a value you choose, up to 100 characters.
- 05
Preview, then undo
See how many cells a fix will change before it lands. Undo or reset any time.
- 06
Export clean CSV
UTF-8 that Excel opens correctly. Formula-like cells are exported as text.
Try it on
eight rows
Toggle the fixes. Order matters — without a trim, “·Ben Okafor·” doesn’t match its duplicate.| Row | name | city | mrr | |
|---|---|---|---|---|
| 1 | Ana Souza | ana@northwind.io | Lisbon | 49 |
| 2 | Ben Okafor (extra spaces) | ben@okafor.dev | Lagos | 19 |
| 3 | Chloé Martin | chloe@martin.fr | blank | 49 |
| 4, duplicate | Ana Souza | ana@northwind.io | Lisbon | 49 |
| 5, Empty | blank | blank | blank | blank |
| 6 | Ben Okafor | ben@okafor.dev | Lagos | 19 |
| 7 | Dev Patel | dev@patel.co | blank | 29 |
| 8 | Eli Novak | eli@novak.cz | Prague (extra spaces) | 19 |
- 2 stray spaces
- 2 blank cells
- 1 empty row
- 1 duplicate
This demo runs in your browser with sample data. Your own files are cleaned the same way, in your private workspace.
Where your file goes
The round trip, in three stops- 01 · Your computerYou upload a CSV
Checked for size, encoding and shape before anything is saved.
- 02 · Your private workspaceProfiled and cleaned, one reversible step at a time
Only your account can open it. The original upload is kept for reset.
- 03 · Your computerA clean copy downloads
A new file named after your dataset. The one on your disk is never touched.
Who it’s for
Anyone holding an export they don’t trustDedupe a list before it hits your email tool.
newsletter_export.csvTidy survey responses before you analyse them.
survey_wave2.csvFix inventory sheets before the next import fails.
stock_levels_oct.csvClean a transactions export before it reaches the books.
transactions_q3.csv
Why not just a spreadsheet?
You can. It’s just slower, and it’s easy to miss what you can’t see.
| Spreadsheet | CleanYourDataset | |
|---|---|---|
| Find duplicate rows | Helper column and a formula | Counted on upload |
| See stray spaces | Invisible | Marked in every cell |
| Check a fix first | Apply and hope | Exact count, then apply |
| Undo a mistake | Hope it’s still in history | Undo, or reset to the upload |
| Original data | Easy to overwrite | Kept for reset |
| Cells starting =, +, - or @ | Can run as formulas | Exported as text |
The limits, up front
Outside them? You get a clear reason, not a crash- File size
- 128KiB
- Data rows
- 1,000rows
- Columns
- 20cols
- Per cell
- 500chars
- Per account
- 100files
Free CSV tools
No account · nothing uploaded · see all 9Free for small files.
Ready in a minute.
Already have one? Log in