# Halowerk CSV & Data Cleaner

> Halowerk CSV & Data Cleaner is a paid API for AI agents from tools.halowerk.com, paid per call via x402, $0.002/call, status unknown (last checked 2026-09-15).

Accepts CSV text or a list of objects, auto-detects delimiters, normalizes column names, infers types (including German/English number and date formats), removes duplicates, blank rows, and empty columns, and returns a cleaned dataset with a per-column schema and change report.

## Facts

- Endpoint: POST https://tools.halowerk.com/v1/data/clean
- Price: $0.002/call
- Payment: x402
- Status: unknown
- Last checked: 2026-09-15
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/halowerk-csv-data-cleaner-147da6ba
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_vWdDUzYSUq8QUeyi5l_rl

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 halowerk-csv-data-cleaner-147da6ba -d '<json body>'
```

Example prompt: I have a messy CSV export with inconsistent column names, some duplicate rows, blank lines, and German number formats like '1.234,56' — can you clean it up, infer the column types, and tell me what changed?

## When to prefer this

Choose this endpoint when you need a single-step data cleaning pipeline that handles auto-delimiter detection, multilingual (German and English) number and date format normalization, deduplication, and schema inference together — especially when working with exports from German-language ERP or spreadsheet systems. Prefer this over manual ETL scripts or generic parsers when you need a structured change report and per-column type metadata without writing custom cleaning logic.

## Known failure modes

- Unparseable input — if the CSV is severely malformed and no delimiter can be detected, the endpoint may return an error or empty result
- All-duplicate dataset — if every row is a duplicate, the result may be an empty dataset
- Ambiguous type inference — columns with highly mixed content may be flagged as mixed-type without resolution
- Encoding issues — non-UTF-8 encoded files may cause parsing errors
- Empty input — submitting an empty string or empty array returns an error or trivial result

## How this service works

Nimmt CSV oder eine Liste von Objekten, erkennt das Trennzeichen selbst, vereinheitlicht Spaltennamen, deutet Typen einschliesslich deutscher und englischer Zahlformate und Datumsformate, entfernt Dubletten, leere Zeilen und leere Spalten und meldet jede Aenderung. Liefert zusaetzlich ein abgeleitetes Schema je Spalte mit Hinweis auf gemischte Typen.

## Output

Returns a cleaned version of the input dataset (as structured objects), a per-column schema indicating inferred data type and any mixed-type warnings, and a detailed change report listing every transformation applied — including duplicates removed, empty rows/columns dropped, column names normalized, and type interpretations used.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "csv": {
   "type": "string",
   "description": "CSV-Text, Trennzeichen wird erkannt"
  },
  "rows": {
   "type": "array",
   "items": {
    "type": "object"
   },
   "maxItems": 20000,
   "description": "Alternativ: Liste von Objekten"
  },
  "trim": {
   "type": "boolean",
   "default": true
  },
  "dedupe": {
   "type": "boolean",
   "default": true
  },
  "delimiter": {
   "type": "string",
   "description": "Trennzeichen erzwingen"
  },
  "drop_empty_rows": {
   "type": "boolean",
   "default": true
  },
  "drop_empty_columns": {
   "type": "boolean",
   "default": true
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/halowerk-csv-data-cleaner-147da6ba/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from tools.halowerk.com](https://www.zero.xyz/host/tools.halowerk.com/llms.txt)