JSON to CSV API

JSON to CSV API examples

Choose a language, set TABLECONVERT_API_KEY in your environment, and run the request. Each example saves the CSV response to output.csv.

curl --fail-with-body --max-time 40 \
  'https://api.tableconvert.com/v2/convert/json-to-csv' \
  --header "Authorization: Bearer $TABLECONVERT_API_KEY" \
  --form-string 'data=[{"name":"Alice","email":"alice@example.com","active":true},{"name":"Bob","email":"bob@example.com","active":false}]' \
  --output output.csv

import json
import os
from pathlib import Path
import requests

rows = [
    {"name": "Alice", "email": "alice@example.com", "active": True},
    {"name": "Bob", "email": "bob@example.com", "active": False},
]

response = requests.post(
    "https://api.tableconvert.com/v2/convert/json-to-csv",
    headers={
        "Authorization": f"Bearer {os.environ['TABLECONVERT_API_KEY']}"
    },
    files={"data": (None, json.dumps(rows))},
    timeout=40,
)
response.raise_for_status()
Path("output.csv").write_bytes(response.content)

import { writeFile } from "node:fs/promises";

const rows = [
  { name: "Alice", email: "alice@example.com", active: true },
  { name: "Bob", email: "bob@example.com", active: false },
];

const form = new FormData();
form.set("data", JSON.stringify(rows));

const response = await fetch(
  "https://api.tableconvert.com/v2/convert/json-to-csv",
  {
    method: "POST",
    headers: {
      Authorization: "Bearer " + process.env.TABLECONVERT_API_KEY,
    },
    body: form,
    signal: AbortSignal.timeout(40_000),
  },
);

if (!response.ok) {
  throw new Error("HTTP " + response.status + ": " + await response.text());
}
await writeFile("output.csv", Buffer.from(await response.arrayBuffer()));

Request parameters

Send multipart/form-data. Choose one input source: data, file or url. Do not manually set the Content-Type header; your HTTP client adds the multipart boundary.

One input required

CSV output options

Add these optional form fields to control the CSV output. The defaults below match this page’s sample.

Nested JSON and field mapping

This endpoint converts tabular records. Check these mapping rules before exporting data from an API, database or application.

Need columns from nested JSON?

Prepare the fields you want before making the request. This example turns profile.city into a city column; it does not require a flatten API parameter.

const records = [
  { name: "Alice", profile: { city: "London" } },
];

const rows = records.map(({ name, profile }) => ({
  name,
  city: profile.city,
}));
// Send JSON.stringify(rows) in the data form field.

Responses and errors

Check the HTTP status before saving the response. Successful v2 responses use text/plain; error bodies contain a plain-text message.

Limits and usage

File uploads support up to 50 MiB (52,428,800 bytes). An individual multipart text field is limited to 1 MiB; use file upload for larger JSON. The v2 processing deadline is 30 seconds.

A successful standard JSON to CSV conversion uses 1 credit. Failed or timed-out conversions release the reserved credit. Legacy account terms may differ; check your account and current pricing.

Questions before you integrate