happytails.ai

Data dictionary generator

Open Data dictionary generator 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": "data-dictionary-generator",
  "category": "data-tools",
  "built": true,
  "requirements": "The dictionary contains observed types, empty counts, distinct counts and optional descriptions. It excludes raw example values. Inference cannot recover undocumented business meanings. Up to 1,000,000 characters, 10,000 data records, 100 columns and 100,000 cells across the sources. Files for multi-source tools are limited to 4,000,000 bytes total. Reports retain at most 500 diagnostic findings and state any omitted count. CSV and JSON outputs are limited to 4,000,000 characters.",
  "implementation": {
    "fields": [
      {
        "key": "separator",
        "label": "Input CSV separator",
        "value": ",",
        "type": "select",
        "values": [
          ",",
          ";",
          "\t"
        ]
      },
      {
        "key": "descriptions",
        "label": "Field descriptions (JSON)",
        "value": "{}",
        "type": "textarea",
        "help": "An object mapping exact column names to editable descriptions, for example {\"id\":\"Customer identifier\"}."
      },
      {
        "key": "outputSafety",
        "label": "CSV output cells",
        "value": "Protect spreadsheet cells",
        "type": "select",
        "values": [
          "Protect spreadsheet cells",
          "Preserve original cells"
        ]
      }
    ],
    "live": true,
    "presentation": "metrics",
    "note": "Runs locally on your device. CSV requires unique nonempty headers. Up to 1,000,000 characters, 10,000 data records and 100,000 cells across inputs, with 100 columns. Quoted multiline cells are supported. Each JSON settings field is limited to 100,000 characters. Output files are bounded to 4,000,000 characters. Diagnostic reports contain at most 500 findings and disclose the omitted count. Download an editable CSV field catalogue containing observed types, empty counts, distinct counts and your descriptions. Raw example cell values are not included. Protect spreadsheet cells prefixes formula-like values, including negative numbers, with an apostrophe. Choose Preserve original cells only for a trusted import workflow.",
    "experience": {
      "automatic": true,
      "single": false,
      "inputMaxLength": 1000000,
      "inputMode": "text",
      "label": "CSV data",
      "placeholder": "id,name\n1,Alpha\n2,Beta",
      "help": "Paste CSV data with unique column headers. Quoted multiline cells are supported. Results update as you type. Up to 1,000,000 characters.",
      "helpParts": [
        "Paste CSV data with unique column headers. Quoted multiline cells are supported.",
        "Results update as you type.",
        "Up to 1,000,000 characters."
      ],
      "action": null
    },
    "mode": "automatic",
    "interactive": false
  },
  "execution": "Browser interface",
  "api": null,
  "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

Turn CSV headers and observed values into an editable field catalogue with descriptions.

How to use Data dictionary generator
  1. Paste a representative CSV export.
  2. Add descriptions as a JSON object keyed by the exact column names.
  3. Download the field dictionary as CSV and edit it in your spreadsheet.

Useful next steps

Prepare the source

Paste a representative CSV export.

Choose the matching rules

Add descriptions as a JSON object keyed by the exact column names.

Review and keep the result

Download the field dictionary as CSV and edit it in your spreadsheet. The dictionary contains observed types, empty counts, distinct counts and optional descriptions. It excludes raw example values. Inference cannot recover undocumented business meanings.