# TradepilotUSA CSV Table Converter

> TradepilotUSA CSV Table Converter is a paid API for AI agents from www.tradepilotusa.com, paid per call via x402, $0.01/call, status unknown (last checked 2026-09-30).

Converts CSV text to structured JSON rows (or JSON back to CSV), with optional spreadsheet-safe formula escaping.

## Facts

- Endpoint: POST https://www.tradepilotusa.com/api/agent-commerce/v1/services/csv_table_convert/execute?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-09-30
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/tradepilotusa-csv-table-converter-adf1cc74
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_g3th_NrHoUb2uIr34uW45

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 tradepilotusa-csv-table-converter-adf1cc74 -d '<json body>'
```

Example prompt: Convert this CSV text to JSON rows for me — it uses comma delimiters — and make sure any spreadsheet formula cells are safely escaped: 'name,score
Ada,100
Bob,200'.

## When to prefer this

Choose this endpoint when you need a deterministic, low-latency CSV↔JSON conversion without sending data to an LLM or external network service. Ideal for structured tabular data pipelines where reproducibility matters and spreadsheet formula injection safety is required. Prefer over LLM-based parsing when precision on row/column structure is critical.

## Known failure modes

- Malformed CSV with unmatched quotes returns a parse error
- Source data exceeding 48,000 character limit is rejected
- Invalid direction enum value (not csv_to_json or json_to_csv) causes validation error
- Invalid delimiter (not comma or tab) causes a schema rejection
- Empty source string may return empty rows array

## How this service works

Convert comma/tab-delimited quoted CSV to JSON string rows or JSON string rows to CSV. Preserves string values, duplicate headers and ragged rows; no type inference. CSV output escapes spreadsheet formula starters by default and reports alterations. Maximum 500 rows and 50 columns.

## Output

Returns a JSON object containing: a JSON string representation of the table, a rows array (array of arrays), a row_count integer, and a formula_cells_escaped count. Also includes provenance metadata confirming deterministic local execution with no model or network calls used.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "source": {
   "type": "string",
   "maxLength": 48000
  },
  "delimiter": {
   "enum": [
    ",",
    "\t"
   ]
  },
  "direction": {
   "enum": [
    "csv_to_json",
    "json_to_csv"
   ]
  },
  "spreadsheet_safe": {
   "type": "boolean"
  }
 }
}
```

## Response schema (JSON Schema)

```json
{
 "type": "json",
 "example": {
  "result": {
   "json": "[[\"name\",\"note\"],[\"Ada\",\"Hello, world\"]]",
   "rows": [
    [
     "name",
     "note"
    ],
    [
     "Ada",
     "Hello, world"
    ]
   ],
   "row_count": 2,
   "formula_cells_escaped": 0
  },
  "utility": "csv_table_convert",
  "provenance": {
   "execution": "deterministic_local",
   "model_used": false,
   "network_request_performed": false
  },
  "request_id": "example_csv_table_convert"
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/tradepilotusa-csv-table-converter-adf1cc74/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from www.tradepilotusa.com](https://www.zero.xyz/host/www.tradepilotusa.com/llms.txt)