For IndividualsFor Analysts & FinanceFor Students & LearnersFor Teams & Automation
MENU
=TOOLS.A2

CSV 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

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.