Happytails.aiFree tools. No account needed.

JSON to excel | agent view

The same page content and links, with explicit tool capabilities. Tools marked with an API can run directly through HTTP. Other tools require the browser interface or are not connected yet.

Tool capabilities

{
  "id": "json-to-excel",
  "category": "data-tools",
  "built": true,
  "requirements": "Flatten records, select columns and preserve identifiers and dates.",
  "implementation": {
    "fields": [
      {
        "key": "sheet",
        "label": "Worksheet name (blank = first)",
        "value": "",
        "type": "text"
      },
      {
        "key": "delimiter",
        "label": "CSV separator",
        "value": ",",
        "type": "select",
        "values": [
          ",",
          ";",
          "\t"
        ]
      }
    ],
    "note": "CSV cells are stored as text to preserve leading zeros and prevent formula execution. Nested JSON values become JSON strings.",
    "experience": {
      "automatic": false,
      "single": false,
      "label": "JSON",
      "placeholder": "{\"name\":\"Ada\",\"count\":2}",
      "help": "Use double-quoted property names and valid JSON values. Up to 1,000,000 characters. Review the settings before running.",
      "action": null
    },
    "mode": "explicit",
    "interactive": false
  },
  "execution": "POST /api/v1/tools/json-to-excel/run",
  "api": {
    "id": "json-to-excel",
    "name": "JSON to excel",
    "category": "data-tools",
    "description": "Flatten records, select columns and preserve identifiers and dates.",
    "notes": "CSV cells are stored as text to preserve leading zeros and prevent formula execution. Nested JSON values become JSON strings.",
    "human_path": "/en/data-tools/json-to-excel/",
    "method": "POST",
    "endpoint": "/api/v1/tools/json-to-excel/run",
    "schema_url": "/api/v1/tools/json-to-excel",
    "input_schema": {
      "type": "object",
      "additionalProperties": false,
      "properties": {
        "input": {
          "type": "string",
          "maxLength": 1000000,
          "default": "",
          "description": "Plain text input. File tools use files instead unless otherwise documented."
        },
        "options": {
          "type": "object",
          "additionalProperties": false,
          "properties": {
            "sheet": {
              "type": "string",
              "description": "Worksheet name (blank = first)",
              "default": ""
            },
            "delimiter": {
              "type": "string",
              "description": "CSV separator",
              "default": ",",
              "enum": [
                ",",
                ";",
                "\t"
              ]
            }
          }
        }
      }
    },
    "output_schema": {
      "type": "object",
      "required": [
        "tool",
        "result"
      ],
      "properties": {
        "tool": {
          "type": "string"
        },
        "result": {
          "type": "object",
          "required": [
            "text",
            "files"
          ],
          "properties": {
            "text": {
              "type": [
                "string",
                "null"
              ]
            },
            "data": {
              "description": "Parsed JSON when the textual result is JSON."
            },
            "name": {
              "type": "string"
            },
            "mime": {
              "type": "string"
            },
            "files": {
              "type": "array",
              "items": {
                "type": "object",
                "required": [
                  "name",
                  "mime",
                  "bytes",
                  "base64"
                ],
                "properties": {
                  "name": {
                    "type": "string"
                  },
                  "mime": {
                    "type": "string"
                  },
                  "bytes": {
                    "type": "integer"
                  },
                  "base64": {
                    "type": "string",
                    "contentEncoding": "base64"
                  }
                }
              }
            }
          }
        }
      }
    },
    "processing": "Server; same transformation code as browser tools",
    "limits": {
      "request_bytes": 8388608,
      "input_characters": 1000000,
      "files_bytes": 5242880,
      "max_files": 0,
      "timeout_seconds": 12
    }
  },
  "agent_processing": "Server; same transformation code as browser tools",
  "browser_agent": {
    "supported": true,
    "name": "run_current_tool",
    "discovery": "WebMCP on the human page in a supporting browser",
    "verification": "See audit/API-AUDIT.md; availability is not verification"
  }
}

Page guide

Flatten records, select columns and preserve identifiers and dates..

Useful next steps

How to use JSON to excel

  1. Enter json in the input field.
  2. Review the settings, then choose Run JSON to excel.
  3. Review the result, then use Copy result or a download link when available.

Working with json to excel

JSON represents structured values and nested objects. CSV and TSV represent rows and columns, making them convenient for spreadsheets and bulk imports. Moving between these formats changes what can be represented directly: a nested object needs a defined mapping to a flat table.

Common questions

Can JSON and CSV make a lossless round trip?

Not in every case. CSV does not carry JSON data types or nested structure. Decide how numbers, nulls, missing values and nested arrays should be represented rather than assuming a reverse conversion restores them.

Why does a comma create an extra column?

A separator inside a cell must be quoted using the rules of the file format. Newlines and quotation marks inside cells also need proper escaping. Changing the delimiter can help, but it does not repair malformed quoting.

Continue your workflow: Excel to CSV, CSV to excel, Excel to JSON.