CSV tools
Clean a CSV file
Fix the usual problems with exported CSVs in one pass and download a tidy file. Everything is done in your browser.
What it can fix
Pick the clean-ups you need: change the delimiter (for example semicolons to commas), trim spaces around values, remove empty rows, remove exact duplicate rows, and drop columns that are completely empty. The cleaned file is saved as UTF-8, the encoding most software expects today.
Why exports need cleaning
CSVs from banks, shops and older systems often arrive with semicolons instead of commas, padding spaces that break lookups, blank lines between sections, rows repeated by a double export, or a regional encoding that turns accented letters into symbols. Each of these quietly breaks an import or a formula.
What it doesn't change
Values themselves aren't rewritten: dates, numbers and capitalisation stay as they are, and only rows that are identical in every column count as duplicates. Your original file isn't modified; you download a cleaned copy.
Your files stay on your device
Cleaning happens in your browser, so the raw export never leaves your device. The work happens in your browser, so nothing is uploaded and nothing is stored on a server. Once the page has loaded it keeps working offline, and it's free, with no sign-up and no watermark.
Questions
How do I remove duplicate rows from a CSV?
Turn on the duplicate-row option and download the result. Rows that are identical in every column are kept once.
How do I change a CSV from semicolons to commas?
Choose comma as the output delimiter. The file is re-written with commas, and values containing commas are quoted so the columns stay intact.
Why does my CSV show strange characters?
It's probably saved in a legacy encoding. Cleaning re-saves the file as UTF-8, which fixes how accented and non-English characters display in most software.