JSON to CSV

Overview

When you send a JSON array or object (inline or file_ref), we flatten nested fields with your path separator and emit RFC 4180 CSV with deterministic header ordering. Arrays can stay as JSON strings, stringify as text, or explode into rows when unambiguous — do not use explode when multiple array fields would conflict.

LLM CSV conversion drops fields and mishandles nesting. We flatten deterministically.

When to use it

Scope

Non-goals

• Does not parse CSV back to JSON
• Does not fetch remote JSON

Properties

Capabilities

Cost & billing

Flat rate per invocation

File handling

File limits

Constraints this skill applies to your input and generated files. The “Limited by” column shows the static source of each cap; none of these can be raised by upgrading your plan.

How we handle your data

Input schema

Output schema

API contract

curl -sS -X POST "$BASE/v1/execute" -H "Authorization: Bearer $KEY" -H 'Content-Type: application/json' -d '{"skillKey":"data.convert_json_csv","input":{"json":[{"id":1,"name":"Alice"}]}}'

import { Squillify } from "@squillify/sdk";

const sq = new Squillify({ apiKey: process.env.SQUILLIFY_API_KEY });

const { output } = await sq.execute("data.convert_json_csv", {"json":[{"id":1,"name":"Alice"}]});

Errors

Other limits

Limitations

• Does not parse CSV back to JSON
• Does not fetch remote JSON
• Ambiguous multi-array explode
• Datasets beyond maxRows

How to call

POST /v1/execute (requires authentication)

{
  "skillKey": "data.convert_json_csv",
  "input": {
    "json": [
      {
        "id": 1,
        "name": "Alice"
      }
    ]
  }
}

Examples

{
  "json": [
    {
      "id": 1,
      "name": "Alice"
    }
  ]
}

{
  "rowCount": 1,
  "flattening": {
    "pathSeparator": ".",
    "arrayMode": "json"
  },
  "csv": "id,name\n1,Alice\n",
  "headers": [
    "id",
    "name"
  ],
  "warnings": [],
  "columnCount": 2
}

{
  "json": [
    {
      "id": 1,
      "meta": {
        "tag": "x"
      }
    }
  ]
}

{
  "rowCount": 1,
  "flattening": {
    "pathSeparator": ".",
    "arrayMode": "json"
  },
  "csv": "id,meta.tag\n1,x\n",
  "headers": [
    "id",
    "meta.tag"
  ],
  "warnings": [],
  "columnCount": 2
}

Recommended use cases

• Spreadsheet export from API JSON
• Reporting pipelines
• Flat file exchange

Avoid for

• Ambiguous multi-array explode
• Datasets beyond maxRows

Related skills

Composable with

Safety & privacy

• Runs without calling any external service.
• Your payloads are never stored permanently.
• Telemetry captures metadata only — never your payload contents.
• We never train models on your payloads.
• No human reviews your payloads.

Tags