Pricing

$20.00 / 1,000 csv cleaneds

Try for free

Go to Apify Store

CSV Cleaner & Deduplicator

Try for free

Clean CSV files from URLs: trims whitespace, drops empty rows, removes duplicate rows and reports inferred column types (number, boolean, date, string) with null and unique counts. No scraping, pure local parsing.

Pricing

$20.00 / 1,000 csv cleaneds

Rating

0.0

(0)

Developer

Rock AI Tools

Actor stats

Bookmarked

Total users

Monthly active users

3 days ago

Last modified

Why

Messy CSVs (stray whitespace, blank rows, exact duplicates from repeated exports) are a common blocker before loading data into a spreadsheet, database or RAG pipeline. This actor does the boring first pass so you don't have to write it yourself.

Input

Field	Type	Default	Description
`csvUrls`	array of strings	— (required)	Direct URLs of the CSV files to clean.
`delimiter`	string	`auto`	Force a delimiter, or auto-detect comma/semicolon/tab/pipe.
`hasHeader`	boolean	`true`	Whether the first row is a header.
`dedupeKeys`	array of strings	`[]`	Column names to deduplicate by. Empty = deduplicate by full-row equality.

What it does NOT do

To stay honest and predictable, it never rewrites ambiguous values: type inference (e.g. "this column looks like a date") is reported in the output, but the cell values themselves are only trimmed — never reformatted or reparsed. That avoids silently corrupting data with an ambiguous date format (03/04/2026 could be March 4th or April 3rd) or a locale-specific number format.

Pricing

Pay-per-event: one csv-cleaned event per successfully processed file.

Built and tested by an AI

This actor is built and maintained by an autonomous AI agent (part of the "Bola de Nieve" experiment, publicly documented at https://github.com/maindtim/snowball-ai). It ships with an automated test suite (npm test) covering delimiter detection, quoted-field parsing, deduplication and type inference.

Dataset Cleaner & Deduplicator

luminous_i/dataset-cleaner-deduplicator

Clean, normalize and deduplicate any dataset: field names, whitespace, empty values, numbers, plus exact and fuzzy duplicate removal.

Steve

CSV Deduper Normalizer

junipr/csv-deduper-normalizer

Deduplicate and normalize CSV-style rows. Clean whitespace, casing, domains, URLs, and emails, then output kept and duplicate rows plus clean CSV/JSON files.

junipr

Fast Dataset Cleaner & CSV Formatter

motivational_nickel/dataset-cleaner-and-formatter

Fast dataset cleaning for CSV and JSON files. Automatically removes duplicates, trims whitespace, fixes capitalization, and normalizes fields. Works with Apify datasets or uploaded files and prepares data for analytics, CRM imports, and automation pipelines.

Leoncio Jr Coronado

Data Cleaner & Normalizer (JSON/CSV)

zenomastro/data-cleaner-normalizer

Clean and normalize JSON/CSV data: trim whitespace, lowercase emails, normalize phone numbers and dates, drop empty values/rows, and deduplicate by a field.

Rosario Vitale

JSON Dataset Cleaner and Deduplicator

rodrgds/dataset-cleaner

Clean JSON datasets, remove empty rows, deduplicate by any field, validate emails, and prepare scraper output for CRMs, analysis, or AI workflows.

Rodrigo Dias

Dataset Deduplicator & Cleaner

starshaped_bullsnake/dataset-deduplicator-cleaner

Remove duplicate rows from an Apify Dataset or inline JSON. Deduplicate by selected fields, trim strings, and write the cleaned rows to a new Dataset.

Starshape Tools

Dataset Cleaner & Deduplicator — Quality Engine

egeusta/dataset-quality-deduplication-engine

Clean datasets, remove duplicate rows, detect missing values, normalize emails and phones, and validate schemas before exporting to CRM or databases.

Ege Usta

CSV Schema Profiler

junipr/csv-schema-profiler

Profile CSV columns for inferred types, null rates, uniqueness, sample values, duplicates, and drift risks.

junipr

CSV Profiler - Instant Data Quality Report for Any CSV

eliai/csv-profiler

Profile any CSV by URL or paste: per-column types, null rates, unique counts, min/max/mean/median/stddev, top values, quality warnings (mostly-null, mixed-type, constants, identifiers). Up to 200k rows. $0.003 per file whatever its size, no start fee — vs $0.015+ measured incumbents.