[ CSVRefine ]
About CSVRefine
CSVRefine is a free online workspace for inspecting, cleaning, editing, validating, analysing, merging, splitting and converting CSV files. All processing happens locally in your browser — no account, no upload, no server.
What CSVRefine helps you do
- Remove duplicate records — full row or selected columns, keep first or last, with a preview before anything changes
- Remove empty rows and columns automatically
- Clean whitespace, leading/trailing spaces and repeated inner spaces
- Format CSV files consistently — delimiters, quoting and encoding
- Validate CSV structure — inconsistent columns, quoting errors and missing headers
- Profile your data — types, uniqueness, empty ratios, statistics and a transparent quality score
- Merge multiple CSVs by matching headers, even with different column orders
- Split large files by rows, equal parts or column values
- Edit CSVs in the browser — cells, rows, columns, headers, sort and find & replace
- Convert Excel (.xlsx/.xlsm) workbooks to CSV — shown in your browser, formulas kept as calculated values
- Check overall data quality with CSV Health Check and fix the issues you select
Our approach
- Practical tools — every tool works, with real output you can verify
- Clear workflows — upload, diagnose, fix, preview, download
- Accessible interface — keyboard-friendly, semantic, high-contrast, RTL-ready
- International usability — UTF-8 strict decoding, UTF-16/Windows-1252 support with clear warnings, and 12 UI languages
- Privacy-conscious file processing — your file never leaves your browser
- Honest limitations — we tell you what happened, not what you hope happened
Privacy-first by design
CSVRefine parses, analyses and cleans files inside your browser using a dedicated Web Worker. The only resources fetched are the page’s static assets (HTML, CSS, fonts and JavaScript). No byte of your CSV is transmitted anywhere, and no upload endpoint exists. You can verify this yourself by watching DevTools → Network while uploading a file — you will see no request carry your data. That holds for every CSV tool on this site.
Who can use CSVRefine?
Analysts, developers, data scientists, researchers, students, business users, marketers, database administrators — anyone who works with CSV or spreadsheet data and wants it clean, validated and reliable.
Product limitations
- CSVRefine is a CSV data workspace, not a full spreadsheet application — it does not render charts, pivots, macros or formulas
- Excel files are converted to plain CSV — styles, merged cells and formulas are never preserved or emulated
- Ambiguous dates and numbers (e.g. 05/06/2024) are flagged, never automatically converted
- Very large files are limited by your browser’s available memory
- There is no account system, no cloud storage and no collaboration features
Get in touch
Feedback, questions and bug reports go to the contact page. Contact us