CSV & Excel Data Cleaner - Dedupe, Fix Dates, Emails & Phones avatar

CSV & Excel Data Cleaner - Dedupe, Fix Dates, Emails & Phones

Pricing

from $0.50 / 1,000 clean row saveds

Go to Apify Store
CSV & Excel Data Cleaner - Dedupe, Fix Dates, Emails & Phones

CSV & Excel Data Cleaner - Dedupe, Fix Dates, Emails & Phones

Clean CSV, Excel or JSON tables. Fix messy headers, trim spaces, make dates, emails and phones match, and remove duplicate and empty rows. $0.0005 per clean row. Removed rows are free.

Pricing

from $0.50 / 1,000 clean row saveds

Rating

0.0

(0)

Developer

Tidy Byte Tools

Tidy Byte Tools

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

3 days ago

Last modified

Categories

Security

Limited permissions

Share

Clean CSV, Excel or JSON tables. Fix messy headers, trim spaces, make dates, emails and phones match, and remove duplicate and empty rows. $0.0005 per clean row. Removed rows are free.

What it does

  • Fixes messy column names (spaces, odd symbols, repeats).
  • Trims extra spaces and turns 'null' or 'N/A' into blanks.
  • Makes dates look the same: YYYY-MM-DD.
  • Makes emails lowercase and phones look the same.
  • Removes duplicate rows and empty rows.
  • Gives you a clean CSV file and a short report of what changed.

Price

You pay $0.0005 per clean row saved (One row in the cleaned table. Duplicate and empty rows we remove are free.) There is no start fee from us. Apify adds its normal small platform cost. Set a max cost for the run and we stop there. We never charge for work we did not save.

How to use

  1. Add links or paste your data.
  2. Click Start.
  3. Get results in the Output tab, or download them as CSV, Excel or JSON.

Input

  • File links: Links to CSV, TSV, Excel (.xlsx) or JSON files.
  • Or paste CSV: Paste CSV text here.
  • Remove duplicate rows: Remove rows that match another row (not case sensitive).
  • Match duplicates on these columns: Leave empty to match whole rows. Example: email
  • Remove empty rows: Remove rows with nothing in them.
  • Dates are written: How to read dates like 03/04/2026. Output is always YYYY-MM-DD.
  • Phone style: How to write phone numbers.

Good to know

  • Files up to 50 MB each.
  • Your data is only used for your run.
  • Made by Tidy Byte Tools. Questions? Open an issue on this Actor's page.