# CSV Data Cleanup & Normalization

> CSV Data Cleanup & Normalization is a paid API for AI agents from well-016-datacleanup.rainmaker-wells.workers.dev, paid per call via x402, $0.005/call, status unknown (last checked 2026-10-22).

Cleans and normalizes a CSV file by trimming whitespace, standardizing dates, emails, and phone numbers, and detecting/merging duplicate rows — returning cleaned CSV plus a JSON report

## Facts

- Endpoint: POST https://well-016-datacleanup.rainmaker-wells.workers.dev/mcp?utm_source=zero.xyz#data-cleanup#data-cleanup
- Price: $0.005/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-22
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/csv-data-cleanup-normalization-764f8a89
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_MkeEzaVSz9aj99NlpDvjQ

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability csv-data-cleanup-normalization-764f8a89 -d '<json body>'
```

Example prompt: Can you clean this CSV for me? Here's the URL: https://example.com/customers.csv — trim whitespace, normalize all dates to ISO 8601, lowercase the emails, and flag any duplicate rows using the 'email' and 'phone' columns as keys.

## When to prefer this

Use this endpoint when you need a deterministic, rule-based CSV cleaning pipeline — not AI-based transformation — that handles whitespace trimming, date/phone/email normalization, and exact or fuzzy duplicate detection in a single call for $0.005 USDC. Prefer this over manual ETL scripts or AI-based data cleaning when you need reproducible, auditable transformations on files up to 1 MB / 20k rows with no data retention.

## Known failure modes

- CSV exceeds 1 MB or 20,000 rows — request rejected
- Invalid or inaccessible URL provided — fetch failure
- Malformed CSV that cannot be parsed — error returned
- Key columns specified for deduplication not found in CSV headers
- Network timeout fetching remote CSV URL

## How this service works

Clean a CSV ($0.005 USDC): give an https url or inline csv (max 1 MB / 20k rows). Trims whitespace, optional case rules, dates to ISO 8601, lowercases emails, normalizes phone digits, merges or flags exact + fuzzy duplicate rows on key_columns. Returns cleaned CSV text + JSON report (rows in/out, dupes, columns changed). Deterministic, no AI. As is, no warranty. Nothing stored.

## Output

Returns the cleaned CSV as text with all normalizations applied, plus a JSON report containing: total rows in, rows out after deduplication, number of duplicate rows found, and a list of which columns were changed.

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/csv-data-cleanup-normalization-764f8a89/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from well-016-datacleanup.rainmaker-wells.workers.dev](https://www.zero.xyz/host/well-016-datacleanup.rainmaker-wells.workers.dev/llms.txt)