Skip to main content
Glama

netcafe-tables

read xlsx

read_xlsx

Read an Excel .xlsx workbook (by URL) into rows — every sheet, or one you name. Returns cell values (not formula text), dates as YYYY-MM-DD instead of Excel serial numbers, and keeps leading zeros so ID/postcode columns are not silently mangled. Says plainly which sheet it used, which sheets are hidden, and where merged cells left blanks, instead of guessing for you.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
urlNo
sheetNo
inlineNo
max_rowsNo
preview_rowsNo
keep_formulasNo

TDQS

A3.7/5.0
Behavior4/5

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

With no annotations, the description carries the full burden and does well: it discloses that formula text is not returned, dates are converted, leading zeros are preserved, and it explicitly reports hidden sheets/merged-cell gaps. It lacks details on errors or access limits, but the key behaviors are clearly surfaced.

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?

Two dense sentences front-load the core purpose and each clause adds a distinct behavioral detail. It is appropriately sized for the amount of useful content, though slightly long due to its list of edge-case behaviors.

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

Completeness3/5

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

The description provides strong context about output formatting and edge-case handling, which is valuable given no output schema or annotations. However, it fails to explain several parameters and does not describe the row structure, so it is only partially complete for effective use.

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

Parameters2/5

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

Schema description coverage is 0%, yet the description only hints at url, sheet, and keep_formulas (via 'formula text'). Parameters such as inline, max_rows, and preview_rows are not mentioned or explained, leaving substantial gaps for a 6-parameter tool.

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 opening phrase 'Read an Excel .xlsx workbook (by URL) into rows' clearly specifies the verb, resource, and input method. The detail about 'every sheet, or one you name' further distinguishes it from siblings like write_xlsx and CSV-focused tools.

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

Usage Guidelines3/5

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

The description implies usage context (URL-based xlsx reading, sheet selection) but provides no explicit when-to-use vs alternatives or any exclusions. It doesn't mention not using it for CSV files or local paths, so guidance is only implicit.

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.

TDQS

A3.8/5.0
Disambiguation4/5

Most tools have clearly distinct functions (conversions, cleaning, xlsx I/O, reconciliation), but diff_tables, reconcile_ledger, and match_transactions all involve comparing or matching records, which could cause initial confusion. However, each has a specific use case—generic column diff, amount-focused reconciliation, and keyless fuzzy matching—and the descriptions provide enough detail to disambiguate them.

Naming Consistency4/5

The conversion tools follow a consistent 'csv_to_*' or 'json_to_csv' pattern, while operation tools use a verb_noun style (e.g., clean_table, merge_tables, reconcile_ledger). This dual pattern is predictable by function type, but 'what_can_you_do' breaks convention as a question-like meta-tool, so the naming is mostly consistent with a minor deviation.

Tool Count5/5

With 15 tools, the server sits at the upper edge of the well-scoped range, but each tool earns its place in the CSV/spreadsheet domain—covering conversions, cleaning, merging, diffing, reconciliation, matching, and Excel I/O. The count feels appropriate for the server's broad yet focused scope.

Completeness5/5

The toolset covers the full lifecycle of table manipulation: reading (read_xlsx), encoding repair, cleaning and transforming (clean_table), merging (merge_tables), comparing (diff_tables, reconcile_ledger), matching without keys (match_transactions), entity deduplication, and output to various formats (JSON, MD, chart, QBO, XLSX). No obvious gaps are evident for common tasks.