Convert a JSON array of objects into a clean RFC 4180 CSV

Convert a JSON array of objects into a clean RFC 4180 CSV: header row, CRLF records, correct quoting and quote-doubling. Nested objects flatten to dot-notation columns (a.b.c), arrays are JSON-encoded into their cell, and you can select and order columns explicitly. Delimiter: comma, semicolon, tab or pipe. Caps: 100,000 rows, 5 MB body, 20 MB CSV out. Returns text/csv ready for Excel, Google Sheets or a data pipeline.

Paid test badge: not yet. The checks above are free: we call the tool without paying and read the payment request it sends back. The Verified badge needs paid calls whose answers match the promised output, and nobody can buy a badge.

Endpoint

POST https://402utils.com/v1/json-to-csv

Our checks, last 30 days

Example input (from the provider)

{
  "body": {
    "delimiter": ",",
    "rows": [
      {
        "city": "Orl\u00e9ans",
        "name": "Jeanne d'Arc",
        "stats": {
          "active": true,
          "score": 9.5
        }
      },
      {
        "name": "Jos\u00e9",
        "tags": [
          "vip",
          "beta"
        ]
      }
    ]
  },
  "bodyType": "json",
  "method": "POST",
  "type": "http"
}

Promised output schema (from the provider)

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "properties": {
    "input": {
      "additionalProperties": false,
      "properties": {
        "body": {
          "description": "Either this object form, or the bare `rows` array itself as the whole JSON body (defaults then apply).",
          "properties": {
            "columns": {
              "description": "Optional column selection and order (flattened dot-notation names). Unknown names produce empty cells. Omit to use the union of all flattened row keys in first-seen order.",
              "items": {
                "type": "string"
              },
              "type": "array"
            },
            "delimiter": {
              "default": ",",
              "description": "Field separator.",
              "enum": [
                ",",
                ";",
                "\t",
                "|"
              ],
              "type": "string"
            },
            "rows": {
              "description": "1\u2013100,000 plain JSON objects, one per CSV record. Nested objects flatten to dot-notation column names; arrays are JSON-encoded into their cell; null becomes an empty cell.",
              "items": {
                "type": "object"
              },
              "maxItems": 100000,
              "minItems": 1,
              "type": "array"
            }
          },
          "required": [
            "rows"
          ],
          "type": "object"
        },
        "bodyType": {
          "enum": [
            "json",
            "form-data",
            "text"
          ],
          "type": "string"
        },
        "method": {
          "enum": [
            "POST"
          ],
          "type": "string"
        },
        "type": {
          "const": "http",
          "type": "string"
        }
      },
      "required": [
        "type",
        "method",
        "bodyType",
        "body"
      ],
      "type": "object"
    },
    "output": {
      "properties": {
        "example": {
          "contentMediaType": "text/csv",
          "description": "The response body is the CSV file (Content-Type: text/csv; charset=utf-8, Content-Disposition: attachment; filename=\"data.csv\"). CRLF record separators, trailing CRLF included.",
          "type": "string"
        },
        "type": {
          "type": "string"
        }
      },
      "required": [
        "type"
      ],
      "type": "object"
    }
  },
  "required": [
    "input"
  ],
  "type": "object"
}

This page as JSON