Skip to main content
Glama
senoff

xlsx-for-ai

xlsx_data_clean

Identify and fix common data quality issues in Excel files (NA variants, merged cells, type errors, trailing noise, etc.) using diagnose or execute modes.

Instructions

AI-native data cleaning for a LOCAL .xlsx file. Scans for the seven most common data-grime issues — NA variants (N/A, NA, null, -), merged-cell residue, type-coercion mistakes (numeric-as-text / date-as-serial / leading-zero stripped), trailing-row noise (footers / totals), header-row-not-first (preamble before headers), encoding glitches (UTF-8-as-CP1252 mojibake), and duplicate column headers — and either flags them (diagnose mode) or applies deterministic fixes (execute mode).

Informer-not-enforcer: every fix surfaces as a Finding the caller can accept / reject / scope-override before the file is mutated.

USE WHEN: an upstream pipeline produced a messy xlsx that's about to feed an LLM or downstream analysis and you want a one-pass scrub.

DO NOT USE WHEN: domain-specific transforms are needed (use a dedicated pipeline). Or for structural integrity checks (use xlsx_doctor). Or for upload/attached files.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
accept_findingsNo
detectorsNo
file_b64Yes
modeNo
optionsNo
overridesNo
reject_findingsNo
sheetsNo
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Discloses key behaviors beyond annotations: informer-not-enforcer pattern (findings for accept/reject/override), diagnose vs execute modes. Annotations show destructiveHint=false and readOnlyHint=false, but description contextualizes mutation with user consent, adding valuable transparency.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Two focused paragraphs: first describes functionality, second usage guidance. Every sentence adds value, no redundancy. Front-loaded with key actions.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given complexity (8 params, no output schema), description covers purpose, usage, behavior, and parameter context well. Missing details on return format (e.g., Finding structure) and file limitations, but sufficient for high-level understanding.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema has 0% description coverage; description compensates by explaining mode, options, and workflow (diagnose/execute, findings, overrides) but does not explicitly detail each parameter or their types, leaving some interpretation to the schema. Still provides meaningful semantic context.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's purpose: AI-native data cleaning for local .xlsx files, listing seven specific data issues it addresses. It explicitly distinguishes from siblings (e.g., xlsx_doctor, dedicated pipelines), making purpose unambiguous.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Explicitly provides when to use (upstream messy xlsx for LLM/analysis) and when not to use (domain transforms, structural checks, uploads), with specific sibling alternatives, offering excellent guidance.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Install Server

Other Tools

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/senoff/xlsx-for-ai'

If you have feedback or need assistance with the MCP directory API, please join our Discord server