Read a CSV, Excel or OpenDocument sheet into JSON rows keyed by the header. Separator guessed (; , tab), German and English numbers become numbers.
curl -X POST https://api.bigapi.dev/v1/table/to-json -H 'Authorization: Bearer $KEY' -F 'file=@prices.csv'New keys come with 100 free operations, no signup: curl -X POST https://api.bigapi.dev/v1/keys. Failed calls cost nothing.
| Name | Meaning |
|---|---|
file required | CSV, TSV, XLSX, XLS or ODS file to read. |
sheet | Sheet to read, by name or number (1 is the first sheet). CSV has only one. Default: first sheet |
header | true uses the first row as field names; false returns every row as a plain list. Default: true |
Returns application/json. Response headers carry the cost (X-BigAPI-Cost) and notes about your input (X-BigAPI-Warnings).
Connect BiGapi as an MCP server: https://api.bigapi.dev/mcp (hosted) or npx -y @bigapi/mcp (local). Then ask in plain words; the agent finds table_to_json on its own.