Home / Office & Sheets / Spreadsheet Cleaner

Spreadsheet Cleaner

Trim spaces, remove hidden characters and blank rows or columns, fix number text, change case, fill down and transpose.

Free, no uploads, no sign-up. Runs 100% in your browser.

How Spreadsheet Cleaner works

Files are opened in your browser with SheetJS and JSZip. Nothing is uploaded, and your original file is never changed. Every change is counted, and you can switch between the original and cleaned view before saving.

Input: XLSX, XLS, ODS, CSV. Output: XLSX, CSV, ODS.

How to use Spreadsheet Cleaner

  1. Drop a spreadsheet.
  2. Tick the clean-ups you want.
  3. Check the preview.
  4. Download the clean file.

Tips

  • Excel, ODS and CSV all work. Formulas are read as their last saved values.
  • For CSV files with odd characters, save them as UTF-8 first.

Spreadsheet Cleaner FAQ

Are my files uploaded?
No. This tool runs entirely in your browser tab. Files are read from your disk into memory and the result is generated locally.
Is it free? Are there limits or watermarks?
Free and open source (MIT). There are no file-size caps, daily quotas, accounts or watermarks.
Does it work offline?
Yes, once the page (and any engine it needs) has loaded, it keeps working without a connection thanks to the service worker cache.

Related tools

  • Remove Duplicate Rows: Delete repeated rows from Excel or CSV, matching on all columns or the ones you pick, ignoring case and spaces.
  • Split & Combine Columns: Split full names, addresses or codes into several columns, or join columns into one with any separator.
  • Merge Excel Files: Combine sheets from many Excel, ODS or CSV files into one workbook, or stack their rows into one table.
  • Merge Word Documents: Combine DOCX files into one, keeping text, tables, images and links, with page breaks between them.

OpenFile runs in your browser. Turn on JavaScript to use the tools.