ExcelCleansing

ExcelCleansing

The Professional Data Laundry — a growing suite of free, browser-based tools to clean, fix, and prepare Excel files.

100% Private — files never leave your browser

Spreadsheet Cleaner

Unmerge cells, fix headers, strip ghost characters, trim empty rows and columns — in one click.

Open tool

Duplicate Remover

Find and remove duplicate rows in seconds — across one sheet or every sheet in the workbook.

Open tool

CAGR Calculator

Calculate Compound Annual Growth Rate instantly and copy the exact Excel formula.

Open tool

List Comparison

Paste two lists, see what's unique to each and what overlaps — instantly.

Open tool

XLOOKUP Generator

Build any XLOOKUP formula visually — paste-ready, no syntax errors.

Open tool

Why ExcelCleansing

Spreadsheets that come out of accounting software, ERP exports, PDF roundtrips, scraped web tables, or just years of copy-paste accumulate invisible mess. Merged headers that hide values. Phantom columns full of styled-but-empty cells. Non-breaking spaces that make VLOOKUP silently miss. Duplicate rows. Stray footnotes sitting at row 1,440.

Cleaning all of that by hand takes an hour. ExcelCleansing tools do it in seconds — entirely in your browser. Your file is read, processed, and rewritten without ever touching a server. You can disconnect your network and the tools still work.

  • 100% client-side. No upload, no signup, no telemetry beyond anonymous page views.
  • Verifiable. Open DevTools → Network and watch — zero outbound traffic with your file.
  • Free, forever. No paid plans, no feature limits, no email gates.

Built for the people who actually open these files

Accountants & finance

Closing books, importing trial balances, reconciling exports from QuickBooks, Xero, SAP, Oracle.

Data analysts

Pulling third-party reports into Power BI, Tableau, or Python and getting clean data into the pipeline.

Operations teams

Massaging vendor exports, inventory CSVs, and partner reports before they hit the warehouse.

HR & payroll

Cleaning payroll exports, HRIS reports, and time-tracking dumps before downstream processing.

Sales ops

Sanitising lead lists, CRM exports, and quote sheets before they get loaded back in.

Anyone, really

If you have ever spent more than 10 minutes deleting blank rows or fighting merged headers, this is for you.

Knowledge Hub

Practical, opinionated guides for cleaning real-world Excel files. Each guide ends with how to do the same thing in one click using the matching tool.

Browse all guides →