Pricing

from $2.00 / 1,000 cleaned records

Try for free

Go to Apify Store

Dataset Cleaner & Exporter

Try for free

Returns a deduplicated, flattened and cleaned copy of any Apify dataset, file or Google Sheet by URL, or JSON array, plus CSV and Excel files, named-dataset append and webhook delivery. Inputs: source, dedup keys, flatten, cleaning options. Agent-ready: pay per event (x402, MCP), per cleaned record.

Pricing

from $2.00 / 1,000 cleaned records

Rating

0.0

(0)

Developer

Adam Pearce

Actor stats

Bookmarked

Total users

Monthly active users

2 hours ago

Last modified

Categories

Developer tools

Automation

Integrations

You can access the Dataset Cleaner & Exporter 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

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    "data": [
12        {
13            "Company Name": "  Acme Corp  ",
14            "Email": "SALES@ACME.COM",
15            "Phone": "+1 (555) 123-4567",
16            "Website": "https://Acme.com/"
17        },
18        {
19            "Company Name": "Acme Corp",
20            "Email": "sales@acme.com",
21            "Phone": "555.123.4567",
22            "Website": "https://acme.com"
23        },
24        {
25            "Company Name": "Globex Inc",
26            "Email": "info@globex.io",
27            "Phone": "+1 555 987 6543",
28            "Website": "https://globex.io/",
29            "Details": {
30                "founded": 1998,
31                "tags": [
32                    "b2b",
33                    "logistics"
34                ]
35            }
36        }
37    ],
38    "dedupKeys": [
39        "Email"
40    ]
41};
42
43// Run the Actor and wait for it to finish
44const run = await client.actor("nerolabs/dataset-cleaner-exporter").call(input);
45
46// Fetch and print Actor results from the run's dataset (if any)
47console.log('Results from dataset');
48console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
49const { items } = await client.dataset(run.defaultDatasetId).listItems();
50items.forEach((item) => {
51    console.dir(item);
52});
53
54// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs

Dataset Cleaner & Exporter: Dedupe, Flatten, CSV/XLSX API in JavaScript

The Apify API client for JavaScript is the official library that allows you to use Dataset Cleaner & Exporter 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:

Dataset Cleaner & Exporter API in Python

Dataset Cleaner & Exporter API through CLI

Dataset Cleaner & Exporter OpenAPI definition

Dataset Cleaner & Exporter API

Dataset Aggregate, Group By & Pivot

nerolabs/dataset-aggregate-pivot

Returns GROUP BY and pivot tables for any Apify dataset, file or Google Sheet by URL, or JSON array: count, sum, average, min, max, median per group, date buckets, pivot columns. Exports CSV/Excel, appends to a named dataset, posts to a webhook. Agent-ready: pay per event (x402, MCP), per input row.

Adam Pearce

Dataset Filter & Transform

nerolabs/dataset-filter-transform

Returns rows of any Apify dataset, CSV/Excel/JSON file URL or Google Sheet that pass filter rules (25 operators, AND/OR) after transforms (rename, cast, compute, regex, dates, replace, split, hash), then sort, dedupe, limit, export CSV/Excel or webhook. Agent-ready: pay per event (x402, MCP).

Adam Pearce

CSV & Excel Data Quality Cleaner

automation-lab/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.

Stas Persiianenko

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

Dataset Join & Merge (VLOOKUP for Datasets)

nerolabs/dataset-join-merge

Returns two Apify datasets, files or Google Sheets by URL, or JSON arrays joined on key fields like SQL or VLOOKUP: left, inner, right, full and anti joins plus union, with CSV/Excel export, named-dataset append and webhook delivery. Agent-ready: pay per event (x402, MCP), per output row.

Adam Pearce

Google Dataset Search Scraper

searchapi/google-dataset-search-scraper

Extracts dataset titles, repositories, publishers, descriptions, formats, licenses, update dates, and dataset links from Google Dataset Search.

Search API

Dataset Charts & Report (Chart Images + PDF from Any Data)

nerolabs/dataset-charts-report

Turns any Apify dataset, CSV/Excel/JSON file URL or JSON array into chart images (bar, line, area, pie, scatter as PNG and SVG) and an optional PDF or HTML report with KPIs and a plain-English summary. Define charts by field names. Charged per chart and per report; agent-ready via x402 and MCP.

Adam Pearce

CSV File to Dataset

lukaskrivka/csv-file-to-dataset

Upload a local or remote CSV/text file and convert it to Apify Dataset for further use.

Lukáš Křivka

189

Data.gov Dataset Scraper

parseforge/data-gov-scraper

Scrapes Data.gov catalog search results by keyword or URL. Returns each dataset as a flat row with title, description, publisher, formats, and metadata. Export to CSV, JSON, Excel, or XML.