Skip to main content
Glama

files_convert_to_table

Converts a rectangular range of cells into a structured data table (like an Excel Table): named, with column headers, sortable. Only use when the user explicitly requests a data table or the file already uses data tables; otherwise keep the data as plain cells. range must be a single rectangle (e.g. 'A1:D20') and must NOT overlap an existing table or code-cell output. first_row_is_header (default true): use the first row as the column names; false generates 'Column 1', 'Column 2', … and keeps all rows as data. table_name: optional (auto-generated if omitted). Requires edit permission. Signature: files_convert_to_table(file_uuid, range, table_name?, first_row_is_header?, sheet?).

Tool call template

Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.

{
  "id": 1,
  "jsonrpc": "2.0",
  "method": "tools/call",
  "params": {
    "arguments": {
      "file_uuid": "<file_uuid>",
      "range": "<range>"
    },
    "name": "files_convert_to_table"
  }
}

Input Schema

NameRequiredDescriptionDefault
rangeYesA1 rectangle to convert, e.g. 'A1:D20'.
sheetNoSheet name (defaults to the first sheet).
file_uuidYes
table_nameNoName for the table (auto-generated if omitted).
first_row_is_headerNoUse the first row as column names (default true).

Output Schema

NameRequiredDescriptionDefault
rangeYes
file_uuidYes
sequence_numberYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observed

TDQS

A4.3/5.0
Behavior4/5

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

Annotations already declare readOnlyHint=false, idempotentHint=false and destructiveHint=false, so the description needn't restate the safety profile. It adds real context the annotations cannot: an edit permission is required and the range must not overlap an existing table or code-cell output. It does not say what happens on retry or whether an existing table in the way causes an error versus a silent shift.

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 key discriminator (when to use vs. keep plain cells) is front-loaded, and the constraint and parameter sentences follow in a logical order. The trailing signature line restates the schema and is somewhat redundant, though it aids scanning.

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?

With an output schema present, return values need no explanation, and the description covers prerequisites, range constraints, defaults, and naming fallback. The main residual gap is error behavior when the range overlaps or the table name collides.

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 coverage is 80%, so the schema already documents range, sheet, table_name, and first_row_is_header. The description still adds value: the rectangle constraint and no-overlap rule for range, and the fallback naming behavior ("Column 1", "Column 2", …) when first_row_is_header=false, which is not in the schema.

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?

States a concrete verb and resource ("Converts a rectangular range of cells into a structured data table") and grounds it with an analogy ("like an Excel Table") plus the properties it gains (named, headers, sortable). That distinguishes it from plain cell writing and from table-adjacent siblings such as files_flatten_table or files_add_table.

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

Usage Guidelines4/5

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

Gives an explicit inclusion/exclusion rule: only when the user explicitly requests a data table or the file already uses them, otherwise keep plain cells. It stops short of naming the concrete sibling alternatives (e.g. files_add_table, files_flatten_table) the way a top-tier definition would.

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

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.

Resources