TinySandyFree Online Tools

CSV Cleaner

Tidy a messy CSV before you import it: trim stray spaces around values, remove duplicate and blank rows, drop columns that are completely empty, pad short rows and write consistent line endings and delimiters. A summary tells you exactly how many rows, columns and cells were changed.

Spreadsheet & CSV Runs in your browser

Clean Up a CSV File

Drag and drop a CSV file here, or click to browseAccepted: CSV, TSV, TXT. Up to 100 MB.

How to Use the CSV Cleaner

  1. Choose a CSV file or paste CSV text.
  2. Tick the clean-up steps you want; the defaults suit most imports.
  3. Choose the output delimiter and line endings.
  4. Press Clean CSV, review the summary and download cleaned.csv.

About This Tool

Anyone preparing a CSV for a database, CRM, mailing list or e-commerce import, and analysts cleaning exports from forms and older systems.

Input: CSV  ·  Output: CSV.

Features and Limitations

Features

  • Trims leading/trailing spaces and can collapse repeated inner spaces.
  • Removes exact duplicate rows after trimming (the header is never removed).
  • Drops completely empty rows, and columns that have no values below the header.
  • Pads short rows so every row has the same number of fields.
  • Writes standard CSV quoting, the delimiter you choose and CRLF or LF line endings; removes a UTF-8 BOM.

Limitations

  • Duplicate detection is exact (after trimming): rows that differ only in letter case are kept.
  • Values are not reformatted (dates, numbers and phone numbers are left as text).
  • Rows longer than the header are kept as they are; only short rows are padded.
  • Processing happens on your device, so very large files depend on your browser's available memory.

Example

The rows  Alice ,30 and Alice,30 become identical after trimming, so the second is removed as a duplicate.

Frequently Asked Questions

Is the header row ever removed?

No. The first row is always kept, even if a later row is identical to it.

Does it change my numbers or dates?

No. Only whitespace, empty rows and columns, duplicates, delimiters and line endings are touched.

Which line ending should I choose?

CRLF is the CSV standard and what Excel writes. LF is common on Linux and macOS and for developer tools. Most programs accept both.

Is my data private?

Yes. Cleaning happens in your browser and nothing is uploaded.

Related Tools

More like this: all Spreadsheet & CSV tools, all Files & Documents tools or the TinySandy home page.