DataScrub for Microsoft Excel

Messy data in. Review-ready data out.

A practical set of 40+ tools for the cleanup tasks that interrupt accounting and operations work—from whitespace and dates to deduplication, imports, and contact data.

No installationPreview before applying32-bit and 64-bit Excel
DataScrub ribbon with workflow menus for text, numbers, dates, cleanup, contacts, and imports
A calmer ribbonEight workflow groups keep a broad toolset discoverable without crowding Excel.
One focused tool for each cleanup problem

From a quick repair to a repeatable cleanup pipeline.

Select only the cells you intend to work on, choose the task, inspect the preview, then apply.

Aa

Text

Trim and normalize whitespace, change case, remove characters, split or join text, extract patterns, parse values, and create identifiers.

123

Numbers

Calculate, round, scale, normalize, rank, convert units, repair numeric text, handle signs, and replace formula errors safely.

CAL

Dates

Convert text to dates, extract date parts, calculate ages and differences, shift dates, and standardize date representations.

CLR

Cleanup

Find true duplicate records, remove blanks with safeguards, standardize categories, clean HTML, and run multi-rule replacements.

@

Contacts

Format phones, validate email syntax, split names and addresses, normalize countries, and clean web addresses.

IN

Imports

Bring in quoted CSV and delimited text, extract digital PDF or Word content, combine files, and preview clipboard data.

SCAN

Health Scan

Inspect the selected data for blanks, type inconsistencies, duplicates, formula issues, whitespace, and other quality signals.

↶

DataScrub Undo

Reverse the most recent supported DataScrub operation while guarding against restoration into the wrong workbook or sheet.

Previews that support judgment

See what will change before changing the workbook.

Feature dialogs use a consistent options-and-preview layout, clear change counts, responsive sizing, and guarded action buttons.

  • Current and proposed values shown side by side
  • No-op actions remain disabled
  • Formula-preserving behavior where appropriate
  • Collision checks before writing into neighboring cells
Remove Characters dialog showing options beside a before-and-after preview

Remove Characters keeps the options and preview visible together.

Advanced Replace dialog with multiple replacement rules and preview

Build and review ordered multi-rule replacements.

For one-off and repeatable work

Handle a single exception—or save the whole cleanup sequence.

Use a specialist command for a specific problem, Quick Clean for common fixes, or build a reusable multi-step pipeline for recurring exports.

8workflow groups
61guided dialogs
1portable file
Three-day trial

The 72-hour period starts with the first feature—not the download.

Opening the launcher or Excel does not start the trial. The first DataScrub feature begins a fixed server-confirmed 72-hour period. A signed local cache permits up to 24 hours offline between checks, never beyond expiry.

Fixed expiry

Reinstalling or deleting local files does not issue another trial for the same protected machine identity.

Clock protection

A material clock rollback requires online verification rather than silently extending the trial.

Minimal identifiers

The service stores hashed machine and installation identifiers—not workbook contents or raw hardware values.

Pricing

DataScrub — $29 per year

Start with the complete three-day trial. No credit card is required to test the product.

Want every command and safeguard?

The searchable guide documents the complete DataScrub feature set.

Open complete guide