Turbo Excel Cleaner

Blank rows left by an export, duplicated records from two systems merged into one sheet, dates written four different ways, trailing spaces that break every lookup formula, a header row repeated eleven times because someone concatenated eleven CSV files. Fixing that by hand means Find & Replace, Go To Special and sort-then-delete, one workbook at a time.

Turbo Excel Cleaner turns the job into a checklist. Load one file or a queue of exports, tick the operations you want from a list of 43, and the app applies them to every sheet in every file. Originals are never modified; each result is a separate cleaned copy.

The 43 features sit in four categories matching the four kinds of mess a spreadsheet accumulates. Rows & Columns handles structural junk. Text Cleaning handles what is inside the cells. Data Standardization makes values consistent. Structure & Formatting deals with the workbook itself — formulas, comments, hyperlinks, formatting rules, images, sheets.

Every feature starts unchecked, so nothing runs until you opt in. One Recommended button applies a curated set of 19 safe, non-destructive features, chosen so they are safe on data you have not reviewed yet. Everything runs locally, so workbooks of financial or customer records never leave the machine.

Features that only make sense for a real Excel file — hidden rows, merged cells, comments, hyperlinks, formatting rules, images, validation, gridlines, freeze panes, auto-fit — are skipped automatically for CSV, TSV and TXT. Numbers written to delimited formats come back as 200, not 200.0.

These attack the shape of the sheet rather than the contents of the cells. Each is an independent checkbox.

Where the invisible problems get fixed — the ones that make VLOOKUP return #N/A on two strings that look identical on screen.

All three case options leave email addresses, phone numbers and already-standardized YYYY-MM-DD dates untouched, whichever mode you pick.

These take values that mean the same thing but are written differently and make them match. Each acts only on values it can confidently recognize.

This category works on the workbook rather than its values: the objects, rules and decorations that make a file heavy, fragile or awkward to hand on.

The last two operate across the whole workbook by definition, so they run only in All Sheets mode. Target a single sheet and they are skipped automatically.

Forty-three checkboxes is a lot of decisions about a file you have not opened. Recommended applies a fixed set of 19 features chosen to be broadly useful and non-destructive.

• Remove hidden rows, remove merged cells
• Remove repeated header rows, remove separator rows
• Remove blank rows, remove duplicate rows
• Fix encoding, trim spaces, collapse whitespace, remove non-printable characters
• Clear null placeholders, trim column headers
• Standardize dates, preserve leading zeros, fix scientific notation, convert text numbers to numbers
• Freeze header row, auto-fit column widths, remove empty sheets

What it leaves out matters as much: no case rewriting, no outlier removal, no boolean normalization — nothing opinionated about what your data should look like. It always produces the same 19 regardless of what is ticked, so it doubles as a reset. Select All and Deselect All sit beside it; Select All turns on one case mode rather than all three, since only one can apply per run.

1. Add your files. Click Add Files and pick one or more spreadsheets. Unsupported types are rejected with a warning listing exactly which files were skipped.
2. Choose a sheet. With exactly one file loaded, Sheet Selection reads the real sheet names so you can clean a single sheet; with several files it locks to All Sheets.
3. Pick your cleaning features. Every feature starts unchecked. Tick the ones you want, or press Recommended to apply a curated set of 19 safe features in one click.
4. Choose an output folder. By default cleaned files are written next to the originals with a _cleaned suffix; click Choose Output Folder to send them elsewhere.
5. Run the cleaning. Click Run Cleaning. The progress bar and Activity Log report each file, each sheet and how many cells or rows each feature changed.
6. Review the results. A summary reports how many files cleaned successfully. Your original files are never modified.

The interface

A compact fixed window in three areas. The top bar shows license status on the left (the email the copy is licensed to, or "Unlicensed") and Help, About and Check for Updates on the right. The sidebar holds Add Files and Clear, a scrollable queue with a remove control on each entry, Sheet Selection, Choose Output Folder, and a green Run Cleaning button with a progress bar pinned at the bottom; The main panel holds the 43 features, two per row in four bordered cards with Select All, Deselect All and Recommended in the header, beside a dark live log. The log shows which file and sheet is being cleaned and one line per feature reporting how many cells, rows or sheets it changed; features that changed nothing stay quiet.

Sheet selection

• One file loaded: the dropdown lists that workbook’s real sheet names plus All Sheets. Pick one and only that sheet is cleaned; every other sheet is written back untouched.
• Zero or several files: it locks to All Sheets, since per-sheet targeting stops making sense across workbooks with different sheet names. If a targeted sheet is missing from a file, that file is skipped with a warning.
• CSV, TSV and TXT always report a single sheet.

Why processing order matters

Cleaning operations interfere with each other, so the pipeline applies a fixed order whichever boxes you tick; your checkbox order has no effect.

• Sheet removal runs first, so no work is wasted on a sheet about to disappear, and merged cells are flattened before any deletion because merge ranges do not re-anchor reliably when rows shift.
• Repeated headers and separator rows are detected before text cleaning, since both match whole rows against raw content and a trimmed duplicate header would no longer match.
• Text cleaning runs next. Phone and email standardization run before number conversion, or a digit-only phone number is silently turned into a plain number, and number conversion respects leading-zero preservation.
• Row and column reduction runs after text cleanup so blank and duplicate detection compare cleaned values; formula flattening and formatting cleanup run last.
• One failure never kills the batch: each function is self-contained and guarded, so an error on one sheet is logged and the run continues.

Originals are never modified. Every run produces new files, written beside the source with a _cleaned suffix or into an output folder you choose.

Native Excel formats are saved back as they came in. Legacy binary formats — .xls, .xlsb, .ods — are always converted to .xlsx. Delimited formats keep their own: a CSV returns a CSV, a TSV a TSV.

Two things block a save regularly, neither a bug: a previous cleaned copy is still open in Excel, or Windows Controlled Folder Access is protecting Downloads, Documents and Desktop, which it does by default. Rather than a raw error, the app retries with alternate filenames — _cleaned_2.xlsx, _cleaned_3.xlsx — up to four attempts, logging which it used. Only if all four are blocked does it stop, with one clear message naming the likely causes.

Cleaning happens entirely on your machine. Nothing is uploaded, there is no cloud step and no account to create, and once installed the app works with the network disconnected. The only traffic it generates is license verification, which sends your purchase email and key and nothing else. That matters when the files you need to clean are payroll runs or client ledgers.

Cleaning holds a workbook in memory, so peak memory use scales with the largest single file rather than with how many files are queued.

1. Purchase and download the Windows build. No subscription, no recurring fee.
2. Launch it. On first run, an activation window asks for the email you purchased with and your license key.
3. Activate once. The pair is verified, then cached locally so you never re-enter it.
4. Later launches are silent. The cached license is re-verified before the main window opens; the activation window only reappears if that check fails.
5. Check your status any time in the top-left corner of the main window.

To switch licenses, delete the cached license file from the app's folder in your local application data directory and relaunch.