Data Cleaner — messy CSV/Excel/JSON to clean typed data avatar

Data Cleaner — messy CSV/Excel/JSON to clean typed data

Pricing

Pay per event

Go to Apify Store
Data Cleaner — messy CSV/Excel/JSON to clean typed data

Data Cleaner — messy CSV/Excel/JSON to clean typed data

Clean, deduplicate, and type-infer CSV, Excel, and JSON files from URLs. Returns a quality report, preview rows, and a download link to the cleaned CSV. Built for AI agents and data pipelines.

Pricing

Pay per event

Rating

0.0

(0)

Developer

Dos

Dos

Maintained by Community

Actor stats

0

Bookmarked

1

Total users

0

Monthly active users

19 hours ago

Last modified

Share

Data Cleaner — messy CSV/Excel/JSON to clean, typed data

Point it at data files; get back deduplicated, whitespace-trimmed, type-inferred data plus an honest quality report — and a direct download link to the cleaned CSV. The un-glamorous work every data pipeline and AI agent needs done before anything else works.

What it does per file

  • Reads CSV (separator auto-detected), Excel (.xlsx, any sheet), JSON (records or JSON-lines)
  • Normalizes headers; trims whitespace; blanks become nulls
  • Drops empty rows/columns; removes duplicate rows
  • Infers column types (numbers, dates) when >=90% of values parse
  • Outputs: quality_report, preview_rows (first 20), cleaned_csv_url (full file)

Pricing

Pay-per-event: a small fee per file plus a micro-fee per 1,000 cleaned rows. No subscription.

Limits

Up to 50 files/run, 100 MB and 250,000 rows per file. Failures return status: "error" so pipelines can branch.

Other actors by amanatools