Skip to content

CSVRefineClient-Side
Workspace

Tools

CSV Duplicate RemoverEmpty Row & Column RemoverWhitespace CleanerCSV ValidatorCSV Data ProfilerCSV FormatterCSV MergerCSV SplitterPrivacy & Processing

Language

Theme

[ 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.

Zero server uploadsWeb Worker parsingQuoted-field safe

[ Interactive Workspace ]

Cleaning Workspace

Upload a CSV and choose exactly which problems to fix. Nothing is applied automatically.

Refresh or close the tab and your cleaned dataset is gone — download your file to keep it.

Never uploadedProcessed in-memoryDiscarded when you leave

How it works

Upload → Analyse → Diagnose → Select → Preview → Download

  1. 1.

    Upload

    Drop a CSV, TSV or TXT file — or load the sample dataset.

  2. 2.

    Analyse

    Delimiter, encoding, headers, types and structure are detected automatically.

  3. 3.

    Diagnose

    A 0–100 quality score is computed with a full deduction breakdown.

  4. 4.

    Select fixes

    Tick only the operations you want. Nothing is applied by default.

  5. 5.

    Preview

    See a before/after diff and exactly which rows will be removed.

  6. 6.

    Download

    Export the cleaned CSV — your original file is never touched.

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

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. 1.Upload
  2. 2.Analyse
  3. 3.Diagnose
  4. 4.Select fixes
  5. 5.Preview
  6. 6.Download

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.

No uploadsNo accountsNo cookies for file dataNo storage after tab close