Clean, fix and convert
CSV & Excel files
Remove duplicates, trim spaces, repair encoding, standardize dates and emails, merge or split files, and convert between CSV, Excel and JSON. All in your browser, in seconds.
CSV & Excel cleaning workspace
No account. No uploads. Just clean data.
Upload your file
Drop your CSV or Excel file here
or browse your device. You can select several files at once.
CSV, TSV, TXT, XLSX, XLS, ODS and JSON · up to 50.0 MB and 250,000 rows
Your files never leave your device.
26 free tools
One workspace for every data chore
Each tool opens the workspace above with the right options already on. Combine them freely.
Clean & fix
Why CleanCSV
Built for real-world, messy data
Private by design
Files are read and cleaned on your device. Nothing is uploaded, stored or used for anything else, so customer lists and financial data stay with you.
Understands messy files
Detects the delimiter, the text encoding and the header row, keeps rows with missing fields, and reads every sheet of an Excel workbook.
Finds problems for you
Duplicates and near-duplicates, empty rows and columns, extra spaces, invisible and garbled characters and invalid emails are counted before you start.
Preview every change
Changed cells are highlighted with their old value. Search the result, show only changed rows and download a plain-language report.
Excel-safe output
Download CSV, TSV, JSON or a real .xlsx that keeps leading zeros, long IDs and dates intact, with formula-injection protection for CSV.
Handles big files
Up to 250,000 rows and 50 MB per file. Merge several files into one or split a large file into a ZIP of smaller ones.
Simple by design
How it works
Drop your files
CSV, Excel or JSON, one file or several. They are analyzed instantly on your device.
Pick the fixes
Apply the recommended fixes in one click or choose exactly what to change. The preview updates as you go.
Download
Get CSV, Excel, TSV or JSON, split into parts if you like, plus a report of every change.
Your data stays yours.
Most online converters upload your file to their servers. CleanCSV does the work in your browser instead, so file contents are never sent anywhere, stored in an account or used for training. Close the tab and they are gone.
Read our privacy policyLocal processing
Parsing, cleaning and file creation happen on your device.
You choose every edit
No hidden changes. Every modified cell is highlighted.
Original always untouched
Your source file is never modified, and you can download it again at any time.
Learn
Guides
How to Remove Duplicates from a CSV File (4 Ways)
Remove duplicate rows from a CSV file in your browser, Excel, Google Sheets or Python, and avoid the pitfalls that leave duplicates behind.
Why Excel Changes Your CSV Data (and How to Stop It)
Excel drops leading zeros, turns long numbers into 1.23E+15 and converts text to dates when it opens a CSV. Here is why it happens and how to prevent it.
Garbled Characters in CSV Files (é, ’): Causes and Fixes
Why CSV files show é instead of é or ’ instead of an apostrophe, how to repair the text, and how to save files so it never happens again.
Common questions
Frequently asked questions
Is CleanCSV free?
Yes. Every tool is free to use without an account. The site is supported by advertising and optional tips.
Are my files uploaded to a server?
No. Your browser reads, cleans and creates the files on your device. File contents are never sent to CleanCSV or anyone else, which makes it safe for customer lists and other confidential data.
Which file types are supported?
CSV, TSV and TXT files with comma, semicolon, tab or pipe separators, Excel workbooks (.xlsx, .xls, .xlsm, .xlsb, .ods) and JSON (.json, .jsonl, .ndjson). You can download CSV, TSV, Excel or JSON.
How large can my file be?
Up to 250,000 rows, with 50 MB for text and JSON files and 25 MB for Excel workbooks. Processing happens in your browser, so very large files depend on your device's memory.
Will anything change without my say-so?
No. Nothing changes until you switch an option on, every change is highlighted in the preview next to the old value, and your original file is never modified.
Can I work with several files at once?
Yes. Select several files, or upload a workbook with several sheets, then combine them into one table or clean each one separately. See Merge CSV files.