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

# Set API token
$API_TOKEN=<YOUR_API_TOKEN>

# Prepare Actor input
$cat > input.json << 'EOF'
<{
<  "csvText": "Customer ID, Full Name ,Email,Amount,Order Date\nC-001, Alice Smith ,ALICE@ACME.COM,1250.50,2026-08-01\nC-001,Alice Smith,alice@acme.com,1250.50,2026-08-01",
<  "format": "auto",
<  "normalizeColumnNames": true,
<  "trimWhitespace": true,
<  "emptyAsNull": true,
<  "columnRules": [
<    {
<      "column": "amount",
<      "type": "number",
<      "required": true,
<      "min": 0
<    },
<    {
<      "column": "order_date",
<      "type": "date",
<      "required": true
<    },
<    {
<      "column": "email",
<      "type": "string",
<      "pattern": "^[^@\\s]+@[^@\\s]+\\.[^@\\s]+$"
<    }
<  ],
<  "deduplicateBy": [
<    "customer_id",
<    "order_date"
<  ],
<  "duplicateAction": "flag",
<  "caseInsensitiveDuplicates": true,
<  "maxRows": 20
<}
<EOF

# Run the Actor using an HTTP API
# See the full API reference at https://docs.apify.com/api/v2
$curl "https://api.apify.com/v2/actors/automation-lab~csv-excel-data-quality-cleaner/runs?token=$API_TOKEN" \
<  -X POST \
<  -d @input.json \
<  -H 'Content-Type: application/json'

CSV & Excel Data Quality Cleaner for Analytics API

Below, you can find a list of relevant HTTP API endpoints for calling the CSV & Excel Data Quality Cleaner Actor. For this, you’ll need an Apify account. Replace <YOUR_API_TOKEN> in the URLs with your Apify API token, which you can find under API & Integrations in Apify Console. For details, see the API reference.

Run Actor

POST
https://api.apify.com/v2/actors/automation-lab~csv-excel-data-quality-cleaner/runs?token=<YOUR_API_TOKEN>

Note: By adding the method=POST query parameter, this API endpoint can be called using a GET request and thus used in third-party webhooks. Please refer to our Run Actor API documentation.

Run Actor synchronously and get dataset items

POST
https://api.apify.com/v2/actors/automation-lab~csv-excel-data-quality-cleaner/run-sync-get-dataset-items?token=<YOUR_API_TOKEN>

Note: This endpoint supports both POST and GET request methods. However, only the POST method allows you to pass input data. For more information, please refer to our Run Actor synchronously and get dataset items API documentation.

Get Actor

GET
https://api.apify.com/v2/actors/automation-lab~csv-excel-data-quality-cleaner?token=<YOUR_API_TOKEN>

For more information, please refer to our Get Actor API documentation.

Actors can be used to scrape web pages, extract data, or automate browser tasks. Use the CSV & Excel Data Quality Cleaner API programmatically via the Apify API.

You can choose from:

CSV & Excel Data Quality Cleaner API in Python

CSV & Excel Data Quality Cleaner API in JavaScript

CSV & Excel Data Quality Cleaner API through CLI

CSV & Excel Data Quality Cleaner OpenAPI definition

You can start CSV & Excel Data Quality Cleaner with the Apify API by sending an HTTP POST request to the Run Actorendpoint. An Actor’s input and its content type can be passed as a payload of the POST request, and additional options can be specified using URL query parameters. The CSV & Excel Data Quality Cleaner is identified within the API by its ID, which is the creator’s username and the name of the Actor.

When the CSV & Excel Data Quality Cleaner run finishes you can list the data from its default dataset(storage) via the API or you can preview the data directly on Apify Console.

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.