CSV Pivot Table

Open CSV Pivot Table on Happytails.ai. This view has the same page content and links, with explicit tool capabilities. Read the processing notes before using a tool.

Tool capabilities

{
  "id": "csv-pivot",
  "category": "spreadsheet-tools",
  "built": true,
  "requirements": "Row/column groups, counts/sums, blank handling and export.",
  "implementation": {
    "fields": [
      {
        "key": "delimiter",
        "label": "CSV separator",
        "value": ",",
        "type": "select",
        "values": [
          ",",
          ";",
          "\t"
        ]
      },
      {
        "key": "group",
        "label": "Group by column",
        "value": "category",
        "type": "text"
      },
      {
        "key": "value",
        "label": "Sum column",
        "value": "amount",
        "type": "text"
      }
    ],
    "experience": {
      "automatic": true,
      "single": false,
      "inputMaxLength": 1000000,
      "inputMode": "text",
      "label": "CSV",
      "placeholder": "name,score\nAda,98\nSam,92",
      "help": "Include a header row. Quote cells that contain commas or new lines. Results update as you type. Up to 1,000,000 characters.",
      "helpParts": [
        "Include a header row. Quote cells that contain commas or new lines.",
        "Results update as you type.",
        "Up to 1,000,000 characters."
      ],
      "action": null
    },
    "mode": "automatic",
    "interactive": false
  },
  "execution": "POST /api/v1/tools/csv-pivot/run",
  "api": {
    "id": "csv-pivot",
    "name": "CSV pivot",
    "category": "spreadsheet-tools",
    "description": "Row/column groups, counts/sums, blank handling and export.",
    "notes": "",
    "human_path": "/en/spreadsheet-tools/csv-pivot/",
    "method": "POST",
    "endpoint": "/api/v1/tools/csv-pivot/run",
    "schema_url": "/api/v1/tools/csv-pivot",
    "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": {
            "delimiter": {
              "type": "string",
              "description": "CSV separator",
              "default": ",",
              "enum": [
                ",",
                ";",
                "\t"
              ]
            },
            "group": {
              "type": "string",
              "description": "Group by column",
              "default": "category"
            },
            "value": {
              "type": "string",
              "description": "Sum column",
              "default": "amount"
            }
          }
        }
      }
    },
    "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