Skip to main content
Glama

Excel Create Table

excel_create_table
Read-only

Convert a cell range in an Excel worksheet into a structured table, with optional headers, custom table name, and SharePoint site or drive selection.

Instructions

Create a structured table within a range of an Excel worksheet.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
addressYesCell range for the table (e.g. 'A1:D1' or 'A1:D10').
site_idNoOptional SharePoint Site ID.
drive_idNoOptional SharePoint Drive ID.
table_nameNoOptional custom table name (e.g. 'SalesData').
has_headersNoWhether the first row contains column headers (default True).
worksheet_nameYesWorksheet name (e.g. 'Sheet1').
item_id_or_pathYesDrive item ID or file path (e.g. '/Reports/Sales.xlsx').

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
resultYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv0.1.0

TDQS

C2.7/5.0
Behavior1/5

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

The description directly contradicts the annotations: it says 'Create' which implies a mutating operation, while annotations declare readOnlyHint: true and destructiveHint: false. Although the description is otherwise transparent about creating a table, the contradiction with structured metadata is a serious flaw that prevents reliable agent decision-making.

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

Conciseness4/5

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

The description is a single clear sentence with no filler or redundant wording. It is appropriately front-loaded with the core action and object. Only a slight loss for being too brief to carry behavioral context independently.

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

Completeness2/5

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

An output schema exists, so return values do not need explaining, and the input schema is well-covered. However, the annotation contradiction leaves the tool's actual mutating behavior undisclosed, and there is no mention of preconditions, side effects, or how the table relates to existing worksheet data. This is insufficient for safe autonomous use.

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

Parameters3/5

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

The input schema covers 100% of parameters with meaningful descriptions, so the baseline of 3 applies. The tool description itself adds no parameter-level meaning beyond what the schema already provides. It does not repeat or expand on details like address range, headers, or optional identifiers.

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

Purpose4/5

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

The description uses a specific verb and resource: 'Create a structured table within a range of an Excel worksheet.' This clearly distinguishes the tool from siblings like excel_add_table_rows or excel_list_workbooks. It does not explicitly name a sibling, but the core action and target are unmistakable.

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

Usage Guidelines2/5

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

No guidance is given about when to use this tool versus alternatives, such as when a table should be created versus when rows should be added to an existing table. The description simply states the action with no context about prerequisites, typical workflow, or exclusions.

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