Pricing

Pay per event

CSV & Excel Data Quality Cleaner

Clean CSV and Excel files under explicit rules, normalize columns and values, flag or remove duplicates, and export cleaned rows plus a structured validation report.

Pricing

Pay per event

Rating

0.0

(0)

Developer

Stas Persiianenko

Actor stats

Bookmarked

Total users

Monthly active users

4 days ago

Last modified

Categories

Developer tools

You can access the CSV & Excel Data Quality 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 API & Integrations in Apify Console.

Python

JavaScript

CLI

OpenAPI

HTTP

MCP

1from apify_client import ApifyClient
2
3# Initialize the ApifyClient with your Apify API token
4# Replace '<YOUR_API_TOKEN>' with your token.
5client = ApifyClient("<YOUR_API_TOKEN>")
6
7# Prepare the Actor input
8run_input = {
9    "csvText": """Customer ID, Full Name ,Email,Amount,Order Date
10C-001, Alice Smith ,ALICE@ACME.COM,1250.50,2026-08-01
11C-001,Alice Smith,alice@acme.com,1250.50,2026-08-01""",
12    "format": "auto",
13    "normalizeColumnNames": True,
14    "trimWhitespace": True,
15    "emptyAsNull": True,
16    "columnRules": [
17        {
18            "column": "amount",
19            "type": "number",
20            "required": True,
21            "min": 0,
22        },
23        {
24            "column": "order_date",
25            "type": "date",
26            "required": True,
27        },
28        {
29            "column": "email",
30            "type": "string",
31            "pattern": "^[^@\\s]+@[^@\\s]+\\.[^@\\s]+$",
32        },
33    ],
34    "deduplicateBy": [
35        "customer_id",
36        "order_date",
37    ],
38    "duplicateAction": "flag",
39    "caseInsensitiveDuplicates": True,
40    "maxRows": 20,
41}
42
43# Run the Actor and wait for it to finish
44run = client.actor("automation-lab/csv-excel-data-quality-cleaner").call(run_input=run_input)
45
46# Fetch and print Actor results from the run's dataset (if there are any)
47print(f"💾 Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}")
48for item in client.dataset(run.default_dataset_id).iterate_items():
49    print(item)
50
51# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

CSV & Excel Data Quality Cleaner for Analytics API in Python

The Apify API client for Python is the official library that allows you to use CSV & Excel Data Quality Cleaner API in Python, providing convenience functions and automatic retries on errors.

Install the apify-client

$pip install apify-client

Other API clients include:

CSV & Excel Data Quality Cleaner API in JavaScript

CSV & Excel Data Quality Cleaner API through CLI

CSV & Excel Data Quality Cleaner OpenAPI definition

CSV & Excel Data Quality Cleaner API

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

Scraped Data Cleaner & Converter (No-Code CSV/JSON Tool) Rental

m3web/scraped-data-cleaner-rental

Clean and organize scraped .json or .csv data — no coding required. Remove duplicates, empty rows, unwanted columns, and sort by any field. Cleaned results are pushed to your Apify dataset. Perfect for marketers, researchers, and no-code workflows.

M3Web

5.0

Scraped Data Cleaner & Converter (No-Code CSV/JSON Tool) - PPE

m3web/scraped-data-cleaner-ppe

Clean and organize scraped .json or .csv data — no coding required. Remove duplicates, empty rows, unwanted columns, and sort by any field. Cleaned results are stored in Apify's Key-Value Store. Perfect for marketers, researchers, and no-code workflows.

M3Web

Lunar Data Cleaner

liuyu.digitaltwin/lunar-data-cleaner

Clean CSV, Excel, or JSON files with audit trails, PII masking, and budget control. Remove duplicates, fix missing values, standardize dates/numbers, and get quality reports.

Yu Liu

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

CSV Data Quality Report

daniz.k/csv-data-quality-report

Generate a compact data quality report from CSV input, including schema, missing values, numeric summaries, and a data preview.

Xiangyu Liu

CSV & Excel Merger / Splitter - Bulk Dataset Optimizer

thecfmarketing/csv-xlsx-dataset-merger-pattern-splitter

Combine multiple CSV & XLSX files, remove duplicate leads based on email/phone, standardize columns, and split large datasets into smaller chunks.

sadique shaikh

Data Cleaning & Deduplication

moving_beacon-owner1/data-cleaning-deduplication

Clean, normalize, deduplicate, and profile messy datasets using only the records you provide. Standardize fields, remove duplicates, flag invalid records, handle empty values, and generate an auditable data-quality summary—with no scraping or proxies required.

Jamshaid Arif

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

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.