Home / Tools / CSV & spreadsheet cleanup

CSV & data

CSV & spreadsheet cleanup

Clean messy CSV and Excel files: dates, phones, emails, and duplicates.

CSV & spreadsheet cleanup — Clean messy CSV and Excel files: dates, phones, emails, and duplicates.
A before and after of sheet-scrub cleaning a messy contact list: names cased, phones and dates made consistent, a duplicate row removed, and a bad email flagged.

Got a sheet full of extra spaces, mixed date styles, and repeat rows? These tools tidy the file and give you a clean table back.

What it does

  • Fixes messy column names and extra spaces.
  • Makes dates, emails, and phone numbers look the same.
  • Removes duplicate and empty rows.
  • Works on CSV and Excel (the Apify tool also reads JSON tables).

Get it

Pay per use · Apify · $0.0005 per clean row

Removed rows are free. Gives you a clean CSV and a short report of what changed.

For your computer · Gumroad · $9

sheet-scrub: one command for messy Excel and CSV files. Runs on your computer.