Zero-touch tables

A table-processing tool for AI agents and people. Drop a file, get a clean table. Or call the cleaning API directly.

Data Cleaner takes a messy table and returns a clean one. It infers the type of every column, such as date, number, currency, address or free text, and rewrites each cell in a canonical form, keeping a status per cell so that nothing is changed silently. The same engine answers over a REST API, one value or one column at a time, so a script, a spreadsheet or an agent can use it without the browser.

Two ways to use it

In the browser

Drag a CSV or Excel file onto the page. The columns are typed, the cells are cleaned, and the result is shown as a table you can inspect, correct and download.

Over the REST API

Every endpoint lives under https://data-cleaner.com/clean/v1. Send a value or a column, get JSON back. No key is needed to start; a key lifts the per-request limit and unlocks the datetime endpoints. The OpenAPI document at https://data-cleaner.com/clean/v1/openapi.json is the reference.

curl -G https://data-cleaner.com/clean/v1/value --data-urlencode "value=1.1.2024"

Endpoints

MethodPathWhat it doesKey
POSThttps://data-cleaner.com/clean/v1/columnClean a column of valuesoptional
GEThttps://data-cleaner.com/clean/v1/valueClean one valueoptional
GEThttps://data-cleaner.com/clean/v1/typeInfer the type of one value without cleaning itoptional
POSThttps://data-cleaner.com/clean/v1/typesInfer the common type of an array of values without cleaning themoptional
GEThttps://data-cleaner.com/clean/v1/datetimeClean one datetime stringrequired
POSThttps://data-cleaner.com/clean/v1/datetimeClean a column of datetime stringsrequired
GEThttps://data-cleaner.com/clean/v1/healthLiveness: this process is upnone
GEThttps://data-cleaner.com/clean/v1/infoThe two caps, the accepted entity hints and the auth schemenone