Pricing

from $1.49 / 1,000 items cleaneds

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.

Pricing

from $1.49 / 1,000 items cleaneds

Rating

0.0

(0)

Developer

ParseBird

Actor stats

Bookmarked

Total users

Monthly active users

3 days ago

Last modified

Categories

Agents

Developer tools

Automation

You can access the Data Cleaner programmatically from your own applications by using the Apify API. You can also choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in Integrations settings in Apify Console.

Python

JavaScript

CLI

OpenAPI

HTTP

MCP

1import { ApifyClient } from 'apify-client';
2
3// Initialize the ApifyClient with your Apify API token
4// Replace the '<YOUR_API_TOKEN>' with your token
5const client = new ApifyClient({
6    token: '<YOUR_API_TOKEN>',
7});
8
9// Prepare Actor input
10const input = {
11    "jsonData": [
12        {
13            "name": "  john doe  ",
14            "email": "  JOHN@EXAMPLE.COM  "
15        },
16        {
17            "name": "JANE SMITH",
18            "email": "Jane.Smith@Company.IO"
19        },
20        {
21            "name": "bob wilson",
22            "email": "bob@test.com"
23        }
24    ],
25    "operations": [
26        {
27            "field": "email",
28            "action": "format_email"
29        },
30        {
31            "field": "name",
32            "action": "trim_whitespace"
33        },
34        {
35            "field": "name",
36            "action": "normalize_case",
37            "options": {
38                "case": "title"
39            }
40        }
41    ]
42};
43
44// Run the Actor and wait for it to finish
45const run = await client.actor("parsebird/data-cleaner").call(input);
46
47// Fetch and print Actor results from the run's dataset (if any)
48console.log('Results from dataset');
49console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
50const { items } = await client.dataset(run.defaultDatasetId).listItems();
51items.forEach((item) => {
52    console.dir(item);
53});
54
55// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs

Data Cleaner — Clean, Normalize & Format Scraped Data API in JavaScript

The Apify API client for JavaScript is the official library that allows you to use Data Cleaner API in JavaScript or TypeScript, providing convenience functions and automatic retries on errors.

Install the apify-client

$npm install apify-client

Other API clients include:

Data Cleaner API in Python

Data Cleaner API through CLI

Data Cleaner OpenAPI definition

Data Cleaner API

CRM Lead Data Cleaner (Email/Phone Validator + Dedup)

motivational_nickel/universal-data-cleaner

Turn messy CSV or Excel leads into clean, validated, CRM-ready data. Fix Excel E+11 phone numbers, validate emails, remove duplicates, and score lead quality (HIGH, MEDIUM, LOW). Built for sales teams, lead gen agencies, and automation workflows.

Leoncio Jr Coronado

Superclean URLs

superlativetech/superclean-urls

Clean messy URLs from lead exports. Remove 60+ tracking parameters (utm_*, fbclid, gclid), normalize format, extract domains, and optionally verify URLs are reachable. Perfect for cold email personalization and CRM data hygiene.

Superlative

Data Deduplicator

parsebird/dataset-deduplicator

Merge and deduplicate Apify datasets by any field combination. Remove duplicate rows while keeping the first or last occurrence. Supports case-insensitive matching and whitespace trimming.

ParseBird

Dataset Deduplicator

automation-lab/dataset-dedup

Merge and deduplicate Apify datasets by any field combination. Remove duplicates, keep first or last occurrence. Case-insensitive matching, whitespace trimming. Pay per 1K items processed.

Stas Persiianenko

ai-data-cleaner-classifier

keratogenous_surgeon/dataset-ai-cleaner

Clean, normalize, deduplicate, and classify JSON, CSV, or Apify datasets using rules or OpenAI models. Built for automation pipelines, data preparation, and AI workflows. Supports dataset chaining, cost controls, and safe fallbacks.

King Shepherd

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

Text Case Converter

automation-lab/text-case-converter

This actor converts text between multiple case formats: UPPER CASE, lower case, Title Case, camelCase, PascalCase, snake_case, kebab-case, and CONSTANT_CASE. Automatically splits words from any input format. Useful for data transformation, code generation, and bulk text processing.

Stas Persiianenko

Phone Validator - Validation, Normalize, Format & Detect Type

apizy/phone-validator-formatter

Validate phone numbers in bulk, normalize to E.164, format for display, detect country by code, and identify number type. Supports local numbers with defaultCountry and international numbers like +1, +44, etc. Great for CRM cleanup, lead validation, and contact enrichment.

Apizy

5.0

Superclean Phone Numbers

superlativetech/superclean-phone-numbers

Format, parse, and clean phone numbers in bulk. Normalize to E.164, International, or National format. Validates numbers, detects type (mobile/landline/toll-free), handles vanity numbers like 1-800-FLOWERS, and extracts extensions. For CRM exports and lead data cleanup.

Superlative

Justia Case Law Scraper

parseforge/justia-case-law-scraper

Collect US federal case law in a clear, structured format for legal research, monitoring, and reporting. Get case names, docket numbers, courts, decision dates, summaries, and opinion text by year range or direct URL, then export clean results ready for analysis and legal intelligence workflows.