Give every value
a clean edge.
Remove leading and trailing spaces from text cells. Nested values stay untouched.
INVOKEPORT / DATA CLEANER
The next step shouldn’t be another hour in a spreadsheet.
Trim the spaces. Drop exact duplicates. Convert the types you choose. Get clean JSON — and a record of what changed.
The sample is free. Your own data is priced per call.
| # | sku | name | price | stock | active |
|---|---|---|---|---|---|
| 01 | SKU-101 | Desk lamp | 39.00 | 12 | true |
| 02 | SKU-102 | Wall clock | 24.50 | 8 | true |
| 03 | SKU-101 | Desk lamp | 39.00 | 12 | true |
| 04 | SKU-103 | Felt tray | 18.00 | 20 | false |
| 05 | SKU-104 | Paper vase | TBD | 6 | true |
| 06 | SKU-102 | Wall clock | 24.50 | 8 | true |
Each combination is precomputed by the real Data Cleaner engine on this fixed sample. Your own data uses the paid tool.
01 / MAKE THE HANDOFF CLEANER
No mysterious “AI fix”. You pick the rules. The tool records the changes.
Remove leading and trailing spaces from text cells. Nested values stay untouched.
Opt in to exact-row deduplication after normalization. The first occurrence wins.
Explicit number, integer, boolean and date rules. Ambiguous values are preserved with warnings.
02 / KNOW WHAT CHANGED
Cleaning should make data easier to trust, not harder to explain.
SAMPLE RUN · ALL THREE RULES
ROWS IN ROWS OUT
Uncertain? Leave it visible.
“TBD” could not become a price.
The original value is preserved.
FIXED EXAMPLE. REAL ENGINE. NO CHARGE.
03 / FROM ONE EXPORT TO A WORKFLOW
Try your own CSV or JSON in the tool. Or call the same endpoint from an application or payment-capable agent.
01Supply a small CSV or JSON batch
02Set explicit rules and review the price
03Authorize one call. Keep the result.
Paid calls require a Base wallet / x402 payment authorization. An ordinary API key or free MCP connection does not authorize spending.
POST /api/gateway/invokeport-cleaner/clean
{
"csv": "name,stock\n Desk lamp ,12",
"options": {
"trim": true,
"deduplicate": true,
"types": {
"stock": "integer"
}
}
}Open the API reference A SMALL TOOL. A CLEAR PRICE.
0.022223 USDC
per call · platform fee included
Open Data CleanerUp to 500 rows · 32 CSV columns / 64 JSON fields · 128 KiB total JSON input. The exact quote is authoritative. Payment settles before delivery; no automatic refund.
BEFORE YOU BEGIN
Yes. The fixed example on this page is free and needs no account or wallet. Every rule combination comes from the same engine as the paid tool. Submitting your own data uses the paid endpoint.
No. It trims text, removes exact duplicate rows when requested, and applies explicit type conversions. It does not validate email deliverability, guess missing values, map your destination’s fields or guarantee that an import will succeed.
The tool accepts a CSV string or JSON rows inside a JSON request and returns JSON. It does not accept XLSX files or directly upload data to another service. Export an Excel sheet as CSV first; adapt the cleaned JSON to your destination.
Input and result bodies are not retained by InvokePort. Operational metadata and hashes may be recorded. No external provider is called. Do not submit credentials or unnecessary personal data.
Keep your exact original request. Eligible confirmed purchases support hash-verified recovery for 30 days through Purchases without another payment, subject to tool availability and execution controls. Do not automatically repeat a request whose payment outcome is unknown.