Excel Data Cleaner FAQ

Common questions about trimming, duplicate removal, hidden characters, and export.

How to use

  1. Upload — Select Excel or CSV.
  2. Configure — Choose trim, blank rows, duplicates, hidden chars.
  3. Preview — Review report stats and sample issues.
  4. Export — Download cleaned file.

FAQ

Which formats are supported?

XLSX, XLSM, XLTX, XLTM, and CSV.

What are hidden characters?

Non-breaking spaces, zero-width spaces, BOM markers, and tabs that look like normal spaces.

How are duplicates detected?

Full-row comparison after optional trim and hidden-character fixes.

Can I preview before export?

Yes. Use Preview to see stats, sample issues, and cleaned sample rows.

Is CSV export available?

Yes. Select CSV in export format.

Does this validate every column type?

Only heuristic checks for likely email, phone, and date columns.