Free ebook
Free ebook: Excel for Beginners
Covers data entry, formatting, sorting, filtering, and your first formulas — the foundation for everything you clean here. Read online or download the PDF.
Get the ebookCourse path
Learn data cleaning in Excel
The Beginners in Excel course path covers importing, cleaning, and structuring data from scratch — public YouTube lessons in a guided order.
View course pathCSV cleaner
Paste or upload a CSV, dedupe and trim it, then copy or download the result. Everything runs in your browser — nothing is uploaded anywhere.
You can also drag a .csv file onto the box. Nothing leaves your browser — files up to 5 MB.
What it does
Paste CSV or tab-separated text and the cleaner applies the fixes that almost every export needs before it is usable: trimming whitespace, dropping blank rows, removing duplicate rows, and normalising the delimiter. The result is ready to paste straight back into a sheet.
The problems it is fixing
- Leading and trailing spaces. Invisible on screen, and enough to make a lookup fail or split one category into two in a pivot table.
- Non-breaking spaces. Character 160, which arrives from anything copied out of a web page. It looks exactly like a space, and Excel's own
TRIMwill not remove it. - Blank rows inside the data. These terminateCtrl+Arrow navigation and make Excel think your table ends early.
- Repeated rows from a date range that overlapped the last export.
Why paste rather than open the file
Double-clicking a CSV hands every column to Excel's parser with no say from you, and three things get destroyed before you have typed anything: leading zeros vanish from account numbers, long references turn into scientific notation, and dates get read in your machine's locale rather than the file's. Cleaning the text first, then pasting into a sheet with the columns already set to Text, avoids all three.
For a file that arrives every month, useData → From Text/CSV instead so the import becomes a repeatable query — seecleaning a bank statement exportand thePower Query refresh checklist.
What it does not do
It does not parse quoted fields containing the delimiter, split one column into several, or fix date formats. For splitting, use thecolumn splitter. For anything that needs judgement about what a value means, the cleanup belongs in Excel where you can see the result in context.
Privacy
All processing happens in your browser. Nothing is uploaded or stored, which matters when the thing you are cleaning is a customer list.



