TurboSoftwares

Turbo Excel Cleaner

Buy now

About the Software

Exports leave blank rows, duplicated records, dates written four ways and trailing spaces that break lookups. Fixing them by hand means Find and Replace, one workbook at a time.

Turbo Excel Cleaner turns that into a checklist. Load one file or a queue of exports, tick operations from a list of 43, and the app applies them to every sheet in every file. Each result is saved as a separate cleaned copy.

Screenshots

Features

Rows and Columns
Remove blank rows and columns, duplicate rows, hidden rows and columns, merged cells, repeated header rows and separator rows.
Text Cleaning
Trim and collapse spaces, strip non-printable characters, repair broken encoding, change case and clear null placeholders.
Data Standardization
Make dates, numbers and values consistent so lookups and pivot tables behave.
Structure and Formatting
Deal with formulas, comments, hyperlinks, formatting rules, images and sheets.
Recommended preset
Every feature starts unchecked. One button selects 19 safe, non-destructive operations.
Batch queue
Process many files and every sheet in one run, or pick a single sheet.
Activity log
A live log records what each operation changed in each file.

Supported formats

Ten input types are handled. Encoding and delimiters are detected rather than assumed, and legacy formats are written back as XLSX.

  • XLSX
  • XLSM
  • XLTX
  • XLTM
  • XLS
  • XLSB
  • ODS
  • CSV
  • TSV
  • TXT

How to use it

  1. Add files.
    Drop one file or a queue of exports onto the window.
  2. Choose operations.
    Tick features, or press Recommended.
  3. Pick an output folder.
    Cleaned copies are saved there.
  4. Run.
    Follow the activity log.

All processing is local, so financial or customer workbooks never leave your computer.

What the features do

Remove duplicate rows
Keeps the first occurrence. It runs after text cleaning, so rows that differ only by a trailing space are caught.
Remove merged cells
Unmerges every range and fills the value into the first cell, so a pivot table can read the sheet.
Remove outlier rows
Uses a per-column z-score with an adjustable threshold, 3.0 by default.
Fix encoding
Repairs text decoded with the wrong character set.
Trim column headers
A header with a trailing space breaks imports and named ranges, so headers get their own cleanup.
Clear null placeholders
Converts values such as N/A and NULL into truly empty cells.

Offline use

Originals are never modified. Everything runs locally, and no workbook is uploaded.

Typical uses

Use it on exports from accounting, inventory or CRM systems, on sheets built from several systems, and on files made by joining many CSVs. Blank and repeated header rows are removed, text is tidied, and values are made consistent in one pass.

Features that only make sense in a real Excel file, such as hidden rows, merged cells and comments, are skipped for CSV, TSV and TXT files. Delimited files fall back through several encodings, so even badly encoded files open.