Clean the data. Keep the decisions visible.
Clean a supplied CSV or JSON batch with explicit trim, type and exact-deduplication rules. Receive cleaned JSON, original row indices and a change journal. Ambiguous conversions produce warnings.
See CSV cleaning in action — interactive before & after ↗See a real example result
Calculated by the same tool engine on this fixed synthetic example. No account, payment or external provider call. Use the tool page to submit your own input.
Input · JSON
{
"rows": [
{
"id": "1",
"name": " Alpha ",
"active": "true"
},
{
"id": "1",
"name": "Alpha",
"active": "true"
},
{
"id": "002",
"name": " Beta ",
"active": "maybe"
}
],
"options": {
"trim": true,
"deduplicate": true,
"types": {
"id": "integer",
"active": "boolean"
}
}
}Output · JSON
Reveal the result to inspect the output format before using the tool.
What you receive
- Cleaned JSON rows and original row mapping
- Exact duplicate removal only when requested
- Change journal, warning counts and reproducible hashes
Scope & limits
- Exactly one of rows or csv. Up to 500 rows, 64 JSON fields / 32 CSV columns, 128 KiB input.
- Top-level changes only. Explicit types: number, integer, boolean, iso-date. Dates must be YYYY-MM-DD; ambiguous conversions are skipped.
- Keep your original input; no source or output body is retained. First occurrence wins when deduplication is enabled.
Use it in your workflow
- Supply CSV or JSON rows.
- Choose explicit trimming, conversion and deduplication rules.
- Receive cleaned JSON and a traceable change journal.
API schemas and request examples are on the tool reference. Read the authentication and payment guide.
Your data & delivery
Submitted input and result bodies are not stored by InvokePort. Operational metadata and hashes may be recorded. Do not submit credentials or unnecessary personal data.
Keep your exact original JSON. New confirmed purchases support hash-verified result recovery for 30 days through Purchases, without another payment. Recovery remains subject to tool availability and execution controls.
Delivery problem? Contact support with the request ID.