[ Client-Side Data Quality Toolkit ]
Clean, validate and repair CSV files — right in your browser.
CSVRefine detects duplicates, empty rows, stray whitespace, broken quoting and inconsistent types — then shows you a transparent quality score and a before-and-after preview before you download.
[ Interactive Workspace ]
Cleaning Workspace
Upload a CSV and choose exactly which problems to fix. Nothing is applied automatically.
100% client-side
No upload · No storage
Refresh or close the tab and your cleaned dataset is gone — download your file to keep it.
Parsing rows, detecting delimiters and profiling columns in your browser.
file.csv
Encoding notice
Data Quality Score
–
–
Points deducted from 100 for each problem found. Hover rows or see the report for details.
Columns
| Column | Type | Empty | Unique |
|---|
Detected problems & fixes
Duplicate options
Columns to match on:
Rows that will be removed (first 25):
Whitespace options
Format options
First 25 rows
Cleaning history
How it works
Upload → Analyse → Diagnose → Select → Preview → Download
- 1.
Upload
Drop a CSV, TSV or TXT file — or load the sample dataset.
- 2.
Analyse
Delimiter, encoding, headers, types and structure are detected automatically.
- 3.
Diagnose
A 0–100 quality score is computed with a full deduction breakdown.
- 4.
Select fixes
Tick only the operations you want. Nothing is applied by default.
- 5.
Preview
See a before/after diff and exactly which rows will be removed.
- 6.
Download
Export the cleaned CSV — your original file is never touched.
[ Advanced CSV Editor ]
Advanced CSV Editor
Open CSV files and edit them like a spreadsheet — inline cell editing, add/remove rows and columns, rename headers, sort, filter, search & replace, with full Unicode support and instant download. All processing stays in your browser.
Advanced CSV Editor
$ edit in place — no upload, no account
✓ Inline cell editing
✓ Add/delete rows and columns
✓ Rename headers · sort · filter
✓ Find & replace
✓ Undo / redo
✓ Unicode + quoted cells preserved
Upload → diagnose → fix → download
CSV Health Check
Upload your CSV to get an instant diagnosis of issues — structure, completeness, duplicates, formatting, validity and compatibility — and fix them in one place.
Three steps
- 1.Upload
- 2.Analyse
- 3.Diagnose
- 4.Select fixes
- 5.Preview
- 6.Download
The toolkit
All the tools, one workflow
Each tool works standalone for a specific task — and all of them feed the same cleaning engine, so results are consistent everywhere.
CSV Health Check
Get an instant diagnosis of every CSV problem — then fix them in one click.
Open tool →CSV Duplicate Remover
Remove fully duplicated rows or deduplicate by selected columns. Keep first or last.
Open tool →Empty Row & Column Remover
Detect and strip completely empty rows and columns in one pass.
Open tool →Whitespace Cleaner
Trim leading/trailing spaces and collapse repeated inner spaces.
Open tool →CSV Formatter
Normalise delimiters, quoting and whitespace into a consistent file.
Open tool →CSV Validator
Audit structure: column counts, quoting, headers and encoding issues.
Open tool →CSV Data Profiler
Column types, uniqueness, empty ratios and a transparent quality score.
Open tool →CSV Merger
Combine multiple CSVs vertically, aligning columns by header name.
Open tool →CSV Splitter
Split large files by row count, file size or column values. ZIP download.
Open tool →Excel to CSV Converter
Convert .xlsx sheets to CSV with delimiter and BOM options.
Open tool →Transparent scoring
A quality score you can audit
Most tools say “your file has issues” and stop there. CSVRefine starts at 100 and deducts points per problem class — every deduction is explained, so you know exactly what to fix and why.
- −25Empty cells (scaled by % of cells)
- −25Duplicate rows (scaled by % of rows)
- −15Empty rows and empty columns (empty rows/columns)
- −10Stray leading/trailing/repeated whitespace (each cell with irregular whitespace)
- −20Malformed rows and inconsistent value types (each malformed/inconsistent row)
- −5Blank or likely-missing headers (each blank/likely-missing header)
sample-messy-data.csv
42 / 100- Duplicate rows (3 of 15)−12.0
- Empty rows (2 of 15)−3.3
- Empty cells (14 of 75)−9.3
- Stray whitespace (9 cells)−4.8
- Inconsistent types (1 cell)−0.5
Illustration of the deduction panel shown after every analysis. The breakdown is generated from your actual file, never hard-coded.
Free online csv tools to inspect, clean, fix and convert CSV files
Why people need online csv tools
Every business moves data between systems as a csv file — reports, backups, imports and exports. Each handoff risks a broken delimiter, a lost accent, a duplicate row or an empty line that quietly breaks the next import. CSVRefine puts the whole workflow online: free, browser-based csv tools online for inspecting, cleaning, repairing, editing, validating, analysing and converting files without sending them anywhere. Whether you are cleaning a customer export, a product catalogue or a finance reconciliation, the goal is the same — open a csv file, see its real state, then fix only what is broken.
Clean and repair CSV files
Broken CSV files usually fail at the edges — stray spaces, empty rows and columns and duplicate records — while looking fine on the surface. The CSV Health Check diagnoses structure, completeness, duplicates, formatting, validity and encoding issues, scores your file from 0 to 100 and explains every finding in plain language with severity and affected rows. For hands-on csv data cleaning, the csv cleaning tool trims leading and trailing whitespace, squishes repeated spaces and deletes empty rows and columns — and the CSV Duplicate Remover deletes exact or column-scoped duplicates with a before/after preview you approve first, keeping the first or last record on your terms. Nothing changes until you say so: honest, reviewable csv file repair online.
Edit and validate directly in the browser
Some files need repair, others just need a careful edit. The Advanced CSV Editor lets you add, delete and rearrange rows and columns, rename headers, sort, filter and find-and-replace in bulk, with full undo and redo. The CSV Validator checks column counts, quoting and headers, reporting problems by row number, and the CSV Data Profiler — a csv data quality checker — builds a per-column profile of types, uniqueness, empty ratios and min/max values, downloadable as a data quality report you can share with your team.
Merge, split and convert without Excel
When data spans multiple files, the CSV Merger combines them into a single file — matching headers by name, filling missing columns with blanks, never silently dropping values, and letting you choose which rows to keep. The CSV Splitter breaks an oversized export into equal parts, fixed rows per file or one file per column value. The Excel to CSV Converter turns any .xlsx workbook into a clean CSV with the csv delimiter you choose — comma, semicolon, tab or pipe — and the formatter normalises encoding and quoting when an export mixes them. Perfect for spreadsheet to csv conversions.
Private by architecture, international by default
Your data never leaves your browser: parsing happens in a local Web Worker, with no upload endpoint, no analytics on file contents and no logging. Multi-byte and RTL text — Arabic, Hebrew, Hindi, Urdu, Chinese, Japanese, Russian and more — is preserved exactly as uploaded. CSVRefine reads UTF-8, UTF-8 BOM, UTF-16LE/BE, Windows-1252 and ISO-8859-1 with clear warnings, and flags ambiguous dates and numbers instead of guessing. Light and dark themes adapt to you — and no file ever reaches a server, not for parsing, not for analysis, not for storage.
From upload to download in five steps
Upload your file, review the analysis, select the fixes you want, preview the result and download the cleaned file: Upload → Analyse → Fix → Preview → Download. No signup, no upload, no waiting — most files are analysed in under a second. Start with CSV Health Check or jump straight into any tool below.
One workspace, from inspection to download
CSVRefine is the fastest way to clean csv data online: inspect the file with the CSV Health Check, a free online csv health check, then fix it — duplicates with the csv duplicate remover, structure with the csv validator, punctuation with the csv formatter, or open and edit it with the online csv editor before your next import.
When the workbook is an .xlsx, the Excel to CSV Converter, a free xlsx to csv converter online — and its spreadsheet to csv sibling for Google exports — turn every sheet into a clean CSV, while the merger and splitter keep large exports flowing into warehouses, CRMs and spreadsheets. Everything runs locally in your browser; your data is never uploaded.
Upload → Diagnose → Fix → Preview → Download: that is the whole workflow.
Privacy by architecture
Your data never leaves this tab.
CSVRefine parses and cleans files inside your browser’s memory using a dedicated Web Worker. There is no upload endpoint, no analytics on file contents, no logging of rows, and no persistence after you close the tab. Verify it yourself: open DevTools → Network → upload a file — zero requests.