Home / Tools / CSV & spreadsheet cleanup

CSV & data

CSV & spreadsheet cleanup

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

About $1 per 2,000 clean rows.

Try it on Apify
Buy on Gumroad
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).

Before and after

Messy CSV

 Full Name ,Email,Phone #,Signup Date,State
ada LOVELACE,Ada.Lovelace@Example.com ,512.555.0100,03/04/2026,tx
Grace  Hopper,grace@example.com,1-512-555-0199,"March 5th, 2026",TX
ada LOVELACE,ada.lovelace@example.com,(512) 555-0100,4 Mar 2026,tx
,,,,

Clean CSV (duplicate and empty rows gone)

full_name,email,phone,signup_date,state
Ada Lovelace,ada.lovelace@example.com,(512) 555-0100,2026-03-04,TX
Grace Hopper,grace@example.com,(512) 555-0199,2026-03-05,TX

From sheet-scrub/samples/contacts-messy.csv and contacts-clean.csv.

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.

Try it on Apify

For your computer · Gumroad · $9

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

Buy on Gumroad

FAQ

What does this tool do?

Clean messy CSV and Excel files: dates, phones, emails, and duplicates. 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 does it cost?

Pay per use on Apify costs $0.0005 per clean row. Removed rows are free. Gives you a clean CSV and a short report of what changed. For your computer on Gumroad costs $9. sheet-scrub: one command for messy Excel and CSV files. Runs on your computer.

Will you see my files?

The download tools run on your computer, so those files stay with you. The Apify tools run in your own Apify account. This website does not take uploads.