Pricing

from $1.00 / 1,000 item cleaneds

Try for free

Go to Apify Store

Data Cleaner & Normalizer API — JSON/CSV Dedupe & Clean

Try for free

Data Cleaner API for JSON/CSV normalization, deduplication and CRM cleanup. Trim or collapse whitespace, lowercase emails, normalize phones and ISO dates, remove empty fields or rows, deduplicate by key and process nested objects with bounded batch limits.

Pricing

from $1.00 / 1,000 item cleaneds

Rating

0.0

(0)

Developer

Rosario Vitale

Actor stats

Bookmarked

Total users

Monthly active users

3 days ago

Last modified

Categories

Developer tools

Automation

Items (JSON array)

items

Required

The records to clean — a JSON array of objects (maximum 10,000 per run).

Type:array

Max. items:10000

Trim whitespace

trimWhitespace

Optional

Trim leading/trailing spaces from all string values.

Type:boolean

Default:true

Collapse inner spaces

collapseSpaces

Optional

Collapse runs of inner whitespace into a single space.

Type:boolean

Default:true

Lowercase emails

lowercaseEmails

Optional

Detect email-looking values and lowercase them.

Type:boolean

Default:true

Clean phone numbers

cleanPhones

Optional

Strip spaces, dashes and brackets from phone-looking values (keeps a leading +).

Type:boolean

Default:true

Normalize dates to ISO

normalizeDates

Optional

Best-effort convert date-looking values to ISO format (YYYY-MM-DD).

Type:boolean

Default:false

Remove empty fields

removeEmptyValues

Optional

Drop keys whose value is null or an empty string.

Type:boolean

Default:false

Drop empty rows

dropEmptyRows

Optional

Skip records that have no remaining fields after cleaning.

Type:boolean

Default:true

Deduplicate by field

dedupeKey

Optional

Optional field name. If set, keeps only the first record for each non-empty unique value of this field (e.g. "email").

Type:string

Clean nested values

recursive

Optional

Apply the same string cleaning rules recursively inside nested objects and arrays.

Type:boolean

Default:true

Data Cleaner

parsebird/data-cleaner

Clean messy data — remove nulls, normalize case, trim whitespace, format phone numbers and emails, extract domains, convert types, and more. Works with Apify datasets or direct JSON input.

ParseBird

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

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

amanatools/data-cleaner

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.

Dos

🏠 Address Normalizer - Parse, Canonicalise & Dedupe Addresses

that_red_bird/address-normalizer

⚡ Parse freeform addresses into unit, house number, street name/type, city, region, postcode and country — for US, UK, DE and FR patterns.

mohamed alaya

JSON Data Cleaner & Normalizer

urban_souffle/mf-99-data-normalization-for-unified-job-market

Clean, normalize, trim, lowercase keys, and remove duplicate JSON records. Ideal for APIs, automation workflows, ETL pipelines, and dataset preparation.

Luca Gallifuoco

JSON to JSONL Converter

urban_souffle/mf-229-json-to-jsonl

Convert arrays of JSON objects into JSONL / NDJSON text with one JSON object per line. Ideal for APIs, bulk imports, automation, ETL, and streaming workflows.

Luca Gallifuoco

CSV Cleaner

urban_souffle/mf-201-csv-cleaner

Parse CSV text safely, normalize cells, and return structured JSON rows for APIs, automation, ETL pipelines, and data processing workflows.

Luca Gallifuoco

JSON to CSV Converter

urban_souffle/mf-225-json-to-csv

Convert structured JSON arrays into clean CSV output with explicit column selection and delimiter options. Ideal for APIs, automation, exports, and ETL workflows.

Luca Gallifuoco

B2B Leads Cleaner

abdelwarith/b2b-leads-cleaner

Clean, deduplicate, and enrich B2B leads from JSON, CSV, or Excel. Remove duplicates, normalize phones to E.164, filter disposable emails, and enrich with company website data. 3 tiers starting at $4 per 1,000 leads.

Khaled Attya

Product Data Normalizer & Price Cleaner

victor187/product-data-normalizer

Cleans and standardizes messy scraped product data: parses prices from any format, detects currency, normalizes stock status. Built for e-commerce, price monitoring, price comparison and web scraping pipelines that need clean structured JSON, not raw messy text.