# data-cleanup: fix a messy CSV before you load it

> data-cleanup: fix a messy CSV before you load it is a paid MCP server for files and documents. Clean a messy CSV in one call: trim, ISO dates, tidy emails and phones, merge dupes. It runs as a hosted remote server, so there is nothing to install locally.

- **Kind:** MCP server
- **Pricing:** Paid
- **Platforms:** API, Web
- **Website:** https://well-016-datacleanup.rainmaker-wells.workers.dev/openapi.json
- **MCP Registry name:** dev.workers.rainmaker-wells.well-016-datacleanup/data-cleanup
- **Categories:** files and documents, analytics and data
- **Listing updated:** 2026-11-15

## About

Processing is deterministic and uses no AI. Input is an https link to a CSV or inline text, up to 1 MB or 20,000 rows. The response is the cleaned CSV plus a JSON change report counting rows in and out, exact and fuzzy duplicates and cells changed.

Most behaviour is set through parameters. key_columns picks the columns used to detect duplicates, dedupe chooses merge, flag or none, and fuzzy matching defaults to a 0.92 similarity threshold. Dates become ISO 8601, with date_order set to mdy or dmy for ambiguous values. Phones are reduced to digits or E.164, emails are lowercased, and case_rules can force lower, upper or title case per column.

A call costs $0.005 in USDC on Base through x402 and is settled only on success. The tool is also exposed as data-cleanup over streamable HTTP MCP. The operator says nothing is stored and provides it as is.

## Features

- **Duplicate merge or flag:** Finds exact and fuzzy duplicate rows on chosen key columns and merges or flags them.
- **ISO 8601 dates:** Converts date columns, with a choice of month-first or day-first for ambiguous values.
- **Email and phone tidying:** Lowercases emails and normalises phones to digits or E.164.
- **Per-column case rules:** Applies lower, upper or title case to named columns.
- **JSON change report:** Reports rows in and out, duplicate counts and cells changed.
- **Deterministic processing:** The operator says it uses no AI and stores nothing.

## Good for

- Prepare a spreadsheet export before a CRM import
- Deduplicate a mailing list by email
- Standardise dates before loading a database
- Clean a CSV before charting it

## Install

### Claude Code (Terminal)

```sh
claude mcp add --transport http data-cleanup https://well-016-datacleanup.rainmaker-wells.workers.dev/mcp
```

### Claude Desktop (Settings → Connectors → Add custom connector)

```sh
https://well-016-datacleanup.rainmaker-wells.workers.dev/mcp
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "data-cleanup": {
      "url": "https://well-016-datacleanup.rainmaker-wells.workers.dev/mcp"
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "data-cleanup": {
      "type": "http",
      "url": "https://well-016-datacleanup.rainmaker-wells.workers.dev/mcp"
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "data-cleanup": {
      "serverUrl": "https://well-016-datacleanup.rainmaker-wells.workers.dev/mcp"
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "data-cleanup": {
      "type": "http",
      "url": "https://well-016-datacleanup.rainmaker-wells.workers.dev/mcp"
    }
  }
}
```

## Tools

- `data-cleanup`: Cleans a CSV and returns the cleaned file with a JSON change report.

## FAQ

### What size of file can it handle?

Up to 1 MB or 20,000 rows, supplied as inline text or a public https URL.

### Does it use AI?

No. The operator describes it as deterministic.

### What does it cost?

$0.005 per call in USDC on Base via x402, settled only on success.

### Can it catch near-duplicates?

Yes. Fuzzy matching is on by default with a 0.92 similarity threshold you can change between 0.5 and 1.

### Is data-cleanup: fix a messy CSV before you load it free?

No. data-cleanup: fix a messy CSV before you load it is a paid product.

### How do I add data-cleanup: fix a messy CSV before you load it to Claude Code?

Run this command in your terminal: claude mcp add --transport http data-cleanup https://well-016-datacleanup.rainmaker-wells.workers.dev/mcp

### What are the best alternatives to data-cleanup: fix a messy CSV before you load it?

The closest alternatives to data-cleanup: fix a messy CSV before you load it are Agent-Native Analytics, Google Ads + Meta Ads + SEO/GEO MCP, Tapetide - Indian Stock Market MCP, World Monitor and CompanyData.

## Alternatives

- [Agent-Native Analytics](https://ai-powered.com/mcp/agent-native-analytics): Agent-Native Analytics is an open-source MCP server for analytics and data.
- [Google Ads + Meta Ads + SEO/GEO MCP](https://ai-powered.com/mcp/google-ads-meta-ads-seo-geo-mcp): Google Ads + Meta Ads + SEO/GEO MCP is a freemium MCP server for marketing and seo.
- [Tapetide - Indian Stock Market MCP](https://ai-powered.com/mcp/tapetide-indian-stock-market-mcp): Tapetide - Indian Stock Market MCP is a freemium MCP server for finance and payments.
- [World Monitor](https://ai-powered.com/mcp/world-monitor): World Monitor is a freemium MCP server for analytics and data.
- [CompanyData](https://ai-powered.com/mcp/companydata): CompanyData is a paid MCP server for analytics and data.
- [ASTra](https://ai-powered.com/mcp/astra): ASTra is a freemium MCP server for files and documents.
- [ChartAnt](https://ai-powered.com/mcp/chartant): ChartAnt is a freemium MCP server for design and media.
- [Quantivex Research](https://ai-powered.com/mcp/quantivex-research): Quantivex Research is a free MCP server for finance and payments.

---
Source: https://ai-powered.com/mcp/data-cleanup-fix-a-messy-csv-before-you-load-it
