DataScrub
100% Client-Side — Your Data Never Leaves Your Browser

Scrub your data clean,
no server required

Upload your CSV, Excel, ODS, or JSON file and use powerful cleaning tools — all processing happens locally in your browser. Zero data uploads.

Analyze

1 tool
📊Start here

Data Profiler

Instant health report — column types, missing values, uniqueness, duplicates, outliers.

Transform

4 tools
🔗

Merge / Join Files

Combine two files on a shared column. Inner, left, right, or full join.

📋

Missing Data Handler

See which cells are blank. Fill with defaults, forward-fill, or drop empty rows.

🧹

Deduplicator

Remove duplicate rows based on any column. Keep first or last occurrence.

✂️

Column Manager

Split columns by delimiter or merge two columns with a separator.

Clean & Format

3 tools
🧽

Text Cleaner

Trim spaces, strip HTML, remove special characters, normalize Unicode.

✨

Format Helper

Change text case, reformat dates, trim whitespace, or find & replace.

🔒

Privacy Anonymizer

Scramble emails, names, and phone numbers. Auto-detects sensitive columns.

Utilities

2 tools
🔄

JSON ↔ CSV Converter

Convert between JSON and CSV/Excel formats with one click.

⚡Power users

Custom Script

Write JavaScript to transform your data. Parse prices, calculate columns, full control.

No data uploaded
Instant processing
Works offline
Privacy-first

What is DataScrub?

DataScrub is a free online data scrubbing tool that runs entirely in your browser. There are no uploads, no servers, and no sign-up required. Upload a CSV, Excel, ODS, or JSON file, pick a tool, and download your cleaned data — everything happens locally on your device.

Why Clean Data Matters

Dirty data costs organizations time and money. Missing values, duplicate rows, inconsistent formatting, and mixed data types compound over time, leading to broken reports and flawed analysis. DataScrub gives you instant tools to fix these problems without writing code — or with code, if you prefer.

How It Works

  1. Upload your file — drag and drop or click to browse.
  2. Pick a tool — choose from profiling, merging, deduplication, formatting, and more.
  3. Download clean data — export to CSV, Excel, ODS, or JSON.

Everything runs client-side using JavaScript. Your data never leaves your device, and nothing is sent to a server.

Supported File Formats

DataScrub works with the most common tabular data formats. Import CSV, TSV, Excel (.xlsx and .xls), OpenDocument Spreadsheets (.ods), or JSON files, and export your results to any of these formats.

Privacy and Security

Zero server uploads. No cookies tracking your data. Works offline once loaded. DataScrub is GDPR-friendly by design because your data stays in your browser at all times.

Frequently Asked Questions

Is DataScrub really free?

Yes, 100% free. No sign-up, no usage limits, no hidden paywalls. Every tool is available to everyone.

Is my data safe?

Your data never leaves your browser. All processing happens locally using JavaScript — nothing is uploaded to any server.

What file formats are supported?

CSV, TSV, Excel (.xlsx/.xls), OpenDocument (.ods), and JSON. You can export your cleaned data to any of these formats.

Do I need to install anything?

No. DataScrub runs in any modern browser. Just open the site and start scrubbing.